Often I need to sum, count and averages of values in a table and hold the value in a block for a while for others to see. This can be done using existing blocks but one each for sum, count and average - which is tedious.
This script makes life easier in such cases. It lets user select the field and table, and even filter conditions before summing, counting and averaging them.
I am planning to add error handling. and warnings to this soon.
GitHub link is here: https://github.com/indrex/airtablesum
I hope you are fine.
I am trying to use the code you created but for some reason the column remains empty whenever I run the script.
I believe it’s related to this: let filterString = await input.textAsync(“Enter filter option”); // what values to filter with.
I’m not sure what it really means. Can you please explain it?