# \[Solved\] How to convert Row ID to Text **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [November 26, 2023, 12:47pm UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098 "2023-11-26T12:47:37Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![myaccount](https://avatars.discourse-cdn.com/v4/letter/m/a6a055/32.png) [@myaccount](https://community.thunkable.com/u/myaccount)\ **Post date:** [November 26, 2023, 12:47pm UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/1 "2023-11-26T12:47:37Z")
Hey there, I had a question, How to convert Row Id to text. So I just want to pick up data from google spreadsheet through data viewer list and when one of the options in clicked that option should go to other row in the spreadsheet. Please help. ---
**Author:** ![vishruth-ram](https://avatars.discourse-cdn.com/v4/letter/v/82dd89/32.png) [@vishruth-ram](https://community.thunkable.com/u/vishruth-ram)\ **Post date:** [November 27, 2023, 4:35am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/2 "2023-11-27T04:35:24Z")
you can store the row ID in variable and then get the value for rowid ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [November 27, 2023, 8:39am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/3 "2023-11-27T08:39:55Z")
For help you better show an example of your viewer and the data you have inside . You have to find a connection between the data after click and the data you want to retrieve (the data in the clicked row and the row you want to find). ---
**Author:** ![vishruth-ram](https://avatars.discourse-cdn.com/v4/letter/v/82dd89/32.png) [@vishruth-ram](https://community.thunkable.com/u/vishruth-ram)\ **Post date:** [November 27, 2023, 8:41am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/4 "2023-11-27T08:41:52Z")
[How to ask Great Questions v2.0](https://community.thunkable.com/t/how-to-ask-great-questions-v2-0/2689983) ---
**Author:** ![myaccount](https://avatars.discourse-cdn.com/v4/letter/m/a6a055/32.png) [@myaccount](https://community.thunkable.com/u/myaccount)\ **Post date:** [November 27, 2023, 8:42am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/5 "2023-11-27T08:42:39Z")
![Screenshot 2023-11-27 at 2.11.33 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/1/31a7f18f6fe0e39e167722cf1e5e96bff8644a24.png) When one of this item is clicked it should show the item clicked in google spreadsheet, but it is showing the row id. ---
**Author:** ![vishruth-ram](https://avatars.discourse-cdn.com/v4/letter/v/82dd89/32.png) [@vishruth-ram](https://community.thunkable.com/u/vishruth-ram)\ **Post date:** [November 27, 2023, 8:43am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/6 "2023-11-27T08:43:36Z")
Like I said use the row id to get the appropriate value ---
**Author:** ![myaccount](https://avatars.discourse-cdn.com/v4/letter/m/a6a055/32.png) [@myaccount](https://community.thunkable.com/u/myaccount)\ **Post date:** [November 27, 2023, 8:43am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/7 "2023-11-27T08:43:54Z")
I am asking how to convert row id to text. ---
**Author:** ![vishruth-ram](https://avatars.discourse-cdn.com/v4/letter/v/82dd89/32.png) [@vishruth-ram](https://community.thunkable.com/u/vishruth-ram)\ **Post date:** [November 27, 2023, 8:44am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/8 "2023-11-27T08:44:31Z")
Still can’t understand ---
**Author:** ![myaccount](https://avatars.discourse-cdn.com/v4/letter/m/a6a055/32.png) [@myaccount](https://community.thunkable.com/u/myaccount)\ **Post date:** [November 27, 2023, 8:46am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/9 "2023-11-27T08:46:06Z")
So, I am getting the row id when of the item is clicked on this list. But I want the exact same text written over here in one of the rows in google spreadsheet ---
**Author:** ![vishruth-ram](https://avatars.discourse-cdn.com/v4/letter/v/82dd89/32.png) [@vishruth-ram](https://community.thunkable.com/u/vishruth-ram)\ **Post date:** [November 27, 2023, 8:49am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/10 "2023-11-27T08:49:33Z")
Then, you can create a list(variable) with all the values of the viewer in the same order, then get the value for the row id and add it the google sheet. ---
**Author:** ![myaccount](https://avatars.discourse-cdn.com/v4/letter/m/a6a055/32.png) [@myaccount](https://community.thunkable.com/u/myaccount)\ **Post date:** [November 27, 2023, 8:50am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/11 "2023-11-27T08:50:32Z")
Can you show it in thinkable. Thank you ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [November 27, 2023, 9:11am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/12 "2023-11-27T09:11:39Z")
Show the sheet too. You have to use the id row to get the right column in the sheet where you stored the text ---
**Author:** ![myaccount](https://avatars.discourse-cdn.com/v4/letter/m/a6a055/32.png) [@myaccount](https://community.thunkable.com/u/myaccount)\ **Post date:** [November 27, 2023, 9:18am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/13 "2023-11-27T09:18:48Z")
![Screenshot 2023-11-27 at 2.48.24 PM](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/9/99829243a714ab31a1816a0496663d2edc9da646.png) Here it is, I want the numbers to be text ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [November 27, 2023, 9:24am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/14 "2023-11-27T09:24:38Z")
Which number ? I see only one column. If you want the id number as @vishruth-ram said , after click save the id in a variable ad use it like text. If you want the column E you have to use the get block with the Id and the column E ---
**Author:** ![myaccount](https://avatars.discourse-cdn.com/v4/letter/m/a6a055/32.png) [@myaccount](https://community.thunkable.com/u/myaccount)\ **Post date:** [November 27, 2023, 9:25am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/15 "2023-11-27T09:25:32Z")
Then please teach me how to do that. Please send a screenshot of the blocks or anything you are talking about ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [November 27, 2023, 9:28am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/16 "2023-11-27T09:28:09Z")
Which one , save in variable or save the text inside E. ? I’m not at pc now , show the block you are using now ---
**Author:** ![myaccount](https://avatars.discourse-cdn.com/v4/letter/m/a6a055/32.png) [@myaccount](https://community.thunkable.com/u/myaccount)\ **Post date:** [November 27, 2023, 9:29am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/17 "2023-11-27T09:29:23Z")
Can you please explain it further, I am new to building apps. ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [November 27, 2023, 9:34am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/18 "2023-11-27T09:34:10Z")
Yes but first thing you have to explain as clear as you can yours goal . There are also a lot of tutorials for basic procedures and components, like docs and on you tube [docs](https://docs.thunkable.com/) ---
**Author:** ![myaccount](https://avatars.discourse-cdn.com/v4/letter/m/a6a055/32.png) [@myaccount](https://community.thunkable.com/u/myaccount)\ **Post date:** [November 27, 2023, 9:36am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/19 "2023-11-27T09:36:00Z")
My goal is, If user clicks any item from data viewer list that item should show in Vehicle problem as text and not row id. ---
**Author:** ![Goldking](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/goldking/32/165073_2.png) [@Goldking](https://community.thunkable.com/u/Goldking)\ **Post date:** [November 27, 2023, 9:52am UTC](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098/20 "2023-11-27T09:52:58Z")
![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/7/97622f9fdfc778860ac4a0993fefa3473034edfc.png) This block after click retrieves data from sheet, go in **foglio1** (the sheet you are using) in column **note** and pick up the value with the clicked row ID ( the position inside the column) The value is saved inside a label as text Click and change the values with your goal [Next page](https://community.thunkable.com/t/solved-how-to-convert-row-id-to-text/2723098.md?page=2)