# Quiz with lists (from list) in CSV format (google drive) **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [June 19, 2018, 12:59am UTC](https://community.thunkable.com/t/quiz-with-lists-from-list-in-csv-format-google-drive/32172 "2018-06-19T00:59:57Z")\ **Posts on this page:** 12\ **Page:** 1
**Author:** ![alfcanova](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/alfcanova/32/20747_2.png) [@alfcanova](https://community.thunkable.com/u/alfcanova)\ **Post date:** [June 19, 2018, 12:59am UTC](https://community.thunkable.com/t/quiz-with-lists-from-list-in-csv-format-google-drive/32172/1 "2018-06-19T00:59:57Z")
Hi all, I have some experience with AI2 (MIT). But I’m lost with this ThunkableX, I’m developing a Quiz with list originating from a CSV (Google Drive) file. When I hit the Quiz button the screen turns white and nothing happens (nor an error message). I’m following a ScreenShot screen, any help is welcome thankful André Blocks - Part 1/2 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/4/34b14ffa6532d9d935da262942597dd0219fda35.png) Blocks - Part 2/2 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/4/84ded69e6005404bb8998f61d11fe91d4ad9a7dd.png) ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [June 19, 2018, 5:56am UTC](https://community.thunkable.com/t/quiz-with-lists-from-list-in-csv-format-google-drive/32172/2 "2018-06-19T05:56:08Z")
Hi, Do you test your application on Android? If you give a link to your project, I will find the reason for the appearance of a white screen. Unfortunately, the white screen appears quite often on Android and to find out its causes sometimes it turns out by means of step-by-step debugging, when all components are sequentially disconnected and checked their properties, or by means of “adb logcat”. ---
**Author:** ![alfcanova](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/alfcanova/32/20747_2.png) [@alfcanova](https://community.thunkable.com/u/alfcanova)\ **Post date:** [June 19, 2018, 2:29pm UTC](https://community.thunkable.com/t/quiz-with-lists-from-list-in-csv-format-google-drive/32172/3 "2018-06-19T14:29:17Z")
Hi, Yes I use Android Phone. The white screen problem I solved by changing: “make list from text from **WebQuiz.Body** ” for “make list from text from **response** ”. But I’m still in doubt, could you help me? 1. “in list remove first” remove first element of table not first row (AI2 removes the entire line). 2. “make list from text from **response** ” with delimiter “,” not make a 7 colluns 3. I can´t make sublists [https://x.thunkable.com/copy/51a4215b97e1a9b31860f79f6e31fb8b](https://x.thunkable.com/copy/51a4215b97e1a9b31860f79f6e31fb8b) Thanks André ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [June 19, 2018, 4:00pm UTC](https://community.thunkable.com/t/quiz-with-lists-from-list-in-csv-format-google-drive/32172/4 "2018-06-19T16:00:41Z")
I understood your questions. Now I’ll look at the project. Alex ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [June 19, 2018, 4:19pm UTC](https://community.thunkable.com/t/quiz-with-lists-from-list-in-csv-format-google-drive/32172/5 "2018-06-19T16:19:47Z")
The problem is that the “list from text with delimiter” block splits all the data from the table into rows - the character \n does not work (in Thunkable X from Excel) and a whitespace character is substituted for it. To solve this problem, you need to use a unique symbol at the end of each row to divide the data into rows: Pergunta,Correta,altA,altB,altC,altD,altE # Traduzir para o Ingles: Verde,E,Brown,Red,White,Purple,Green # Traduzir para o Ingles: Verde,E,Brown,Red,White,Purple,Green # Traduzir para o Ingles: Verde,E,Brown,Red,White,Purple,Green # Traduzir para o Ingles: Verde,E,Brown,Red,White,Purple,Green # Traduzir para o Ingles: Verde,E,Brown,Red,White,Purple,Green # Traduzir para o Portugues: Azul,B,Blue,Red,White,Purple,Green # Traduzir para o Portugues: Azul,B,Blue,Red,White,Purple,Green # Traduzir para o Portugues: Azul,B,Blue,Red,White,Purple,Green # Traduzir para o Portugues: Azul,B,Blue,Red,White,Purple,Green # Traduzir para o Portugues: Azul,B,Blue,Red,White,Purple,Green First, you divide the data into rows by the symbol “#”, and then divide the selected row into fields by the symbol “,”. To get a clean data, use the “trim” block. ---
**Author:** ![alfcanova](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/alfcanova/32/20747_2.png) [@alfcanova](https://community.thunkable.com/u/alfcanova)\ **Post date:** [June 19, 2018, 7:37pm UTC](https://community.thunkable.com/t/quiz-with-lists-from-list-in-csv-format-google-drive/32172/6 "2018-06-19T19:37:19Z")
Hi, thanks a lot! But not work again… I try use # in many ways, like: Pergunta,Correta,altA,altB,altC,altD,altE # (in same cell of altE) Pergunta,Correta,altA,altB,altC,altD,altE# (in same cell of altE) Pergunta,Correta,altA,altB,altC,altD,altE,# (in new cell) Please, what am I doing wrong? [https://x.thunkable.com/copy/9f51eead667ded76a370baaba593e9db](https://x.thunkable.com/copy/9f51eead667ded76a370baaba593e9db) Thanks for any help André ---
**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:** [June 26, 2019, 9:15am UTC](https://community.thunkable.com/t/quiz-with-lists-from-list-in-csv-format-google-drive/32172/7 "2019-06-26T09:15:04Z")
2 posts were split to a new topic: [Can I download a .CSV file from Google Drive?](https://community.thunkable.com/t/can-i-download-a-csv-file-from-google-drive/121400) ---
**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:** [June 26, 2019, 9:16am UTC](https://community.thunkable.com/t/quiz-with-lists-from-list-in-csv-format-google-drive/32172/9 "2019-06-26T09:16:38Z")
3 posts were split to a new topic: [How to download from Google Drive?](https://community.thunkable.com/t/how-to-download-from-google-drive/121402) ---
**Author:** ![alfcanova](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/alfcanova/32/20747_2.png) [@alfcanova](https://community.thunkable.com/u/alfcanova)\ **Post date:** [July 4, 2018, 1:27am UTC](https://community.thunkable.com/t/quiz-with-lists-from-list-in-csv-format-google-drive/32172/12 "2018-07-04T01:27:16Z")
Hi all, I use Airtable version of Spreadsheet, more easy in blocks mode. But some problems remains, like can I find maxrows and others, but workarround is possible like turn “END” in the first cell of last row. Thanks a lot, André ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [July 4, 2018, 6:21am UTC](https://community.thunkable.com/t/quiz-with-lists-from-list-in-csv-format-google-drive/32172/13 "2018-07-04T06:21:47Z")
For two-dimensional data, the variant with the table is used. ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [July 4, 2018, 6:31am UTC](https://community.thunkable.com/t/quiz-with-lists-from-list-in-csv-format-google-drive/32172/14 "2018-07-04T06:31:05Z")
Hi, Are you looking for this function? ![maxrownum](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/f/ffddffca329e308ac07bb531a3a15bbe6f9c68fe.png) In Thunkable X, you can retrieve or change any data in any fields after initially retrieving all the data from the AirTable. ---
**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, 12:02pm UTC](https://community.thunkable.com/t/quiz-with-lists-from-list-in-csv-format-google-drive/32172/15 "2024-11-08T12:02:12Z")