Event Organizer

AppSheet AppSheet Q&A
, ,
1

Hello I am having troubles in what approach should I take in order to show what alternative time slots.
From my understanding is first I have a table tbookings with columns date, start time, and end time.
and another table in order to return a list of times just to inform the user what other available timeslots are available that day.
assuming i just use an inline slice to display it in the form for filling up a view using tbookings, I am still unsure how to formula would work or what approach should I use to return the available timeslots during that specific day.
Check Time Slot Availability:

  • Verify if the requested time slot is available for the tour.
  • If not available, inform the visitor and suggest alternative time slots.
2

Is the visitor filling out a form to request a tour? If so, you just need a ref column to a slice of your table with your available time slots. The slice will just need a formula to filter out the dates you wish to allow the user to select.