Choose single select option once per record

Hey, do you mean not selecting it on another record? One way could be with instead of a Single select have a linked record, over there you can limit what can be selected by conditions

Hm could you provide some screenshots of being able to select the same option twice?

Hey ​@airbase,

By default, Airtable will not allow you to select one specific single select option more than once on the same record. If you mean on different records, then you’ll want to create a new table, link it to your original table, and have all dropdown options created as records on such new table. Then, you’ll want to set a condition to which records can be selected on the linked field, to make sure that only non-linked records can be used. 

Please let me know if you need further clarification. I’d be happy to send over additional details.

Mike, Consultant @ Automatic Nation 

​@Mike_AutomaticN, what would be the conditions to set for the linked record to ensure only records that are not already linked can be selected? 

Here is an example of what ​@Mike_AutomaticN is talking about. Saying that the linked field in the linked table must be empty. So, as soon as you link something it will be removed from the list of options on the next record.

So, in my Artists table, on the Songs linked field, I’m saying for a Song record to be an available option the Song record must not already be linked to an Artist record. Does that make sense?

Note that solution displayed in example by ​@Adam_Rondeau , works even if 2 users trying to fill the same Song in form in the same time. First Submit will be OK, second will say smth like ‘sorry this choise no more available’ and after you open picker window again, available records to link will be updated according to filter.