Publish a mirror (copy) of a spreadsheet page with real-time changes

I have a spreadsheet page that I would like to publish to my app (as a image format). Is there any way to put it and it will update as the same way graphics update automatically? I tried to publish my spreadsheet page in PDF format online, copy the link and share in glide spreadsheet, but in the app it does not update as modified. I waited for over 1 hour and really nothing has changed.

Images are heavily cached by Glide. You can either modify the url to force it to update, or you can use links that will build pdfs on the fly. Here’s a couple of threads that explain both methods

Filter Tabs/Menu by signed-in user

1 Like

In this case, if i put the formula NOW() in F2, whenever it changes, the image will also be updated in cache? Did you know telling me?

It should work as long as something changed in your sheet that would cause now() to update.

1 Like

Don’t use NOW for this. Find some value that changes if and only if your chart changes, and use that in the URL.

3 Likes

Hi @Jeff_Hager and @david,

The solution laid down by David (which I am really excited about) doesn’t seem to be working for me.

I have an travel expense tracking app with a chart (published in my sheet) in the home tab

When changing the URL in the source cell for the chart from:

https://docs.google.com/spreadsheets/d/e/2PACX-1vQCdFtmJxbYtluhATysBD1OCRyDp-M1aGdb0H3Ch1WyAqQZvuVunkWdRDcEPtlgHf_VTY2ui1R1E31-/pubchart?oid=660519160&format=image

To (where B2 is the total spent so far that increases everytime I submit an expense):

=“https://docs.google.com/spreadsheets/d/e/2PACX-1vQCdFtmJxbYtluhATysBD1OCRyDp-M1aGdb0H3Ch1WyAqQZvuVunkWdRDcEPtlgHf_VTY2ui1R1E31-/pubchart?oid=660519160&format=image” & “cachebust” & B2

I get the “image URL can’t load” in the space where the chart should be.

Any help would be extremely appreciated!

Shouldn’t it be

="https://........=image" & "&cachebust=" & B2
2 Likes

yep, missing the ‘&’ before cachebust and the ‘=’ after it.

Like too often, the problem is between the screen and the chair :man_facepalming:t4:.

Thanks so much for your help, it’s much appreciated!

1 Like