Is it possible to update a value in automations to update an entire table uniformly?

[A822822822]

Is it possible to update a value in automations to update an entire table uniformly?
For now I'm doing it in a script but it can run on 50 rows each time, so I made a loop but it takes over a minute each time

[TheTimeSavingCo · Accepted solution]

Script's your best bet I think.  An alternative would be using a Repeating Group, but that'd probably take even longer I reckon.  It's working as expected, just that it's taking too long, right?

[Alexey_Gusev]

Hi,

updating by script in a loop is approximately 100 records in a second. You can use updating by group but that is not a best workaround. If you need to make a fast update of entire column holding the same value for all records, for example, exchange rate, you need to create one record table, linked to each record of your table, like it is usually done for different kind of totals. and add value as lookup from this 1-record table