Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Automating changes in options available on form

Topic Labels: Automations
Solved
Jump to Solution
271 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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

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

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.