# Get row objects from block doesn't work

**URL:** <https://community.thunkable.com/t/get-row-objects-from-block-doesnt-work/1311850>\
**Category:** Questions about Thunkable X\
**Created:** [May 27, 2021, 8:30pm UTC](https://community.thunkable.com/t/get-row-objects-from-block-doesnt-work/1311850 "2021-05-27T20:30:09Z")\
**Posts on this page:** 13\
**Page:** 1

<div class="post-metadata">

**Author:** ![skulamester](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/skulamester/32/100480_2.png) [@skulamester](https://community.thunkable.com/u/skulamester)\
**Post date:** [May 27, 2021, 8:30pm UTC](https://community.thunkable.com/t/get-row-objects-from-block-doesnt-work/1311850/1 "2021-05-27T20:30:09Z")

</div>

Hi,

I have the following block, but it does nothing, the Alert doesn’t shows up and if I have blocks after the Get row objects block, they run neither.

It is like it the get row object from block stops the whole code.

Any idea?

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/3/4/34889e885f0fa7bfbeb55a2c4c39595e243b2e34.png)  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/4/e4cd3060c0a8d897621ef233fbf0eebef9a64f17.png)

---

<div class="post-metadata">

**Author:** ![skulamester](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/skulamester/32/100480_2.png) [@skulamester](https://community.thunkable.com/u/skulamester)\
**Post date:** [May 27, 2021, 8:36pm UTC](https://community.thunkable.com/t/get-row-objects-from-block-doesnt-work/1311850/2 "2021-05-27T20:36:56Z")

</div>

Here is the test project: [Thunkable](https://x.thunkable.com/copy/0a984dd348a2efaccf663a227ba2f172)

---

<div class="post-metadata">

**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:** [May 27, 2021, 9:38pm UTC](https://community.thunkable.com/t/get-row-objects-from-block-doesnt-work/1311850/3 "2021-05-27T21:38:29Z")

</div>

You’re assigning a row object to an alert block that takes text as an input. That sort of type mismatch is generally going to cause a crash.

What text are you wanting the alert title to show?

---

<div class="post-metadata">

**Author:** ![skulamester](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/skulamester/32/100480_2.png) [@skulamester](https://community.thunkable.com/u/skulamester)\
**Post date:** [May 28, 2021, 4:45am UTC](https://community.thunkable.com/t/get-row-objects-from-block-doesnt-work/1311850/4 "2021-05-28T04:45:03Z")

</div>

I want to work with a list of the elements in a row, but I am unable to get them, as it crashes. I have tried other ways as well, but the app still crashes (freezes), it needs to have an hard reset after this block.

I have tried this ways to display already, but haven’t succeed:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/6/6680a68d488fcdb5f1f1db16412b88f391d3deeb.png)  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/a/fa54723502e2ec40578e558c35c74976ba8fa0c2.png)

---

<div class="post-metadata">

**Author:** ![skulamester](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/skulamester/32/100480_2.png) [@skulamester](https://community.thunkable.com/u/skulamester)\
**Post date:** [May 28, 2021, 4:56am UTC](https://community.thunkable.com/t/get-row-objects-from-block-doesnt-work/1311850/5 "2021-05-28T04:56:32Z")

</div>

Update: I have a Google Sheet assigned to my project as well, and the blocks work that way:

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/8/b/8b59ae8ff1de6d9b4fa34bd48147f64be9296eb5.png)  
 ![IMG_37F0B0A8D59A-1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/1/91f9eeda70f18ff5540ea6fc5d11ef5e7c84a7a0.jpeg)

I think there might be a problem with my data source. But why?

---

<div class="post-metadata">

**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:** [May 28, 2021, 5:06am UTC](https://community.thunkable.com/t/get-row-objects-from-block-doesnt-work/1311850/6 "2021-05-28T05:06:58Z")

</div>

The problem is that the “get row object” block returns an object. An object is a collection of values, not a single value.

You can’t assign an object to a text block such as “Alert\_Error’s Title”. It’s a little like you saying to me “What’s your name?” and I respond “here are 5 dictionary pages”.

Anyway, analogies aside, if you want the row data then you have to parse it using “get property of object” blocks. I don’t have a lot of experience parsing row objects but I believe there are tutorials and videos available on that subject.

Typically, you’d just use the “get value” blocks to get row data, as explained in this video:

[![](https://img.youtube.com/vi/Y0IBTTYQY2Y/maxresdefault.jpg "Display the data from a single spreadsheet row (Thunkable)") ](https://www.youtube.com/watch?v=Y0IBTTYQY2Y)

But if you can explain what type of data you want to get from the row, I can help you further. What I’m asking is… what would you expect the Alert Title to display if this all worked correctly? What is the actual text it would show?

---

<div class="post-metadata">

**Author:** ![skulamester](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/skulamester/32/100480_2.png) [@skulamester](https://community.thunkable.com/u/skulamester)\
**Post date:** [May 28, 2021, 5:22am UTC](https://community.thunkable.com/t/get-row-objects-from-block-doesnt-work/1311850/7 "2021-05-28T05:22:35Z")

</div>

Hi there,

I have experience with the blocks of the Object section and I can work with them.

The problem is that I don’t get the objects of the row, as the screen freezes. The alert shows up neither.

This problem only comes up with my Data Source:

> [@skulamester](#):
>
> ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/4/e4cd3060c0a8d897621ef233fbf0eebef9a64f17.png)

But if I am using Google Sheets or another Data Source, I get the response I have been waited for:

> [@skulamester](#):
>
> ![IMG_37F0B0A8D59A-1](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/1/91f9eeda70f18ff5540ea6fc5d11ef5e7c84a7a0.jpeg)

Well, I think because of that there is a problem with my data source but I don’t know why. (I deleted the smileys and the app freezes that way as well)

---

<div class="post-metadata">

**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:** [May 28, 2021, 6:17am UTC](https://community.thunkable.com/t/get-row-objects-from-block-doesnt-work/1311850/8 "2021-05-28T06:17:04Z")

</div>

Okay well you don’t seem to understand what I mean by type mismatch and “object” data types. Sorry I can’t explain it better right now. And you still haven’t said what the intended display would look like so I can’t help you get there either.

Maybe someone else will have some ideas…

---

<div class="post-metadata">

**Author:** ![skulamester](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/skulamester/32/100480_2.png) [@skulamester](https://community.thunkable.com/u/skulamester)\
**Post date:** [May 28, 2021, 7:27am UTC](https://community.thunkable.com/t/get-row-objects-from-block-doesnt-work/1311850/9 "2021-05-28T07:27:38Z")

</div>

Thank you for your help @tatiang,

I want to get a list of the items in the first row.

Thanks!

---

<div class="post-metadata">

**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:** [May 28, 2021, 7:43am UTC](https://community.thunkable.com/t/get-row-objects-from-block-doesnt-work/1311850/10 "2021-05-28T07:43:20Z")

</div>

Okay. The Alert Title can only be a text string, not a list. So while you can get a list of values in the first row and then pick a single value, you can’t just make the Alert Title display a list.

The exception to what I just said is that you can use the “make text from list” block in the List drawer to convert from list to text.

But you said you’re familiar with working with objects so I would suggest that you first pull out **one** property from the row object (e.g. “Name”) and see if you can get that to work as an Alert Title. If you can, post an update and we can go from there.

---

<div class="post-metadata">

**Author:** ![skulamester](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/skulamester/32/100480_2.png) [@skulamester](https://community.thunkable.com/u/skulamester)\
**Post date:** [May 28, 2021, 1:05pm UTC](https://community.thunkable.com/t/get-row-objects-from-block-doesnt-work/1311850/11 "2021-05-28T13:05:34Z")

</div>

I deleted my Data Source and created a new one instead of the old one and now, it does work as expected. This time I inserted the data manually. (I didn’t use Command+V)

Thank you for your help @tatiang !

---

<div class="post-metadata">

**Author:** ![catsarisky](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/catsarisky/32/100661_2.png) [@catsarisky](https://community.thunkable.com/u/catsarisky)\
**Post date:** [May 28, 2021, 7:49pm UTC](https://community.thunkable.com/t/get-row-objects-from-block-doesnt-work/1311850/12 "2021-05-28T19:49:00Z")

</div>

Glad you were able to fix it. I’ve had good success with ctrl-V, but I wonder if special characters bugged it!

---

<div class="post-metadata">

**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:22pm UTC](https://community.thunkable.com/t/get-row-objects-from-block-doesnt-work/1311850/13 "2024-11-08T13:22:12Z")

</div>


