Get the next available date

AppSheet AppSheet Q&A
1

Hello.

I am trying to do an app to make reservations of buildings. When a date is already taken I want get the next available date in the “Invalid value error” text.
Can you help me with this one please, I think must be quite but I wasn’t able to find a proper solution. Thanks for any help.

2

Perhaps MIN( SELECT( … ) ) is what you’re needing.

Something like:

MIN( SELECT( table_with_dates[date_column] , availability_condition) )

2 Likes