This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Will Appsheet support a self refreshing excel file? For example I have a sheet containing live stock data will this still refresh when put in Appsheet?
The app will pull in whatever data values are in the spreadsheet everytime it syncs. Syncs occur manually, when you open the app, every 30 minutes, when a change is made, etc (all according to options in Behavior->Offline/Sync)
Maybe for excel file if the self refreshing was not considered as someone is opening the excel file. It will be interesting to see, have you tried this @Chris_Fisher?
One thing to rememberโฆ for example if you use NOW() expression in gSheet, yes itโs updating the sheet but itโs actually a virtual update on your screen. This is not happening on the backend and you are not able to see the update happening on your app because itโs not updated through API. Same is happening for example with financial expressions.
Not directly. The changes to the spreadsheet will only become visible to AppSheet when AppSheet initiates an interaction with the spreadsheet, such as during a sync. Notably, the live stock data will not trigger workflows, will not prompt a sync of the app to occur, and your appโs users wonโt have a โliveโ view of the stock data. AppSheetโs design does not allow for real-time data updates.
The following docs might provide a better sense of how AppSheet keeps data fresh:
LinkedIn
Twitter
