Running total
This script calculates a running total based on the order of records in a specific view.
Example
// 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 baserunningTotal += record.getCellValue('Amount');await table.updateRecordAsync(record, {'Running total': runningTotal,});}