Skip to main content
Solved

Sumup formula or Script

  • December 19, 2022
  • 5 replies
  • 45 views

Forum|alt.badge.img+3

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

 

Best answer by kuovonne

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.

5 replies

Forum|alt.badge.img+16
  • Inspiring
  • December 19, 2022

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

  Link


kuovonne
Forum|alt.badge.img+29
  • Brainy
  • Answer
  • December 20, 2022

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.


Forum|alt.badge.img+3
  • Author
  • New Participant
  • December 20, 2022

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

  Link


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


Forum|alt.badge.img+16
  • Inspiring
  • December 20, 2022

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!


Forum|alt.badge.img+3
  • Author
  • New Participant
  • December 20, 2022

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