Mar 14, 2018 02:42 AM
Is there anyway to only select items ONCE?
I have a single select field type with A, B, C and D, if I pick B on a row, I only want to be able to select A, C and D afterwards.
Mar 14, 2018 04:01 AM
No you can’t. What are you trying to do? Maybe there is another way.
Mar 14, 2018 06:15 AM
When I select an item in a single select list, I want it to be not available anymore.
IE: I’m going away with my entire company, I want to dispatch people in hotel rooms. If I select the Room42 for John, when selecting Kim’s room afterwards, I do not want Room42 to be available in my single select list.
Mar 14, 2018 08:12 AM
I understood that, but what do you want that behaviour for? What do you want to achieve (related with you actual data)?
Mar 14, 2018 08:31 AM
I am deploying a form to my employees so they can register for this trip. When employee A select the Room42, I don’t want employee B to be able to book for the Room42.
So I want a single select but each item has to be selectable only one time.
(Thanks for helping!)
Mar 14, 2018 01:02 PM
I only can think on some kind of automation with Zapier. I think can’t be done only with Airtable.
Mar 15, 2018 02:01 AM
Too bad, sounds like something tricky and not repeatable. Especially if I want to give power to non-tech people.
Feb 11, 2019 01:13 PM
Not exactly what you need, but you can put the single select list in a separate table and link them rather than having them in a drop-down in the same table.
Put your Room list in a separate table, then on the form the user will select which room they want. Room 42 will still be on the list of options to choose, but John’s name will be listed right there so they can see it’s already reserved.
Haven’t explored if you can use a filter to only display the options that are empty, i.e. have not been linked to another record, but maybe that could be the next step.
Apr 11, 2021 09:25 AM
This worked perfectly!