Solved: Random number fct

loubou · ‎09-08-2019

Hi guys!

I am currently building an app to learn some German Vocabulary. Basically, my app is linked to an excel with all my vocabulary, where each word has an ID, as with a database. To create a quiz, I need five random ID for five random words. I do it using five label boxes and the following code:

First(Shuffle (Verbes.ID)).ID
However, when my first set of 5 questions is over, I do not know how to "refresh" those five label boxes without closing and opening again the app. Can someone please help me?

Thank you in advance!

Pstork1 · ‎09-08-2019

for the button that gets the next set of questions add formulas that set 5 different variables to random numbers. Something like this:

Set(var1,Rand()*100);Set(var2,Rand()*100);Set(var3,Rand()*100);Set(var4,Rand()*100);Set(var5,Rand()*100)

Use the values in the variables for the IDs for each question. Each time you press the button you will get 5 new random numbers.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Pstork1 · ‎09-08-2019

for the button that gets the next set of questions add formulas that set 5 different variables to random numbers. Something like this:

Set(var1,Rand()*100);Set(var2,Rand()*100);Set(var3,Rand()*100);Set(var4,Rand()*100);Set(var5,Rand()*100)

Use the values in the variables for the IDs for each question. Each time you press the button you will get 5 new random numbers.

-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.