// change these names to pick a view:
let table = base.getTable('Invoices');
let view = table.getView('Grid view');
let result = await view.selectRecordsAsync({fields: ['Amount']});
let runningTotal = 0;
for (let record of result.records) {
// change the field names here to adapt this script to your base
runningTotal += record.getCellValue('Amount');
await table.updateRecordAsync(record, {
'Running total': runningTotal,
});
}
+31That script works fine and I’ve set it up here for you to check out!
Could you provide some screenshots of your table with the relevant fields, as well as the automation setup and the error you get when testing?
Some quick double checks would be ensuring that your fields are called ‘Amount’ and ‘Running Total’, and you have a table called ‘Invoices’ and a view in that table called ‘Grid view’
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
