# How to store the choice data?

**URL:** https://community.glideapps.com/t/how-to-store-the-choice-data/6672
**Category:** Ask for Help
**Created:** [April 9, 2020, 1:22pm UTC](https://community.glideapps.com/t/how-to-store-the-choice-data/6672 "2020-04-09T13:22:56Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![erwblo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/erwblo/32/75_2.png) [@erwblo](https://community.glideapps.com/u/erwblo)
#### Post date: [April 9, 2020, 1:22pm UTC](https://community.glideapps.com/t/how-to-store-the-choice-data/6672/1 "2020-04-09T13:22:56Z")

</div>

Working on my quiz. I have a sheet with questions, with users and with options.  
In an ideal world I would like 1) read question 1 2) answer question 1 3) go to question 2. Any ideas about how to do that?

But I would be happy with the following as well: show a list of questions, go to question 1, be able to choose between answer 1 to 4 of question 1, go back to list, choose question 2, be able to choose answer 5 to 8 of question 2 etc.

Is the last thing possible? Or can you only have the same choices for every question?

Something else in this respect. When I make a Choice option, I know how to get the right options for people to choose from, but I would expect to be able to choose the sheet where to write the data to. I now only can choose the sheet am at?

---

<div class="post-metadata">

### Author: ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 11, 2020, 4:47pm UTC](https://community.glideapps.com/t/how-to-store-the-choice-data/6672/2 "2020-04-11T16:47:43Z")

</div>

You’ve obviously seen @Robert_Petitto’s quiz app and his thread, so I think that would be the best option for your first idea.

[https://community.glideapps.com/t/testing-daily-quiz-app/6267](https://community.glideapps.com/t/testing-daily-quiz-app/6267)

For you second option, I would create a relation column in your question sheet that relates the question to a sheet with potential answers for each question. Then use the relation to fill the choice component uniquely for each question. As far writing the answers to a different sheet, I would either wait for User Specific columns, use a form to write responses to a different sheet, or duplicate the questions for each user and save the answer in the question row.
