Automation Add Option to "Multiple Select" Field that might be empty or filled

Hello. I have a Status field which is “Multiple Select”. I am trying to build an automation that automatically adds “new” to the Status field when a new record is created. However, the Status field may start empty or it may start filled with other options from the “Multiple Select”.

I can make an automation that works when the field starts empty (just assign “new”), but this will erase any other options if the field starts filled. If the field starts filled, I can assign “new”,{Status}, but this gives an error when Status starts empty ({Status},“new” also does not work). The error is ‘Failed to construct the value for “Fields”.’ So I cannot account for both at the same time. However, my table will have both cases for new records. Am I missing something about how to concatenate the already selected options with my new option?

The work around I have found is to use an additional formula field that either fills “new” or concatenates "new, " to a non-empty field. However I would rather not have this extra field and this seems simple enough that I’m hoping that I am just missing something. Please let me know if you know how to fix this. Thank you!

Welcome to the community, @Marcus_Lee!

You shouldn’t be getting an error message when trying to update an empty multiple select field. That should work just fine.

However, you DID stumble upon one of the current limitations of Airtable’s automations: it doesn’t APPEND options to a multiple select field, but rather it completely OVERWRITES your multiple select field.

The workaround to this problem is also what you’ve discovered: if you create a formula field that results in values separated by commas, you can set your multiple select field to that formula, and Airtable will interpret that as different multiple select values.

To simply APPEND options at this point in time, you would need to either write your own custom JavaScript, or turn to an external automation platform like Integromat (which is my personal favorite no-code automation platform).

Correction: If you insert the original value from the trigger record, add a comma, and then type whatever is supposed to be appended, Airtable Automations does in fact append multiselect field values. If you’re updating a record which isn’t the trigger record you could pull the original multiselect options using whatever script was used to get that record’s ID into the Update Record step using an output variable.

Ooh, this is a hot tip! I did not know this!! I never even tried that!!

Thanks so much, @Kamille_Parks!! :smiley: :raised_hands: :star2:

@Marcus_Lee, do what @Kamille_Parks said! :stuck_out_tongue_closed_eyes:

Thanks for the suggestions, @Kamille_Parks and @ScottWorld ! @Kamille_Parks, your suggestion seems to work if I have some entries in the Multiple Select Field already. But if the Multiple Select Field starts of empty, then using the field value with a comma and the new text fails. Is there something that might work for the empty field and filled field at the same time? Thanks!

There are a couple solutions including: use a Script Action before the Update Record action to do some error catching, or using two different Automations (one for when the field is empty, one where the field is filled).

1 Like

Alternatively, you could always go back to your original solution, which is the extra formula field. You can always hide the Formula field so you don’t need to see it.

1 Like

Thanks both for your help! I will try some of these suggestions. @ScottWorld and @Kamille_Parks

1 Like