I still have the problem of setting my sheet to calculate every minute. It never sticks and resets to hourly once I reload the sheet in glide, so I waited out the hour between auto calculations to see what would happen.
I created a formula to get a number based on time.
=round(text(now(), "SS")/60*100/10,0) Although it’s not a true random number…I use that number in an Index to get a specific link from another sheet. With that change, I still get the same results as I did with the RandBetween function. I can see the values changing in the sheet, but it will not update in the app, no matter how many times I click on Reload Sheet. I even went further to hide or show a link in the sheet based on a specific range of random or time generated values in an IF statement. The only time the updated links are reflected in the app is when I make an actual change elsewhere within the sheet. I assume the change elsewhere triggers the change flag at Glide. Possibly if there is no change, then Glide doesn’t update it’s copy.
Random number generators are many times still based on time as one of the seed values for generation and I can see it updating based on the sheets auto calculation settings. It just doesn’t translate to the app. Maybe it updates on a larger timeline, like over several hours or every day, but I’m not seeing a feasible solution to using random or time based control values for a rapid value change. I’m sure scripting would be the definitive way around this. I do have a couple of apps with calendars that hide expired dates from view. One app has daily updates to the data. The other app has data updates maybe every few weeks, so I know now() based formulas are updated within Glide at some point, but I don’t know how or when. If somebody wants to make a copy of https://concepts.glideapp.io/ have at it. The tabs are in the menu. Short of scripting and using affiliate links, I don’t know of good way to handle advertising within the app.