Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Sumup formula or Script

Solved
Jump to Solution
173 5
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello alls,

I have a sum up column as shown in the picture above. Actually, I use excell for the calculation (I copy the value column in excell, I make the calculation of the sumup column in excell and then I copy back to the airtable sumup column). Hence, I'd like to know if it exist any function or script that could do this calculation directly in airtable. Thx

Franck_0-1671467471835.png

 

1 Solution

Accepted Solutions

It looks like what you want is a "running total". The technique created by W_Vann_Hall in the link by Sara is a very old way of doing things. That technique was designed before Scripting existed, and it requires some very complex formulas and rollups that can be very slow and resource intensive. Now that scripting exists, you are usually better off using scripting to calculate a running total. There is an example script for creating a running total in the scripting documentation.

See Solution in Thread

5 Replies 5

Hi, have you checked this post? it has a lot of tutorials

  Link

It looks like what you want is a "running total". The technique created by W_Vann_Hall in the link by Sara is a very old way of doing things. That technique was designed before Scripting existed, and it requires some very complex formulas and rollups that can be very slow and resource intensive. Now that scripting exists, you are usually better off using scripting to calculate a running total. There is an example script for creating a running total in the scripting documentation.

Thank you Sara, I cheked the post but unfortunately it's a little confusing for a newbie like I am.

Don't worry! the important is that you solved the problem 😊 Thank you, Kuovonne!

Thank you Kuovonne, it is precisely what I need. There's a little delay in the calculation but It works fine.