Random numbers set on a spreadsheet no longer connect to Glide

[daiki]

My APP’s URL:https://helpful-chance-6903.glideapp.io

I had an APP that linked random numbers generated in a spreadsheet, but for some reason it no longer connects.

Example: =randbetween(1,3)
When you perform an action on the APP, the action will be reflected based on the random function.

However, since the other day, the situation where only the same number appears all the time continues.

Originally, numbers are reflected randomly from 1 to 3,
It seems that only 1 appears all the time.

By the way, if you operate directly from the application creation screen instead of from the application, random numbers will be reflected.

Is it due to the contract plan?
This app subscribes to “Starter Team” for $25/month.

what is the problem Also, do you know how to reconnect the data source to the spreadsheet correctly?

[daiki]

I’m assuming this topic is similar…

Random numbers change in googlesheet but not in Glide Data

My app’s URL: https://r4ale.glideapp.io I want my app to show random messages, so I’ve created in my GoogleSheets table a column with a formula that generates random numbers, and I set up the visibility according to the numbers in this column. The thing is that although the numbers do change in the google sheet, they remain the same in the Glide app data. Even if I press “Reload Sheet”.

[Darren_Murphy]

@daiki

Is it due to the contract plan?

You should be able to check your usage dashboard to see if you have hit any limits.

@daiki

Also, do you know how to reconnect the data source to the spreadsheet correctly?

Settings->Data->Data Sources->Replace
You can replace the Google Sheet with itself.

@daiki

Example: =randbetween(1,3)

RANDBETWEEN() is a volatile function and is best avoided as it can slow your spreadsheet down.

A much better option in this case is to use the Roll Dice plugin column.
If you use that, then you get instant results in the App and you eliminate any data sync concerns.

[daiki]

thank you!

@Darren_Murphy

You should be able to check your usage dashboard to see if you have hit any limits.

What part of the dashboard should I check?

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.

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.

[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.