Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Multiple Select Field

Topic Labels: Base design
399 1
Showing results for 
Search instead for 
Did you mean: 

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.