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:
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!!
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |