Skip to main content

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

  • September 8, 2022
  • 3 replies
  • 67 views

Forum|alt.badge.img+2

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

Forum|alt.badge.img+16
  • Inspiring
  • 529 replies
  • September 8, 2022

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

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


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9808 replies
  • September 9, 2022

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.


Forum|alt.badge.img+3
  • New Participant
  • 1 reply
  • December 16, 2024

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!