Dear Appsheet community,
I have recently faced a problem with data validity in the scheduling app. I am using the app to reserve trailers for specific events and to prevent reservations if that trailer is already booked within the required timeframe.
In order to do so, I used this example, which works well with my data and prevents me from making impossible reservations.
However, if I try to change some information about that trailer (driver/status) after it was saved, it prevents me by stating that my date selection is no longer valid, even if there aren’t any conflicts with other existing reservations. I can successfully add a new reservation with avoiding unavailable timeslots, but if I try to edit it immediately after saving it is no longer possible, resulting in “This entry is invalid” error.
I use the following Valid_if formula:
[_THISROW].[Trailer] = [Trailer],
[_THISROW].[Arrival time] >= [Packing start],
[_THISROW].[Packing start] <= [Arrival time]
Could anyone tell me how to fix this issue? Thanks in advance!
UPD: Added a screenshot