Update multiple records automatically

[Benjamin_Watrou]

Hi everyone,
Has anyone found a way to automatically update MULTIPLE records depending on updates or conditions changing for those records in another field?
Thanks!
Ben

[Kamille_Parks]

Either set your automation to trigger for each record upon its changes (results in the Automation running once per effected record), or handle bulk updates in a single Automation through a script.

[Benjamin_Watrou]

Kamille_Parks:

Either set your automation to trigger for each record upon its changes (results in the Automation running once per effected record)

Thanks Kamille. With custom automations you have to identify a unique record ID for each action to trigger, therefore what your saying is to specify each record ID per automation then?

[Kamille_Parks]

No, I’m saying have an Automation set to trigger “When a record is updated” and use a single Update Record step to update the trigger record’s field values. The Automation will run once for each record that gets updated.

[Benjamin_Watrou]

Thanks. Once I turned it on, it updated the previous trigger steps record field when I made a change to that record’s trigger field.

It was supposed to insert a shareable image, pulled from Google Drive using a URL. Unfortunately, the .png files aren’t appearing as images, just files:

Do you know why that is and how I might have the images show up instead? My goal is to have these images directly integrated with a front-end interface, so image type, quality, and size are important.

[Databaser]

Benjamin_Watrous:

Unfortunately, the .png files aren’t appearing as images, just files:

.png’s should appear as thumbnails/images according to this support page. Did you try bigger row height? :man_shrugging:

[Benjamin_Watrou]

Looks like that simple setting change downloaded the images!
Thanks a lot!

[Benjamin_Watrou]

JFAI, Airtable support confirmed issues with GDrive files: “I did some more digging internally and there is an existing issue with uploading Google Drive URLs to an attachment field that can cause intermittent failures. That might have been what you encountered here (since the row height should not affect this behavior at all)”

[Databaser]

Aha, thanks for sharing and never mind my previous comment then :thumbs_up: