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?
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.
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.