In case there are many quick updates by users, most likely you're interested only in the last (final) update. In that case, you can wait for it and take action only then. Here's a sample code that does that:
// pass the last modified value of the field as input param to the script
let last_modified_1 = new Date(inputVars.last_modified_fieldX).getTime();
while (new Date().getTime() < last_modified_1 + 5000) {
// do nothing, wait for the updates to settle down (5 sec)
}
let table = base.getTable('My Table');
let rec = await table.selectRecordAsync(rec_id);
let last_modified_2 = new Date(rec.getCellValue('last_modified_fieldX')).getTime();
if (last_modified_1 != last_modified_2) {
console.log("New updates found in the last 5 sec... skipping processing.");
return;
}
// process the update, do your thing, use freshly obtained rec for calculations
// total processing time (including the update of the hidden field in the end)
// should not surpass 5 sec (otherwise increase the waiting time above)
(note that this code needs to run within a function, due to the "return" statement I'm using for a quick exit)
