Help

Update Multiple Records with Automation

Topic Labels: Automations
23401 24
cancel
Showing results for 
Search instead for 
Did you mean: 
Jonathan_Hollow
4 - Data Explorer
4 - Data Explorer

I am working on using an Airtable automation to assign topics to writers.

Step 1: Trigger

Step 2: Find records that meet the right criteria.

Step 3: Send an email with values from the found records as a grid.

Step 4: Update the records from step 2. I have a single select field “Emailed” that can be true or false. I’d like to update these values to True.

Step 4 is where I am having a problem. I do not see the possibility for selecting Record ID’s for the records found in step 2. Is there a workaround to this?

Thanks in advance.

24 Replies 24
Hector_Forwood
4 - Data Explorer
4 - Data Explorer

Hi,

After reading through this thread what I’m realising is I’m out of my depth.

I was just using Zapier (iPaas) to create the following workflow:

  • Someone joins the slack channel
  • Updates Select Field in Airtable “Joined Slack?” = True

Same thing with Mailchimp:

  • Picklist updates in Mailchimp
  • Mailchimp updates airtable

I spent hours trying to get it to work but had the issue with updating multiple records. Anyone have any advice for this specific usecase?

This worked perfectly, thanks.

Tito_Alverio
6 - Interface Innovator
6 - Interface Innovator

This is now supported using the advanced logic or action feature "Repeating group". It appears it needs to be the last step of an automation, but it will repeat whatever action you choose on all record results in a list. 

I had the same use case where I wanted to update the status of a linked record, but it broke if there were multiple linked records. This solved my issue.

Can you elaborate on how you did this? I seem to get stock in the same issue as when I'm not using 'Repeating Groups'...

Karen_Lynch
5 - Automation Enthusiast
5 - Automation Enthusiast

This worked perfectly for me too, thank you so much! First time using the run script action too 🙂 🙏