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

Adding Items in field and then subtracting them from another field

305 0
Showing results for 
Search instead for 
Did you mean: 

Hi peeps

I am new to Airtable and am starting to get the hang of counts, etc which I use to add up the number of items in a field. The fields are a form completed that will drop in a linked field from another table. I can add those up per row and get a sum per user like so:

Each line is the completion of a form by a user with them adding their details each time. What I want to to now is either change the form to:

A. add the same item to a user to create one line and one total
B. subtract the sum of all the items the user added from a set total

So if there are 50 items and they have gone in 3 times and chosen 15 over the 3 times, the total would reflect as 35 somewhere. This can be a single row or at the top of the sorted list, I dont mind. We just want to get all users to complete all tasks.

Does anyone have any suggestions? Open to linking the users from another table if that helps.


What I want to do now is add

0 Replies 0