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
In this case, if i put the formula
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.
Don’t use NOW for this. Find some value that changes if and only if your chart changes, and use that in the URL.
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:
To (where B2 is the total spent so far that increases everytime I submit an expense):
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
yep, missing the ‘&’ before cachebust and the ‘=’ after it.
Like too often, the problem is between the screen and the chair .
Thanks so much for your help, it’s much appreciated!