How to sum data in a schema and use in another schema

Hi all!

I am trying to build an inventory system and there were no templates. What I want to do is sum all quantities of like inventory items in the Inventory Lots schema and show the total in the Inventory schema for each type. For example, if I have 4 lots of Snickers candy bars and 3 lots have 12 bars each and the other lot has 3, in the Inventory schema I want to display the 39 Snickers candy bars in the Snickers inventory.

BTW, if the answer requires js, keep in mind I am a total noob.

Thanks for the help in advance!

Hi Josh,
to answer this I would need to know a little more about the structure of your schema. Is it possible to contact me at michal.cumpelik@tabidoo.cloud?
Regards
Michal