In the glide together meeting today, someone asked about using Dropbox and how glide was caching pics.
You asked how this might be used. Here is what I want to do:
I want to update the pic as “App updated on” - and have the date when I updated the app as the picture. So, when I change the pic. Then it will be updated on the app. (Just my thought)
Potentially I have a friend that has a “student of the week” picture that would change periodically. So she would would need the same link, but the student name (in the pic) to change.
BTW - this also happens when I use google drawings to publish a pic. Glide grabs it, but just the first time.
You can work around this by causing your URL to update when data changes:
Here I’ve made a URL that changes every time the value in F2 changes. I’ve added a fake URL parameter, cachebust (the name does not matter), at the end of the URL. This is totally ignored, but it makes the URL look brand new when the data changes.
The F2 is only an example column. You can use whichever column you want as long as whatever you are doing is causing the value in that column to change. A good example could be a date that’s filled from the app via the date special value. Any edits to your data could automatically update the date column, which can be attended to the url.
Looking forward to that. I do a lot of joining of text into new columns on the sheet side. There’s always a delay after adding a new row until the new text shows up in the app.
@david i have the same problem showed above.
I use the app for showing scheduled meeting and the calendar’s images changes every day.
In my spreadsheet’s cells i have url like this one
In my case I have a pro account, but I have many images per user, how can I optimize or prevent it from loading each time.
I’m using glidetables, I also don’t know what resolution or what size is recommended to upload it, for example I don’t think it’s even upload 1920x1080 maybe it’s better to cut ah let’s say 800x600, can you help me @david