Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Jul 02, 2022 05:25 AM
Folks, I need to make a simple action: When a form is submitted, I need to automatically update a field on all the records on one view to a specific value.
How can I do this through scripting?
Jul 02, 2022 07:04 AM
Welcome to the Airtable community!
It depends on your current scripting ability.
Do you already know JavaScript? Have you looked at the scripting documentation?
Do you already know how to break down the logic of the script, but need help identifying the specific function calls? Or do you not know where to start at all?
Jul 02, 2022 11:37 AM
I have already grasped on how to open a table and a view, how to go through the records to update them 1 by one.
The problem is that by doing this this way, the script goes over the 30s limit and stops…
Is there a command/property on the view object to do this is a bulk way, like we do with TSQL?
Jul 02, 2022 11:47 AM
You need to update records in batches using updateRecordsAsync
(note the s
) instead of one by one.
You can see one method of doing batch updates in this example.
Jul 05, 2022 03:27 AM
Kuovonne
Thank you for your effort, but your solution is basically doing something similar as what I am trying to escape from: going through all the records to add them to an array and then work them out…
What would really work was to have a sole instruction/command which would update all records with a specific value on a specific field, or to be able to run an extension.
Sep 17, 2022 06:42 AM
Hi there Quero Emigrar
Did you find another way to update all records?