I was able to successfully partition my app to show different data. However, whenever data is added through the app, from either a form or action button, the data that is entered gets placed on the original google sheet. How do I partition the table to record data on the corresponding google sheet.
For exampleโฆ I have a time tracking app. Iโd like to be able to offer the time tracking abilities to other small businesses to use, but for them to have their own data. Right now, the app partition separates data based upon useremail(), so they would be able to see their name to sign in, but even when itโs viewing data from the 2nd sheet it adds data to the original sheet.
Hopefully I explained that properly.
User | Count |
---|---|
16 | |
12 | |
9 | |
4 | |
2 |