Skip to main content
Solved

Updating a record using automations - Replaces the previous tag!

  • April 11, 2024
  • 5 replies
  • 63 views

Forum|alt.badge.img+5

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

Best answer by ScottWorld

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 

5 replies

ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9808 replies
  • Answer
  • April 11, 2024

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 


Forum|alt.badge.img+5
  • Author
  • Participating Frequently
  • 7 replies
  • April 11, 2024

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
Forum|alt.badge.img+35
  • Genius
  • 9808 replies
  • April 11, 2024

Remember to click on the gear and choose Dynamic.


Forum|alt.badge.img+5
  • Author
  • Participating Frequently
  • 7 replies
  • April 11, 2024

Remember to click on the gear and choose Dynamic.


Amazing! Thank you so much!


ScottWorld
Forum|alt.badge.img+35
  • Genius
  • 9808 replies
  • April 11, 2024

You’re welcome! Glad I could help! 🙂