Hi @Lubem_Mtile - I wrote a blog post about a similar idea here:

Hope this give you some pointers!

JB

Hi @JonathanBowen Sorry to come back again. For some reason i cant get the sum of the field in ‘Total Hoodies (calc)’ . Which is now 71 see image:

Here is my script:

let table = base.getTable(‘Commisions’);

let query = await table.selectRecordsAsync();

let total = 0;

for (let record of query.records) {

total = total + record.getCellValue(’# of Hoodies’);

}

for (let record2 of query.records) {

total = record2.getCellValue(’# of Hoodies’)+total;

await table.updateRecordAsync(record2, {

“Total Hoodies (calc)”: total

})

output.text(Total Hoodies (calc) ${record2.name} updated!)

}

Cant seem to see what i’m doing wrong

Hi @Lubem_Mtile - I think it its this part that is wrong. What is happening is:

• total is 71 from the previous loop


• for each record you get the total, add the number of hoodies to the total


• then update the “Total Hoodies (calc)” field with the new total
  
  Note that total is now no longer 71, but 71 + 1 (after the first iteration), 72 + 3 (after the 2nd iteration) and so on.

If you want to see 71 is the “Total Hoodies (calc)” field for all records you can just do this:

for (let record2 of query.records) {

    let updatedRecord = await table.updateRecordAsync(record2, {

        "Total Hoodies (calc)": total

    }

)

for (let record2 of query.records) {

    let updatedRecord = await table.updateRecordAsync(record2, {

        "Total Hoodies (calc)": total

    }

)

Works just fine!! Thank you @JonathanBowen i see where the issue was now.