Get the next available date

[Ronaldo_Centuri]

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.

[Marc_Dillon]

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

help.appsheet.com

SELECT()

Gather column values from row in table or slice

help.appsheet.com

MIN()

Lowest item in list

Something like:

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