Hey Iโm trying to get my spreadsheet automatically update the data on AppSheet.
Iโve read that it can be accomplished by writing a dedicated script using the onChange function. Unfortunately I am not a skilled coder and have to look for a point&click solutions.
Iโve found a Trigger&Send Add-on to Spreadsheet and it can trigger the onChange function as I wanted, but it need a URL to push it to. Iโve searched all across the internet and I canโt find info whether AppSheet has any public API nor if I can generate a URL for my app.
Am I doing it the right way? How can I make it work? I need the data I put manually into the spreadsheet to appear in my app.
Thanks for help in advance!
W.
I am not sure that you can โPushโ changes to the app in real-time from gs, even with scriptsโฆ When you Sync the app it will fetch any manual changes to your gs. In the โOffline/Syncโ tab under โBehaviorโ you can Turn on Automatic updates but there is a delay.
To update your data in google sheet to appear in your app, just click on โRegenerateโ.
@Jason_Denniston Hey man, thanks! It worked! So simple!
@Wojciech_Strzalkowsk if you donโt add any new columns, you donโt need to regenerate the table structure. The normal sync should be enough.
Hi Guys
I have a similar question, I have a โjob listโ that grows every week generated from one sheet, of which my staff enter their hours against in another. Currently in order for them to see the new jobs in the app I have to regenerate the column structure. The job list is an Enum column of which inside the sheet originated as a column subject to data validation. Iโd love to be able to change this so that I donโt have to regenerate the column structure. The simple sync doesnโt seem to work. Any thoughts.
Restructure your data.
User | Count |
---|---|
36 | |
31 | |
30 | |
20 | |
17 |