Why is AppSheet not syncing correctly with my gSheet when using this formula to get live weather?
=transpose(IMPORTHTML(โhttps://www.accuweather.com/en/us/dade-city-fl/33523/hourly-weather-forecast/332333","tableโ,1))
I have 6 locations that I need live weather updates. I created a gSheet called Weather. I then created 6 workSheets and labeled them โLocation 1โ, โLocation 2โ, โLocation 3โ, etcโฆIn cell A1 of each workSheet, I enter the above mentioned formula, which populates each workSheet with an hourly forecast.
I then go into AppSheet and import the 6 tables. I then create 6 โRefโ Views. Then I created a โDashboardโ View to display all 6 of my โRefโ Views.
Everything looks and works beautifully, but itโs not updating. Currently (7pm), my gSheet weather is correct and is displaying hourly time starting at 6pm - 1am. But when I open AppSheet, the weather is still reading 1am - 8am, which would of been the forecast for late last night and into this morning.
Any ideas on whatโs going on? I am pretty sure Iโve gone through everything but just canโt seem to figure it out. Iโve synced and refreshed until my fingers are numb, and still nothing. Any and all suggestions are greatly appreciated!
Thanks
Check your Behavior -> Sync settings. Make sure to disable delta sync and server caching.
@praveen I did indeed have Delta sync enabled. I disabled it, and resynced, and all is good. Looks like that did the trick. Much appreciated!
@praveen does this statementโฆ
โSetup your app to work offline and control when changes in the app are synced with your data in the cloud. Requires a PREMIUM per-user plan or a PUBLISHER PLUS per-app plan.โ
โฆthatโs displayed over the options where Delta sync is located, apply to having the Delta sync option off? I just noticed that statement and was curious if Iโm going to need one of those plans to have the Delta sync option off. If that is the case, that wonโt work as we will be doing the Standard Plan.
Thanks
Actually, you need one of those plans to turn it ON :] Delta sync is valuable for many cases, but not where the data is changed via formulas without the file itself changing
User | Count |
---|---|
38 | |
35 | |
27 | |
23 | |
18 |