Sum data from nested forms

[Fos23M]

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:

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

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.

[Aurelien · Accepted solution]

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

[Fos23M]

Thank you very much, it works perfectly.

[SkrOYC]

Actually, Idk, but you can try.

First, try making a Virtual Column just to try it.

Your parent table should have a "[Related something]" column, I guess you changed it to "[Groups]". It's something I avoid, I keep them the default Related... and change the "Display Name" if I don't like the way it looks inside the app.

Now, your  Virtual Column should have a formula of:

SUM([Groups][PeopleColumn])

[Aurelien]

Neat answer ! @SkrOYC  😁

[SkrOYC]

Your was better, I've been forgetting the links to the docs lately! I wouldn't have answered it if I would have seen your reply before

[Aurelien]

Yes, something that was in Discourse and still missing here: "John Doe is writing..."😁

[SkrOYC]

Exactly. I'm looking foward for an Unofficial AppSheet Community on Discourse

[Fos23M]

Thanks, this works. And regarding the column name, I agree that is best not to change the name, Groups is the Display Name.