One Random Image/Text for Banner

In some discussion on another thread, it was discussed how to get ONE RANDOM image (or text) to display in your app.

Possible workaround:
https://vt4rt.glideapp.io

Front page: Just grabbing a random cell from the “Lists” tab in the A Column.
=index(Lists!A2:A,randbetween(1,counta(Lists!A2:A)))

So only ONE of a list is picked randomly.

In my app, this image/text is only changed when the Spreadsheet is changed. So I have a form that only submits the current day and time (thus changing the random image)

I also use it here to pick random Bible Verses (images):
https://azm1b.glideapp.io
https://cqacq.glideapp.io

You could also possibly configure this even more with a signed in user. The Welcome text could say something like: Hey Kevin, you are a winner!

Discussed here:

Inspiration:

1 Like