Help

Re: Automating changes in options available on form

Solved
Jump to Solution
622 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Jaemi_Loeb
4 - Data Explorer
4 - Data Explorer

Hi Friends.

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?

TYIA

1 Solution

Accepted Solutions
Kamille_Parks
16 - Uranus
16 - Uranus

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.

See Solution in Thread

1 Reply 1
Kamille_Parks
16 - Uranus
16 - Uranus

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.