Good day everyone. I’m a newbie to Airtable/Fillout, coming from another app builder.
I run a small school charter service on weekends, between schools and home towns. My clients book their kids on the app. Currently I calculate the trip dates but I think a table with trip dates is easier to use. My problem is: The booking form needs to get the first available row from the dates table - the table has 3 columns for date home, date back to school and trips completed.(Clients book for both weekend dates at once, just selecting 1 or both dates.)
In my still-current app the users table is the logon validation table and its data is accessible everywhere in the app. There the dates are calculated in columns but then also checked against long weekends dates an school term dates. A lot of columns thus. So if I can get the first Date Home and the first Date School from the TripDates table where the Completed “cell” is empty, I can get rid of the calculations.
The problem obviously is that there is no relationship to the TripDates table from any other table. Any suggestions on how to get these values?
Regards