# Get data by ID in column A of google spreadsheet **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [April 22, 2021, 7:43pm UTC](https://community.thunkable.com/t/get-data-by-id-in-column-a-of-google-spreadsheet/1239734 "2021-04-22T19:43:07Z")\ **Posts on this page:** 10\ **Page:** 1
**Author:** ![ali744046s](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@ali744046s](https://community.thunkable.com/u/ali744046s)\ **Post date:** [April 22, 2021, 7:43pm UTC](https://community.thunkable.com/t/get-data-by-id-in-column-a-of-google-spreadsheet/1239734/1 "2021-04-22T19:43:07Z")
I searched the community for several hours and there was no way to help me. I have a spreadsheet made up of the rows and columns of the columns. They are the names of the subjects. I am the grades, so it is the students, and each student has a personal ID that is in column A. But id and id are required to be the row number and not the number in the first column. Is there a way to solve this problem? ---
**Author:** ![ali744046s](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@ali744046s](https://community.thunkable.com/u/ali744046s)\ **Post date:** [April 22, 2021, 7:44pm UTC](https://community.thunkable.com/t/get-data-by-id-in-column-a-of-google-spreadsheet/1239734/2 "2021-04-22T19:44:55Z")
Using a google spreadsheet ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [April 22, 2021, 8:24pm UTC](https://community.thunkable.com/t/get-data-by-id-in-column-a-of-google-spreadsheet/1239734/3 "2021-04-22T20:24:55Z")
I’m sorry but your explanation is not clear to me. Maybe a screenshot of your spread sheet and mark what you want so someone from the community can help. ---
**Author:** ![ali744046s](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@ali744046s](https://community.thunkable.com/u/ali744046s)\ **Post date:** [April 22, 2021, 9:40pm UTC](https://community.thunkable.com/t/get-data-by-id-in-column-a-of-google-spreadsheet/1239734/4 "2021-04-22T21:40:12Z")
**This is my spreadsheet** \*\* ![AAA4](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/9/098b549ad772d90c2bb176afb8c4286f489c4082.png) \*\* **This is the interface of the application** **The user enters an ID in the text box, and when he clicks, his academic grades appear in the other columns** \*\* ![AAA1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/5/45a775eb5a4ca68c8288c9f8dbcea7fe2db04f5e.png) \*\* **But this problem does not search for the value in the first column, rather it will fetch the value of the original row number** ![AAA5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/7/77bb441e4435ea289dfec499993a53010c94f248.png) ---
**Author:** ![ali744046s](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@ali744046s](https://community.thunkable.com/u/ali744046s)\ **Post date:** [April 22, 2021, 9:41pm UTC](https://community.thunkable.com/t/get-data-by-id-in-column-a-of-google-spreadsheet/1239734/5 "2021-04-22T21:41:53Z")
This is my spreadsheet \*\* ![AAA4](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/9/098b549ad772d90c2bb176afb8c4286f489c4082.png) \*\* **This is the interface of the application** **The user enters an ID in the text box, and when he clicks, his academic grades appear in the other columns** \*\* ![AAA1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/5/45a775eb5a4ca68c8288c9f8dbcea7fe2db04f5e.png) \*\* **But this problem does not search for the value in the first column, rather it will fetch the value of the original row number** ![AAA5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/7/77bb441e4435ea289dfec499993a53010c94f248.png) ---
**Author:** ![muneer](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/muneer/32/75210_2.png) [@muneer](https://community.thunkable.com/u/muneer)\ **Post date:** [April 22, 2021, 10:49pm UTC](https://community.thunkable.com/t/get-data-by-id-in-column-a-of-google-spreadsheet/1239734/6 "2021-04-22T22:49:18Z")
The row id is a special number not the code and not any of the columns. You have to create a procedure to search for the ID your user enters and from there you get the “row id”. ---
**Author:** ![ali744046s](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@ali744046s](https://community.thunkable.com/u/ali744046s)\ **Post date:** [April 22, 2021, 10:55pm UTC](https://community.thunkable.com/t/get-data-by-id-in-column-a-of-google-spreadsheet/1239734/7 "2021-04-22T22:55:26Z")
How to be this I am still a beginner ---
**Author:** ![bader\_mouti](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/bader_mouti/32/98887_2.png) [@bader\_mouti](https://community.thunkable.com/u/bader_mouti)\ **Post date:** [April 22, 2021, 11:13pm UTC](https://community.thunkable.com/t/get-data-by-id-in-column-a-of-google-spreadsheet/1239734/8 "2021-04-22T23:13:19Z")
In this case, it is better to use Firebase The application will work twice as fast And smooth and you can build a web app and connect it to the same Firebase and you can use it as control-panel ---
**Author:** ![ali744046s](https://avatars.discourse-cdn.com/v4/letter/a/22d042/32.png) [@ali744046s](https://community.thunkable.com/u/ali744046s)\ **Post date:** [April 22, 2021, 11:16pm UTC](https://community.thunkable.com/t/get-data-by-id-in-column-a-of-google-spreadsheet/1239734/9 "2021-04-22T23:16:37Z")
Yes, I did not think about it. I can send the schedule data to the fire base and then receive the data from the application. Thank you for the solution ---
**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, 1:25pm UTC](https://community.thunkable.com/t/get-data-by-id-in-column-a-of-google-spreadsheet/1239734/10 "2024-11-08T13:25:05Z")