Multiple Select Field

Topic Labels: Base design
700 1
Showing results for 
Search instead for 
Did you mean: 
5 - Automation Enthusiast
5 - Automation Enthusiast

Hello everybody, I created this multiple select fields, and as you can see in the picture after I put “102 &103” in the first record and move to the second record then the options “102 and 103” also show there. Now I know this is the basic design of Airtable but is there a way where if I put multiple options in a record I would not be able to or they wouldn’t be visible in any other record in the same column?

Really appreciate your help and thank you for reading this

1 Reply 1

This can’t be done using a multiple-select field, but it could be done using a link to another table.

Create a new table with records representing the various options you want. Because your multiple-select field is named “Units”, I’ll use that same name for this new table. Turn your {Units} field into a link to the [Units] table. In the [Units] table, add a view named “Not Selected”, and add a filter to that view to only show records where the incoming link field from your main table is empty.

Back in your main table, edit the {Units} link field properties to only allow records to be chosen from that “Not Selected” view. Now as you create links in the main table, each linked record from “Units” can only be linked once.