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

Running Total but for receiving invenotry

Topic Labels: Extensions
268 2
Showing results for 
Search instead for 
Did you mean: 

We are looking for a script similar to Running Total, except instead of adding the previous record to the one below it, etc it would add a Units Received field to a Total Received field everytime the Units Received field is updated.

How would I go about something like this?

2 Replies 2

One way would be to have a table called e.g. “deliveries” with “units received” field. It would be linked to products table which would use a Roll-up type field: Total Received. This field would use the SUM(Values) function.

Do you need a running total across multiple rows? Or is only a final total okay?

If you need a running total, you can adapt the running total script. Add the units received to the total received from the previous record to get the new total received. Continue down the rows.

If you only need the final total, go with Matt’s suggestion of linked records and a rollup field.