Random numbers set on a spreadsheet no longer connect to Glide

[Darren_Murphy]

@daiki

What part of the dashboard should I check?

The Updates section at the top, thats where syncs are counted. But that’s clearly not a problem.

@daiki

Also, isn’t it due to the contract plan rather than the amount of data?
In the Pro version, I think that the random numbers are reflected correctly.

What you are referring to there is Extra Data Sync mode, which should be available with any paid plan. When it’s enabled, Glide will sync with your spreadsheet every few minutes while users are active on your App. Which may or may not help.

Regardless, as I already mentioned - if you need to generate random numbers in Glide, then the best way to do it is with the plugin column that I linked to earlier.

@Random numbers change in googlesheet but not in Glide Data

I’ve tried this too…it’s a pro app feature to retrieve data in intervals. Rand(), Today() and Now() aren’t considered “edits to sheets” to refresh the app.

That post is two years old. A lot has changed since then. I’m pretty sure that @Robert_Petitto would agree with me when I say that using randbetween() in a GoogleSheet to generate random numbers is not a good idea.