# Football Quiz App - show random question

**URL:** <https://community.glideapps.com/t/football-quiz-app-show-random-question/52191>\
**Category:** Ask for Help\
**Created:** [October 21, 2022, 11:44am UTC](https://community.glideapps.com/t/football-quiz-app-show-random-question/52191 "2022-10-21T11:44:17Z")\
**Posts on this page:** 5\
**Page:** 1

<div class="post-metadata">

**Author:** ![Thel93210](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thel93210/32/21926_2.png) [@Thel93210](https://community.glideapps.com/u/Thel93210)\
**Post date:** [October 21, 2022, 11:44am UTC](https://community.glideapps.com/t/football-quiz-app-show-random-question/52191/1 "2022-10-21T11:44:18Z")

</div>

Im working on a football quizz app.

It’s pretty simple, the aime is to find the player. example “Which brazilian striker played for fc barcelona / real madrid and milan ac?”  
Answer : Ronaldo

Once user answerds question, a button " go to next question" appears.  
When user clicks on it it should shows a new screen with an other RANDOM question not the following question in the tab.

Do you know how to do it ?

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [October 21, 2022, 4:57pm UTC](https://community.glideapps.com/t/football-quiz-app-show-random-question/52191/2 "2022-10-21T16:57:02Z")

</div>

Hola!

Yes, it’s possible… I made one months ago to be played by group and time.

But with new Glide pricing, this kind of game is an edits eater literally 🤒

Saludos!

---

<div class="post-metadata">

**Author:** ![Thel93210](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thel93210/32/21926_2.png) [@Thel93210](https://community.glideapps.com/u/Thel93210)\
**Post date:** [October 21, 2022, 5:18pm UTC](https://community.glideapps.com/t/football-quiz-app-show-random-question/52191/3 "2022-10-21T17:18:54Z")

</div>

I think, I have found a way. Each row has a question number, then I have done a join list of question number and a split list.  
After, i have done a single value “random” of this split list .  
Like this I can make a relation between this random single value and the question number of the row and it give the next question.  
Each time a row is seen, question number is deleted from the join list of question number

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/1/91298f41ec247a5ad8b9d108e5dc69528b8c0457.png)

I use @Robert_Petitto tuto : [Loom | Free Screen & Video Recording Software | Loom](https://www.loom.com/share/d61f5c61a1b14c29ad0df6eea480b5bd)

The last issue, is to clean all data on each row once the game is over.

---

<div class="post-metadata">

**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\
**Post date:** [October 21, 2022, 5:33pm UTC](https://community.glideapps.com/t/football-quiz-app-show-random-question/52191/4 "2022-10-21T17:33:26Z")

</div>

> [@Thel93210](#):
>
> The last issue, is to clean all data on each row once the game is over.

That is a big issue!

Your game will be played individually or in a group?

---

<div class="post-metadata">

**Author:** ![Thel93210](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thel93210/32/21926_2.png) [@Thel93210](https://community.glideapps.com/u/Thel93210)\
**Post date:** [October 21, 2022, 6:13pm UTC](https://community.glideapps.com/t/football-quiz-app-show-random-question/52191/5 "2022-10-21T18:13:47Z")

</div>

In the first time, game will be played individually. Most of the columns are user specific

Then, if people like app, I will add new feature : play against other users