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
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 eUnits] table. In the eUnits] 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.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.