How to randomize questions in a quiz app

Hi everyone,

I’m working on a quiz app for my diploma project, using the official Thunkable tutorial on YouTube (it’s titled How to Create a Quiz App with Thunkable)

Since my inspiration is Kahoot and other similar quiz apps, I want to randomize the questions each time the quiz starts. The questions and answers are pulled from a Google Spreadsheet, and I’ve tried various methods to shuffle them, but nothing seems to work.

I’ve searched many tutorials for quiz apps, but i’ve found nothing; also the original thread for the Quiz App tutorial is closed.

Is there anyone who has built something similar or who can help me create the logic for a question randomizer correctly in Thunkable?

Any help or example blocks would be really appreciated!

Thank you!

P.S.: I also want to disable the answer buttons when the timer runs out. However, when I tried doing that, all the answers get greyed out before showing which one was correct or incorrect. Ideally, I want the correct and incorrect answers to be highlighted first, and then disable the buttons — so that players can’t change their answer after seeing the correct one.

Thanks in advance for your help!

Hi,

Off the top of my head, in order to randomise and not repeat questions, you need to create another Google sheet

Question Number Asked
1 N
2 N
3 N

etc.

At the start, update the sheet to reset all Asked to N, then generate a random number between 1 and the last question number.

Query the questions sheet to check value of Asked.

If it is N (should be on the first run), change value to Y and then select that question number from your quiz table.

If it is Y, repeat random number generation and rerun check.

Repeat until all the questions have been asked.

Thank you for responding to my question.

I’m trying to understand your solution, but I’m building an app based on a spreadsheet like the one shown in the Thunkable tutorial (this is just an example I found there).

That means I’m not sure how much I need to change the existing app blocks to work with this new sheet. I just started learning Thunkable on my own two weeks ago, so if it’s not too much trouble, could you please explain your solution step by step? (Basically, explain it to me like I’m five!)

P.S. I’ve tried using AI models for help, but they keep giving me results for the old version of Thunkable.