Announcements
This site is in read only until July 22 as we migrate to a new platform; refer to this community post for more details.

Sum data from nested forms

Hi everyone,

I was trying to find a way to grab data from nested forms and add it up automatically in the main form.

Example:

Count1.jpg

If I have something like this, and I add various groups of people

Count2.jpg

But then I want to automatically add up all the number of people in the "Total people" Column. Is this something that can be done in AppSheet? If so, do you have any idea how?

Thanks for the help.

 

Solved Solved
0 8 290
1 ACCEPTED SOLUTION

Aurelien
Google Developer Expert
Google Developer Expert

I did not test it in a form, but what about:

 

SUM([Related Groups][NumberOfPeople])

 

For reference:

https://help.appsheet.com/en/articles/2357307-sum

https://help.appsheet.com/en/articles/4575708-list-dereference

 

 

EDIT : Corrected. I misread your question at first

View solution in original post

8 REPLIES 8
Top Labels in this Space