Remove an option from choice field when it has been selected 4 times

To the best of my knowledge removing an option of a single/multiple select field can only be accomplished via scripting. As is the case with scripting in Airtable, the script can be in the form of a Scripting app to be triggered manually or a step in an automation, the latter of which seems to fit the bill here.

The script to do so looks something like the below. Take note of the enableSelectFieldChoiceDeletion option which allows for previously available options that don’t exist in the choices array to be removed:

let table = base.getTable('Table Name');
let selectField = table.getField('Field Name');
await selectField.updateOptionsAsync(
    { choices: [...selectField.options.choices.filter(c => c.name != 'Option 1')] },
    { enableSelectFieldChoiceDeletion: true }
);

The caveat here, however, is that removing an option from a select field doesn’t just remove it as a selection for new records. It also removes it as an option from existing records, so any record that had that option as selected previously would now have an empty value in the field.

One way to work around that is to create a separate select field with the same values as the original, & copy the value to that select field prior to removing the option from the user-facing field. That way you’ll be able to keep the selected value for all records, even if they have since been removed due to being selected x number of times.

Hope this helps!

@Mr_Hope Note that you can do what you want automatically with a linked record field, but not with a multi-select field. If you want/need to stick with a multi-select field, you’ll need to manually craft your own workaround like the ideas that @Jonathan_Lutz outlined above.

Hi Scott! I’m trying to follow your approach of using a linked table so that I can remove records as selection options from a field when said records have already been selected. However, even though ‘Allow linking to multiple records’ is turned off in both linked fields, it’s still possible to select the previously selected options for new records even though they are not supposed to be selectable anymore.

What are the steps to follow so that previously selected options are no longer available for future selection in a linked field?

You could limit selection to a view, and make that view filtered to only show you options which haven’t been selected yet. I show off that technique in this week’s BuiltOnAir video podcast: