Need to make rental unavailable if rented already

AppSheet AppSheet Q&A
2

AND([Check in Date]<[Check out Date],
ISBLANK(FILTER(“RENTAL”,
AND([Room].[ID]=[_THISROW].[Room].[ID],
[Check in Date]<[_THISROW].[Check out Date],
[_THISROW].[Check in Date]<[Check out Date],
[_ROWNUMBER]<>[_THISROW].[_ROWNUMBER]))))

I had the wrong Table being filtered My bad It’s working now.

I just need to add the Time of rental in now so it’s available at check in time of 3pm same day as checkout time of 11Am

2 Likes