# How to "get" one intire row from the data Source **URL:** \ **Category:** Issues / Bugs\ **Created:** [August 15, 2023, 11:02am UTC](https://community.thunkable.com/t/how-to-get-one-intire-row-from-the-data-source/2545544 "2023-08-15T11:02:29Z")\ **Posts on this page:** 7\ **Page:** 1
**Author:** ![stefansladdeneng1](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/stefansladdeneng1/32/170123_2.png) [@stefansladdeneng1](https://community.thunkable.com/u/stefansladdeneng1)\ **Post date:** [August 15, 2023, 11:02am UTC](https://community.thunkable.com/t/how-to-get-one-intire-row-from-the-data-source/2545544/1 "2023-08-15T11:02:29Z")
How to “get” one intire row from the Data Source using my own created table in the design tab? Tried it already and i can only get one specific column… WHY is there no “Get intire row ID” as a prebuilt block…? ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [August 15, 2023, 5:48pm UTC](https://community.thunkable.com/t/how-to-get-one-intire-row-from-the-data-source/2545544/2 "2023-08-15T17:48:41Z")
You can use the Get Row Object block with an integer for the row id. ![2565785E-BB7D-475F-96F0-E43E40ABC3E2](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/3/a3c00985a082687ea5baa1dbb5f15988353b6c46.png) ---
**Author:** ![stefansladdeneng1](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/stefansladdeneng1/32/170123_2.png) [@stefansladdeneng1](https://community.thunkable.com/u/stefansladdeneng1)\ **Post date:** [August 16, 2023, 5:21am UTC](https://community.thunkable.com/t/how-to-get-one-intire-row-from-the-data-source/2545544/3 "2023-08-16T05:21:24Z")
Hmmm - Following your example i get only (object Oject) in a label, picking up row 1 for row id i took “1” for the first row ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/9/898312a8d62f15d95850f6a479d0128672b40f8a.png) Below you also see an example of the sama data using Data Viewer list instead (seng 123) I am missing columns and it seem impossible to connect all columns to the Data viewers list I just want to show the data for each row asked for available in a list or label Conceptually i take for granted that this should be possible… Can u guide perhaps ? ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [August 16, 2023, 5:53am UTC](https://community.thunkable.com/t/how-to-get-one-intire-row-from-the-data-source/2545544/4 "2023-08-16T05:53:21Z")
Sorry, a row object is not a typical variable that you might be used to like a text string or list. It contains property value pairs so you have to use the “get property of” block to access each value. So for example, if your data source has a column called “Colors” then to access the value of the cell in that column for the row object, you would get the property “Colors” of the object (where the object is the row object you got with the “get row object” block). Confusing, I know, so I recommend… This is discussed in the tutorial video in the “Read” section of the Data Sources documentation: [Data Sources - Thunkable Docs](https://docs.thunkable.com/getting-started/data-sources#read) ---
**Author:** ![stefansladdeneng1](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/stefansladdeneng1/32/170123_2.png) [@stefansladdeneng1](https://community.thunkable.com/u/stefansladdeneng1)\ **Post date:** [August 16, 2023, 4:46pm UTC](https://community.thunkable.com/t/how-to-get-one-intire-row-from-the-data-source/2545544/5 "2023-08-16T16:46:38Z")
Excellent - Clear now - Thanks Just another related topic. Really simple and foolish question ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/7/67aefa583d9d4b9f9a8aeb39bca323a845a3654d.png) This block - Obviously should change background color to green when Piano button is clicked and if it is currectly gray (Which it is as default) i Assumed that when clicking and the BGC is Gray then it should chang to green. But it does not…until i click another time…Whats Wrong? Any idea…?? ---
**Author:** ![tatiang](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/tatiang/32/55482_2.png) [@tatiang](https://community.thunkable.com/u/tatiang)\ **Post date:** [August 16, 2023, 9:38pm UTC](https://community.thunkable.com/t/how-to-get-one-intire-row-from-the-data-source/2545544/6 "2023-08-16T21:38:09Z")
I suspect that the default value for a button’s color is not equal to the gray color block you used in the **if** condition. Try assigning a label or text input’s text to the `Piano’s Background Color` block. I bet you’ll see something like “RGBA(128,128,128,1).” ---
**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:33pm UTC](https://community.thunkable.com/t/how-to-get-one-intire-row-from-the-data-source/2545544/7 "2024-11-08T13:33:36Z")