Home screen random image

I am trying to get my home screen image to update every minute as follows:

I have an “Image” Column (D) with all image URLs.

I have a home screen Column (A), in the only cell of home screen Column (A)

I have the following formula: =index(D2:D,randbetween(1,counta(D2:D)))

The formula selects an image URL from Column (D) and returns the image URL to

Column (A) which in turn updates my home screen cover image.

Note:

I set the refresh time as follows:

Spreadsheet Settings >calculate > on change and every minute.

Glide does not automatically update my home screen image. The formula works

if I manually refresh the spreadsheet in glide, would a pro account work?

1 Like

You can set the refresh interval in google sheets, but that doesn’t mean that the data will be sent to glide without some sort of interaction from the user. This means, that either data would have to change within the app to cause it to be sent to google, along with a near immediate return of any updated data (usually a few seconds), or you would have to go pro and turn on background refresh. Either way is not going to guarantee that the image changes every minute.

I had attempted something similar awhile back with the Random/Advertising Links example in https://concepts.glideapp.io/. It works for the most part, but it was never a consistent experience as far as reliably changing the image in a specific amount of time. It was also really odd that what was displayed never matched what was in the sheet. Almost like it was a step behind. Never really understood why.

1 Like

Jeff,

Thank you for your response, I will just refresh it manually for now.
I was thinking I could automatically display featured business Ad(s)
on the home screen as a revenue generator…

1 Like