I am looking for a way to have people select a time slot from a single select field when filling out a form, but then make that option unavailable to other people. When creating a form, you can choose which options are shown, but I can’t figure out how to automate changes to which options are shown. Any ideas?
You could do this with linked records instead of single select fields. Every time slot would be a record in a Time Slot table, and whatever table the form is in would link to it. The Time Slot table would have a filtered view that only shows records (time slots) which have no linked records. Then your original table would only allow selections of time slots from that filtered view. The end result is form users would only be able to select slots that have not yet been selected.
You could do this with linked records instead of single select fields. Every time slot would be a record in a Time Slot table, and whatever table the form is in would link to it. The Time Slot table would have a filtered view that only shows records (time slots) which have no linked records. Then your original table would only allow selections of time slots from that filtered view. The end result is form users would only be able to select slots that have not yet been selected.
