Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Update Record: ADD a multiple select field (but not replace existing ones)

Topic Labels: Automations
2123 3
cancel
Showing results for 
Search instead for 
Did you mean: 
Tech_Support3
4 - Data Explorer
4 - Data Explorer

I am trying to create an automation that adds a multiple select item to a field but I don’t want to replace it with what exists. For example, if “Troop” already existed in that column, I want to add “Cookie” so that the multiple select field reads “Troop” “Cookie”. Currently the automation replaces everything that exists so when I run the automation, it simply says “Cookie”. Any advice?

3 Replies 3

Hi @Tech_Support3.
I think you can just add both the existing item and the new item in the Automation.

image

In my screenshot. When updating the Field ‘Field’ I add the existing Field record and the new item from the Select.
image

The way to do this with the update record action is to: insert the new value first, then type a comma, and then insert the field itself.

kgreen
4 - Data Explorer
4 - Data Explorer

Hi, is there an updated way to do this? I'm having the same issue as the original post but the answers seem different to what I am able to do in Airtable today. Thanks!