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.
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!
@Kamille_Parksthis is helpful - I am trying to do something similar and would love to see how you would set-up the automation!
I am basically trying FIND any record that has both "No RTW Feedback" & "RTW Received" in the multiselect (called Feedback Status) and REPLACE "No RTW Feedback" with "RTW Received" all while keeping the other multiselect inputs that same (in this case, "No PL Feedback".
For context - the "No RTW Feedback" status gets added via an automation after we have completed reaching out to a user for feedback and they don't provide any feedback.
And the "RTW Received" status gets added via an automation whenever feedback is submitted.
The trouble is - in instances where a user gives us feedback AFTER we finish reaching out to them, we end up with two statuses ("No RTW Feedback" & "RTW Received").
Ideal state is if when feedback is received, the "No RTW Feedback" is REPLACED by "RTW Received" (without over-riding the PL status).