A way to remove choices from a dropdown once they have been chosen by a user?

  • 0
  • 1
  • Question
  • Updated 3 years ago
  • Answered

Hi

I am developing a timeslot reservation app where users can go in and reserve a time of day and date to reserve a meeting room. 

The way I want it to work is to have a dropdown that will remove choices based on whether or not they have been chosen.

Example - 

When: User chooses Monday from a Mon-Friday Dropdown > User Chooses 2:00 from an hourly dropdown> Saves Reservation

Then:  2:00 choice to be removed for the next user that tries to make a new Reservation. 

Is this a possibility? Or does anyone else have any other suggestions on how to achieve the same outcome?

Thank you kindly,

Brian

Photo of Brian

Brian

  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 65,664 Points 50k badge 2x thumb
I don't think that I can take the time to post step by step instructions, but in general what I would do is to load up form excel all the valid time slots for the next 5 years.  So say 5 days a week times 8 slots times 52 weeks a year times 5 years = 10,000 date records.  I would make the date unique.

Then  set up these as being the Parents to the appointments Table.

Then it would depend on how you wanted the user to find a open time slot, but for example would have a drop down of say the 12 months and a relationship back to the dates table and also to the appointment table and then perhaps a table of the days of the week with relationships back to the appointment table and the dates table.

So, for example the user would select a month.  then they would get a conditional drop down of all the days of the week ie M T W Th or Friday which had open slots during that month.  Then they would choose a day of the week, and be presented with all the open slots  for that day of the week during that month.  An open slot is a date with no children yet.

So the "search process would depend on how you need your users to search for a date, which typically depends on how far out the users are needing to look and if they are booking slots for themself or are talking to a client,, who might say "I need a Tuesday in November -  what do you have open?"

You could also, I gess skip all that and just throw up a Calendar Report format.  The report would show all the slotys for every day and via a reverse relationship, show either the booking details or else "open".  It could color code if open or taken, like green / red.  Then the user would add an appointment by gong to that date record via the calender drill down and Add Appointment.  A Form Rule would hide the Add Appointment if there already was an Appointment child for that date.  

(Actually I think I like that calendar solution better than the conditional drop down selection method.)

I can continue discussing on this forum or feel free to contact me via the information in my Profile to get into more depth.