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:
This workaround is with following steps of changing the URL:
- For the embeded image-chart: need to add to the URL of the published chart image with
image&update=&NOW(), sample as below:
- For the hyperlink, adjusting based on a Medium-post:
Step 2.1. Copy the chart and move to a new dedicated sheet
Step 2.2. Following the Medium-post, Change the "edit#" with "htmlembed/sheet?"
So the final upadated URL will be as sample below:
as shown with the above.