Hi, I've ran into an issue about syncing data from multiple sheets.
Here is my situation:
I use appsheet to create and enter new data, and save that data in a specific google sheet.
Then I use google sheet to calculate statistical stuff on that data, which is done in a 2nd sheet, but is based on the data entered by appsheet on the 1st sheet. I would like to display these statistics in the same app from which I enter the data.
The problem is, I can enter data using forms, and google sheet does it's job, calculates the statistics I need. I created a table view in appSheet to display the 2nd sheet's data, but it does not seem to work. Every time I enter a new data using the form, the data gets entered, the statistics are calculated, but the old values remain displayed in the table view used to display the 2nd sheet. If I click regenerate structure for the statistical sheet, then it updates, but I want it to be automated, so every time a user enters a new data, they can instantly see the new statistics.
Is there any way of making this work?
Thanks in advance for help!
Solved! Go to Solution.
Normally that should be working as expectation, but may take 15-30 seconds for refresh (also depends on complexity of the calculation).
User | Count |
---|---|
16 | |
7 | |
6 | |
5 | |
3 |