The Airtable Community will undergo scheduled maintenance on September 17 from 10:00 PM PST to 11:15 PM PST. During this period, you may experience temporary disruptions. We apologize for any inconvenience and appreciate your understanding.
Sep 09, 2024 03:43 AM
In the form I have a data record field where all free rooms are displayed. All occupied rooms are not displayed. However, if I have a reservation for the future, the assigned room is immediately marked as occupied even though it is still available until the specific reservation date. So far I have no idea how to solve the problem.
Solved! Go to Solution.
Sep 09, 2024 04:42 AM
Hello,
You could use a formula to check if the room is free "today":
Where the formula "free today" is:
Sep 09, 2024 04:42 AM
Hello,
You could use a formula to check if the room is free "today":
Where the formula "free today" is: