Hello dear,
I would like to know if anyone has a solution to my problem.
I would like to set up an appointment scheduling system (Make an appointment booking)
Where I select the day and time that I will use the service
and for the next user to schedule, it appears that I have already booked at a certain time.
Example:
A dropdown with a list of dates.
A dropdown with a list of schedules that I can use.
You can try creating another table named 'Options' with a column named 'Dates'. Input all the list of dates you would like to appear in the dropdown (you can create a specialised view to input these as well). Then from your original table containing the 'Dates' dropdown, ref it to the the new Options table, and the Valid If segment to input as 'Options[Dates]'. That should do the trick easily. Same goes for your schedule part.
Sorry, I'm new to the appsheet, could you help me create this logic?
User | Count |
---|---|
20 | |
13 | |
8 | |
3 | |
2 |