Help

How to find & replace a specific selection in a multiple select field without changing the other selections at a specific time

Topic Labels: Automations
57 1
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi,
I am trying to create an automation where every Monday morning at 6am, all my multi select tags set as ‘Followed up on content’ are changed to ‘Need to follow up’, but without removing the other tags that are already set.

Screen Shot 2022-11-23 at 2.47.18 pm

Screen Shot 2022-11-23 at 2.49.34 pm

I also need to create a button I can manually use that changes all ‘Need to follow up’ to ‘Followed up on content’, also without removing the other tags that are already set.

Pretty new to airtable, so thanks for anyone that can help!

1 Reply 1

Use a formula field like this

IF(
DATETIME_FORMAT(NOW(), "dd HH") = "Mo 06",
SUBSTITUTE({Content Status}, "Followed up on content", "Need to follow up")
)

Set ann automation to trigger when that Formula field is not empty. Then add a Update Record action step that inserts the formula result into the {Content Status} field.

If you have several hundred records that need to be updated, a script would be more efficient. Also the button-activation would probably work best as a (slightly different) script