Random button

[Edwin_van_der_Geest]

Hi,

I’m using Glide for a couple of days now, and I love it. I created this app with a lot of questions to choose from: https://check-inspiration.glideapp.io/.

I created a tab for a Randomizer. Now I would like to add a button to ‘roll the dice’ another time for a new question. So when you click on that button, a new random question appears. Hope I explained it clear enough.

Thanks!

[Robert_Petitto]

Yep! Did something like this here:

funandgames.glideapp.io

or

Draw Someone Who

[Edwin_van_der_Geest]

Ah thanks Robert!

I will try to reproduce that. Love your app by the way.

[Edwin_van_der_Geest]

Hey Robert,

I thought I had it. Used a Form button. But When I come back at the question, it’s still the same. Do you use any kind of trick I cannot see?

Thanks!

[Jeff_Hager]

What sheet does your random tab use? Is it the same sheet as the form responses? If it is, then go to features for that tab and set the sort to reverse order. That way the details of the tab should show the last record in the form response sheet instead of the first.

[Robert_Petitto]

Yep that was one of my tricks. Use reverse sort order so you always see the most recent choice on top.

[Edwin_van_der_Geest]

Thanks Jeff and Robert. Somehow it doesn’t work. I’m still a noob, so probably it’s my configuration.

On the random tab I used the detailed view, with random order (based on the same sheet as the all questions tab). That gives me one random question. When I use the button with the form, it doesn’t change to another random question.

What am I doing wrong/missing?

Thanks!

[Robert_Petitto]

In my app, Glide doesn’t determine the random sentence, my spreadsheet does. I don’t use random sort, I let the spreadsheet pic a random number upon form entry and then do a relation to that sentence.

[Edwin_van_der_Geest]

Thanks Robert.

How can I make my spreadsheet to pic a random sentence? (sorry for all those questions)

[Manan_Mehta]

Assign serial numbers to each question in your spreadsheet, then use the random value formula to choose a random number which varies from the first and last number in your questions. Then relate the number with the questions on your spreadsheet. Every time your press the form button, copy the number value from the random value cell and use that to display the question linked to it.

[Robert_Petitto]

The RandomWhoValue Column writes to the WhoValue column for permanence since the RandomWhoColumn will change upon every sheet edit.