Help

Delimiting Find Records to update multiple airtable id's

Topic Labels: Automations Data
1129 1
cancel
Showing results for 
Search instead for 
Did you mean: 
JFry0488
4 - Data Explorer
4 - Data Explorer

I'm not sure how I can delimit a "Find Records" to update multiple records all at once.
I know when it plugs them in as a list, it's trying to do "A,B,C" and obviously airtable isn't getting a match on the ID because of the string of text.


Does anyone have a script I can modify to break that out so my Find Records can input a single value, into multiple records at once?


Thank you!

 

 

1 Reply 1
TheTimeSavingCo
18 - Pluto
18 - Pluto

If you can wait, it seems like there's new functionality rolling out that would help with this: https://support.airtable.com/docs/repeating-groups-of-automation-actions

A possible non-scripting solution would be to have a "Helper" table, and when your automation runs and finds these records, you'd link them all to a single record in the "Helper" table

In the "Helper" table, you could create a rollup field that would only output the first record ID of all of the records linked to it. You could then make an automation that would trigger when this rollup field updates, and the action would be whatever you wanted it to be (e.g. updating the record with that record ID), and you would need to make sure to unlink the record with that record ID from the "Helper" record

Doing so will force that rollup field to update and a new record ID would take its place, triggering the automation again