Hi i am trying to make a quiz app, using sheets to store the question i have the question and 4 possible answers displayed, but only one, the last one on the sheet, i would like it to pick a question at random there cureently 50 rows each ome the question and and the 4 possible answers but i dont know how to include rows in the selection process thanks in advanced
After you have loaded your table and removed the header row, this block can give you a random row from the table:
That row will be a list with 5 items in it, question and 4 answers.
If you want to repeatedly select random questions without repetition, instead choose a random index number from 1 to length of list(your table), and copy that row into your Labels before removing that index from the table.
Take a look at this extension »
It was suggested to solve a similar problem...
@>-->---
Hi i know im being thick but can you please show me more of this, all the blocks maybe sorry but still learning tnis
Here's my take on this, using a Media file copy of my sheet.
QuizSheet.aia (4.0 KB)
USMoneyQuiz - Sheet1.csv (512 Bytes)
(added to FAQ)