Updating a record using automations - Replaces the previous tag!

[MegKrashCourse]

Hi All! 

So I have set up an automation that adds a tag to my "Status" column (which is a multiple select column) when a certain checkbox is ticked as true. The automation seems to run fine, BUT, it replaces any previous tags in the "Status" column that were there beforehand. 

Is there a way to prevent the new tag from replacing the previous tag and just adding a new one? I did do some research and it looks like in previous versions of Airtable, one could select "Append" in the action section of the automation set up, but that doesnt seem to be an option now? 

Anyone got any pointers for me please? x

[ScottWorld · Accepted solution]

No, there was never an Append action. You can do your own append by doing this:

In your “update record” action for the multiselect field, click on the gear in the right and choose dynamic values.

Insert the new value first, then type a comma, then insert the entire multiselect field from the triggering step.

See screenshot below for how this would look.

Hope this helps! If you’d like to hire an expert Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

[MegKrashCourse]

Hey @ScottWorld ! Thank you for the help! 

So mine seems to be slightly different - I dont have the option to type anything in the fields: 

I can only select the current options in my multiselect - it doesnt allow me to use commas or write 😞 Any workaround here? x

[ScottWorld · Accepted solution]

As I mentioned above, you will need to click on the gear and choose Dynamic.

[MegKrashCourse]

Amazing! Thank you so much!

[ScottWorld]

You’re welcome! Glad I could help! 🙂