# Complex google sheet reading **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** beginner\ **Created:** [October 23, 2021, 5:20pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434 "2021-10-23T17:20:26Z")\ **Posts on this page:** 20\ **Page:** 2
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [October 25, 2021, 9:34pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/21 "2021-10-25T21:34:00Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/6/1600678af860da0298763cf63709c939003849dd.png) mine is like this , what should i change ---
**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\ **Post date:** [October 25, 2021, 9:40pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/22 "2021-10-25T21:40:01Z")
we’re just trying to populate A2 of SEL here - so your data\_viewer\_grid1 should be showing your race buttons. hopefully it’s connected to a spreadsheet or local table containing Race\_name… then in above block, set id to 2 and set ‘to value=’ to race\_name (the column in your associated table that contains race name). in effect it says, if your press this button, take the race\_name associated with it and update cell a2 of tab SEL. if you have cell b2 with the correct formula, it should have a numeric index value for the race. your RESULT should automatically populate . now navigate to a new screen with another data viewer grid2 that is connected with RESULT tab and it should populate your data viewer grid. there are 2 data view grids in use here - and each one is connected to a different table. the first one, for selecting RACE is connected to a table with with columns: RACE PHOTO, RACE\_NAME. the 2nd one is connected to the RESULT tab i described above, (constructed with INDEX function). this data view grid is for viewing stats for the selected race. ---
**Author:** ![denemeyanilma892420](https://avatars.discourse-cdn.com/v4/letter/d/ad7895/32.png) [@denemeyanilma892420](https://community.thunkable.com/u/denemeyanilma892420)\ **Post date:** [October 25, 2021, 9:59pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/23 "2021-10-25T21:59:34Z")
my excel works incredible (thanks for that ) ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/5/3/5379841081174b10c4f629e8be4a7f64dd54d918.png) which part is wrong my sel excel ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/3/83ce4b51e03da6e2a81739aa1b819262e5ed9ee7.png) ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [October 25, 2021, 10:11pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/24 "2021-10-25T22:11:16Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/5/45b0cd725ab5c21e9b05842b80c942ac48f75220.png) isnt this supposed to be working based on my sel excel ---
**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\ **Post date:** [October 25, 2021, 10:16pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/25 "2021-10-25T22:16:09Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/8/884f5fb70f399515b6862f0e232cbc04a35c8b0b.png) ---
**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\ **Post date:** [October 25, 2021, 10:19pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/26 "2021-10-25T22:19:12Z")
you were close - the get\_value block should be pointing to the datasource (tab and column) connected to data\_viewer\_grid1 for the current rowid (not 11!). That datasource should contain races only, one row per source. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [October 25, 2021, 10:31pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/27 "2021-10-25T22:31:16Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/4/44192c703825e98a280b45a169cbe9e92e00be03.png) do ineed to create new tab for races? its still not working ---
**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\ **Post date:** [October 25, 2021, 10:43pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/28 "2021-10-25T22:43:30Z")
> [@manyone](#): > > the get\_value block should be pointing to the datasource (tab and column) connected to data\_viewer\_grid1 for the current rowid (not 11!). That datasource should contain races only, one row per source. that get\_value block should be pointing to tab that’s different from SEL - it’s the tab that contains the race buttonpictures and race names. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [October 25, 2021, 11:00pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/29 "2021-10-25T23:00:35Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/d/7/d7925db318be2e71ab65e360ec8af4bce1198d20.png) created new tab changed my data grid to this ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/6/c60c590d7e8689046ba468a9cb0372ba7ad4c8b3.png) and not working (i click picture , nothing happens) ---
**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\ **Post date:** [October 25, 2021, 11:35pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/30 "2021-10-25T23:35:15Z")
change your get\_value block to data\_viewer\_final, sheet to Sayfa7, column to race. try again. maybe you should also try , in the update value block, ‘for row id=’ to 1 navigate should go to the screen which shows the stats. ---
**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\ **Post date:** [October 26, 2021, 2:04am UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/31 "2021-10-26T02:04:43Z")
i was already making blocks and worksheets to illustrate my point, so i might as well make it functional. first of all , i don’t have much experience in sharing projects which have google sheets in them , the last time tried the sheets were converted to local tables so all the formulas disappeared. so in order to approximate the same set up i used, you need to copy my spreadsheet first and save it to your google drive BEFORE you open the project. > **[races](https://docs.google.com/spreadsheets/d/1uHVP4N47Q9wUmvRiW0wy5ImqPwHfW-5VcD4pGu0wmY0/edit?usp=sharing)** > > qual > > driver,team,r01pos,r01rating,r02pos,r02rating,r02pos,r03rating,r03pos,r03rating > Raymond Craig,Renault,639,38,277,68,207,62,291,79 > Hywel Allen,Ferrari,645,67,517,62,427,60,203,34 > Avni Byers,Mercedes,663,26,320,90,531,71,222,70 > Josef... here’s a link to my working project: [https://x.thunkable.com/copy/0122a74237617eb92bde117314b85dea](https://x.thunkable.com/copy/0122a74237617eb92bde117314b85dea) then make a copy of the project and run that copy. verify the data sources for the data grid viewers. the first one (in screen1) should have this data source: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/e/1e147f2b8341a834509a503ef752af4847e67981.png) the second one (in screen2) has this connection: ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/d/fd28654300ceacaa616efc9c1f52a1411afb1689.png) hopefully it will work. it works for me. good luck. ---
**Author:** ![denemeyanilma892420](https://avatars.discourse-cdn.com/v4/letter/d/ad7895/32.png) [@denemeyanilma892420](https://community.thunkable.com/u/denemeyanilma892420)\ **Post date:** [October 26, 2021, 6:21am UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/32 "2021-10-26T06:21:42Z")
i cant thank enough , thank you for your patiance for me 😃 and thank you for your work . ---
**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\ **Post date:** [October 26, 2021, 6:43am UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/33 "2021-10-26T06:43:20Z")
you’re welcome ---
**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\ **Post date:** [October 26, 2021, 7:43am UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/34 "2021-10-26T07:43:47Z")
you have to start thinking of your new challenge. this works with one person - when there are multiple users , does everyone carry a copy of all that data? maybe you can keep the major bulk of the data in cloud (i’m just repeating words - i’ve never used clouds in thunkable) but the dynamic part just keep in the user’s google drive. good luck! ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [October 29, 2021, 10:50am UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/35 "2021-10-29T10:50:45Z")
yes . my aim is to access my program to many people as possible but my new challange is , quite complex and smiple again @manyone . i m trying to screen 1 disappear i dont want to see on my bottom tab , i just want to acess it with my home tab. is it posiible to do that ? tahnks ---
**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\ **Post date:** [October 29, 2021, 5:21pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/36 "2021-10-29T17:21:38Z")
it should be possible - if you use the screen with navigation tabs, there are blocks you can test to detect when any of the navigation tabs is pressed. then there’s no need for the home key. ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [October 30, 2021, 5:12pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/37 "2021-10-30T17:12:44Z")
i did that it worked thanks , if you don’t mind, I have one more question . now I want to sort the index functions in my res tab…i want to list 1 position ,2nd positon till the last one . but when i try to sort it updates the first version . is it doable ? and if it is which excel function should i use ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [October 30, 2021, 6:08pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/38 "2021-10-30T18:08:16Z")
i did it with =SORT no worries 😃 ---
**Author:** ![manyone](https://avatars.discourse-cdn.com/v4/letter/m/ee59a6/32.png) [@manyone](https://community.thunkable.com/u/manyone)\ **Post date:** [October 30, 2021, 8:59pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/39 "2021-10-30T20:59:18Z")
i was going to suggest that - but you got it! ---
**Author:** ![unsalberkay1905cfbe](https://avatars.discourse-cdn.com/v4/letter/u/46a35a/32.png) [@unsalberkay1905cfbe](https://community.thunkable.com/u/unsalberkay1905cfbe)\ **Post date:** [October 30, 2021, 9:56pm UTC](https://community.thunkable.com/t/complex-google-sheet-reading/1577434/40 "2021-10-30T21:56:09Z")
@manyone now the thing is DNFed people are shown by 0 's im trying to convert 0’s to text with =MATCH , but i dont know how to MATCH AND SORT on the same cell . [Previous page](https://community.thunkable.com/t/complex-google-sheet-reading/1577434.md?page=1) [Next page](https://community.thunkable.com/t/complex-google-sheet-reading/1577434.md?page=3)