Help

Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Bulk update - can I speed this up?

Topic Labels: Scripting extentions
Solved
Jump to Solution
239 2
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello,

I have a table with about 1700 records. I’m pulling a couple of records and doing some math on all the rows, then updating the result in a new record. The bulk update code I’m using is waaaay faster than a single row update, but it’s still taking about 45-60 seconds. That’s too slow for me to run an automation, which has a 30s timeout. Is the following code inefficient?

while(updatedRecords.length){
await table.updateRecordsAsync(updatedRecords.splice(0,50));
}

Regards,
Scott

1 Solution

Accepted Solutions

You code isn’t inefficient. It just isn’t as efficient as you need it to be.

This thread has suggestions for dealing with updating thousands of records in an automation.

See Solution in Thread

2 Replies 2

You code isn’t inefficient. It just isn’t as efficient as you need it to be.

This thread has suggestions for dealing with updating thousands of records in an automation.

Thank you! I don’t have to update every record, so that’s a great suggestion.

Do you have any examples of a mega batch update? I would have approached it the way it was discussed in the thread, but I got the impression that did not work.