# Get data from spreadsheet **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [November 9, 2019, 12:12pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057 "2019-11-09T12:12:24Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![farhadkubd1](https://avatars.discourse-cdn.com/v4/letter/f/b38774/32.png) [@farhadkubd1](https://community.thunkable.com/u/farhadkubd1)\ **Post date:** [November 9, 2019, 12:12pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/1 "2019-11-09T12:12:24Z")
Hello, I have a spreadsheet where some quiz are existed. I want to call them into my app question label. I was trying to find video tutorial but there is no such videos using x. Could you brothers help me. I have put the API only in spreadsheet properties. ---
**Author:** ![BlueWhaleYT](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bluewhaleyt/32/28437_2.png) [@BlueWhaleYT](https://community.thunkable.com/u/BlueWhaleYT)\ **Post date:** [November 9, 2019, 12:44pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/2 "2019-11-09T12:44:46Z")
Hi there, I had did a tutorial before,it included get data action. > [@Add data from Airtable tutorial \[Blocks share\]](http://community.thunkable.com/t/add-data-from-airtable-tutorial-blocks-share/100881): > > This is my first tutorial.i am sorry slight_smile Prepare a database to do this slight_smile ---
**Author:** ![domhnallohanlon](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/domhnallohanlon/32/29554_2.png) [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)\ **Post date:** [November 9, 2019, 4:58pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/3 "2019-11-09T16:58:05Z")
> [@farhadkubd1](#): > > I was trying to find video tutorial Here you go! 😃 [![](https://img.youtube.com/vi/nT18ufBAUTQ/maxresdefault.jpg "Quiz App Design Walkthrough [Snap to Place]") ](https://www.youtube.com/watch?v=nT18ufBAUTQ) [![](https://img.youtube.com/vi/v8pNnBqKdjM/maxresdefault.jpg "Quiz App Blocks Walkthrough [Snap to Place]") ](https://www.youtube.com/watch?v=v8pNnBqKdjM) ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [December 9, 2019, 4:36pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/4 "2019-12-09T16:36:41Z")
This is a great tutorial. I am using it now. I am wondering if there is a way to randomize the order of the answers when they appear on the screen each time any given question appears. I am thinking, go through the quiz once. get a score and time to complete the quiz. Then go through it again and try to get a higher score in less time. The way to prevent learning the position of the buttons, to force learning and attending to occur, i want them to rotate the next time the user sees the same quiz. Does anyone have any suggestions for this? ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [December 9, 2019, 4:46pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/5 "2019-12-09T16:46:28Z")
Use a randomization block for a list ![изображение](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/0/80ada1ccf509e247e04e9f4fa4283e46aaac5f5f.png) ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [December 9, 2019, 5:09pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/6 "2019-12-09T17:09:09Z")
Thank you!! @actech I have a follow-up question. Example of my qustion how do i ensure that if, for example, button 1 is displaying answer 3, how do i make sure that answer 3 is not repeated on any other button and that all other potential answers are displayed. My questions and answers all come from the local DB let me include shots of the code. this is where I’m at so far with randomizing what appears on the buttons. seems like there would be some additional if/then statements but i am not sure how to set this part up. ![Screen Shot 2019-12-09 at 11.58.11 AM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/a/ea5b264611cfe74715b49d828488798c95809b83.png) ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [December 9, 2019, 5:28pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/8 "2019-12-09T17:28:07Z")
If you use the random block, you must remove the previously selected item from the list. I suggest you use another block - shuffle ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [December 9, 2019, 5:59pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/9 "2019-12-09T17:59:31Z")
[https://x.thunkable.com/copy/a5980307cbfae04c7f438a8f439a1cbd](https://x.thunkable.com/copy/a5980307cbfae04c7f438a8f439a1cbd) here is a link to the project. maybe this would help. ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [December 9, 2019, 6:43pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/10 "2019-12-09T18:43:35Z")
On your screen, a large number of repeating blocks. Simplify them and then it will be easier to understand what needs to be done. Everything can be made much simpler. In Excel, create a question and 5 answers in neighboring cells. At the end of the correct answer, add an invisible plus symbol, for example. After that, you need to create a list with answers (neighboring cells in Excel are separated by a tab character), which are randomly mixed. If the answer contains an invisible plus symbol, then this is the correct answer. ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [December 9, 2019, 7:18pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/11 "2019-12-09T19:18:22Z")
I have accomplished my task. Check it out! Between you @actech and @jane I have created another successful starter app for my Grad Lab. On behalf of the Florida Institute of Technologies school of Behavior Analysis, thanks you both! ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [December 9, 2019, 7:53pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/12 "2019-12-09T19:53:24Z")
Сheck it. Now will you be able to complete the app? [https://x.thunkable.com/projects/5dee8c3ef3d8c807d60c6bd9/project/properties/designer/](https://x.thunkable.com/projects/5dee8c3ef3d8c807d60c6bd9/project/properties/designer/) ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [December 10, 2019, 3:53pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/13 "2019-12-10T15:53:31Z")
I have this working!!! using 2 localDB to keep things clean though is a pain. just as much as using a table with a lot of rows. I want to share this with everybody! the issue i am having currently is that the buttons do not disable after being cliicked. I want them to be disabled upon click, and not enabled until all new information has populated on the screen. any thoughts on this? I have disabled the buttons after click in the code but this doesn’t seem to do the trick [https://x.thunkable.com/copy/f204698a01765be5af53119c1b8de9ca](https://x.thunkable.com/copy/f204698a01765be5af53119c1b8de9ca) ![Screen Shot 2019-12-10 at 10.44.31 AM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/1/11174b8a09c0ebf82d3dc240ebc9bcdb52141e17.png) now to add back in the color change for buttons after responding! ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [December 10, 2019, 7:21pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/14 "2019-12-10T19:21:49Z")
Update! working perfectly now. now to add back in the color change component for buttons after they have been clicked ![Screen Shot 2019-12-10 at 2.12.20 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/0/a08c75c6bf919756d4169c4439c53db72fa46fcf.png) ---
**Author:** ![empoylangpogi4jca8r](https://avatars.discourse-cdn.com/v4/letter/e/9fc348/32.png) [@empoylangpogi4jca8r](https://community.thunkable.com/u/empoylangpogi4jca8r)\ **Post date:** [March 25, 2021, 12:05pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/15 "2021-03-25T12:05:40Z")
Hi ! I’m also working on a quiz app similar to this I’m wondering if what is the importance of which quiz in this block I’m confused so I’m looking for some similar project like mine. Hope you can help me with this. ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [March 25, 2021, 3:52pm UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/16 "2021-03-25T15:52:11Z")
^^ was how I was switching between quizzes. I would likely take a different approach now. ---
**Author:** ![empoylangpogi4jca8r](https://avatars.discourse-cdn.com/v4/letter/e/9fc348/32.png) [@empoylangpogi4jca8r](https://community.thunkable.com/u/empoylangpogi4jca8r)\ **Post date:** [March 26, 2021, 3:16am UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/17 "2021-03-26T03:16:28Z")
Sir can you tell me new ways to solve this kind of situation. The question isn’t showing in the choices when I do a live test ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [March 26, 2021, 11:03am UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/18 "2021-03-26T11:03:13Z")
Hey! Check out this example [Quiz example](https://x.thunkable.com/projectPage/5dee6ec8c4c163ce47b007f7) And [This other example](https://x.thunkable.com/projects/5e9f43cacdefcd093a4d78ce/4a5ac407-3762-438e-a563-11a540c9e9dd/designer) ---
**Author:** ![empoylangpogi4jca8r](https://avatars.discourse-cdn.com/v4/letter/e/9fc348/32.png) [@empoylangpogi4jca8r](https://community.thunkable.com/u/empoylangpogi4jca8r)\ **Post date:** [March 30, 2021, 4:26am UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/19 "2021-03-30T04:26:13Z")
@jared sorry for my late response I did check your work man thanks you save me a lot of time. hope you doing well stay safe ! Thank you again. ---
**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\ **Post date:** [November 8, 2024, 11:46am UTC](https://community.thunkable.com/t/get-data-from-spreadsheet/311057/20 "2024-11-08T11:46:26Z")