Hello AppSheet community,
I am working on an app that keep track of how much users recycle. There are four different tables, each for a category of trash:
- Plastic Bin
- Paper Bin
- Glass Bin
- Aluminum Bin
Within each table, there is a column that calculates the total quantity of each bin (for example in the Plastic Bin table that column is “Plastic Quantity” and in the Paper Bin table that column is "Paper Quantity’) There is another table that I want to use that has each of these values and calculates the “Total Amount Recycled” by adding them all together. I want to do this so that I can create a chart that will display all these values together to the user in another view.
Basically, I do not know how to basically import these “quantity” from each bin into this one table. I have tried using reference and REF_ROWS(), but they do not return number values that I can use for a chart. I’m at a loss of what to do.
Please, I would appreciate any help available. Thank you!!