For those who may add more fravour to your appsheet app with chart image.
Set up is super simple.
Basically, create the chart as usual in your google sheet and publish chart as Image. Get the public URL link to it.
Go to appsheet and create VC (Virtual Column) and push that URL and save as image type.
That s it, dead simple.
Seems we are able to publish Google sheet chart as interactive HTML site, meaning once Appsheet iframe view come and play, we are able to place interactive chart rather than static image chart. Should be a fun.
Now all the stuffs are working on Google Platform, largely to say under Google Business Application Platform! Appreciate if you could have few words to new colleagues from Google to make this integartion happen! thank you, Aleksi.
I am sharing a workaround to be able to get updated image google-sheet-chart in Appsheet, result is as below picture, data was updated through Appsheet and in about 5 minutes or so (after sync) the chart-image get updated:
I’ve tested using my device and also in the editor.
To see a live update of the chart, a link is being provided which will get an instant update. In browser, when click the hyperlink it will show something like this:
Yes, I referer to read the same Medium post, but could not find a way to refresh instantly.
Passing additional params of &update=&NOW() at the end of url could do the magics, which I didnt know!
Currently only able to place static image as chart to Appsheet. Your trick to place url link to open the chart will browser will give the richer experieces with chart, as they are “interactive” chart. Hopefully, new Appsheet iframe will be capable of handling such URL to embed interactive chart inside appsheet.
People in other community for no-code app platform seems to be talking about the same stuffs…
But their dev is promising they will do introduce some tricks to update chart “automatically”. Why not with Appsheet?
Not sure what sort of tricks or mechanisum they are introducing, but kinds of “aggressive cache”? just igonre the default cache and refresh the source data real-time?
Appsheet auto update every 30 mins.
Google Sheet published Chart URL seems to refresh cache once every 5 mins. based on that, appsheet view with google chart will be freshed every 30 min without explicitly syncing app?
I will test and see…
But all the problems could be solved all at once by Appsheet iframe?
Yes, I have tested this also with handphone, the Google chart image was also updating without refreshing the app. If we press the sync, it will update in 5 minutes, and sometime less than that.
tsuji_koichi:
But still not realtime update
I believed that the real-time update is through iframing of the “htmlembed” as above.
I wonder if someone can test the “htmlembed” work-around inside the currently being developed Appsheet iframe?
I couldn’t tell by the video but I assume you had to add another data table with only 1 column. When you clicked the “+” action button you submitted a form when then resulted in the view showing the virtual column? Can you walk us through this part?
The graphs from the gsheet are displayed as per the method shown by @tsuji_koichi but it’s not updating, it just stays static, the same one when first displayed.
Not sure what I did wrong. Please help as I created the graph in one doc (gsheet) and Virtual column in another doc (gsheet) and referenced it as per @tsuji_koichi suggested.
Besides I tried @John_Kent method, it works pretty good showing the updated graphs but only issue is you need to click the action button to get things going.
I intend to have it automatic, Anyone please help!
You’re not wrong, the graph created by the spreadsheet is static and doesn’t change, for now use the ux graph supported by the appsheet and it will automatic
