# Having problem with Google spreadsheet

**URL:** <https://community.thunkable.com/t/having-problem-with-google-spreadsheet/2914747>\
**Category:** Questions about Thunkable X\
**Created:** [March 26, 2024, 6:55am UTC](https://community.thunkable.com/t/having-problem-with-google-spreadsheet/2914747 "2024-03-26T06:55:07Z")\
**Posts on this page:** 7\
**Page:** 1

<div class="post-metadata">

**Author:** ![itsaqibdev228](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/itsaqibdev228/32/174512_2.png) [@itsaqibdev228](https://community.thunkable.com/u/itsaqibdev228)\
**Post date:** [March 26, 2024, 6:55am UTC](https://community.thunkable.com/t/having-problem-with-google-spreadsheet/2914747/1 "2024-03-26T06:55:07Z")

</div>

I am having trouble in shown One of my column from Google spreadsheet.  
as you can see in the screenshot there are 50 rows but in Upcoming Column there are some empty ones that cause my thunkable to not get that column data in label all other datas are coming and working but in this column case there is no single row data is coming to the label

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/4/7/4704398d3cb9992cca170a9e508e0a1aa5dcf9e6.png)

---

<div class="post-metadata">

**Author:** ![maurizio.polverini89](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/maurizio.polverini89/32/145191_2.png) [@maurizio.polverini89](https://community.thunkable.com/u/maurizio.polverini89)\
**Post date:** [March 26, 2024, 7:15am UTC](https://community.thunkable.com/t/having-problem-with-google-spreadsheet/2914747/2 "2024-03-26T07:15:05Z")

</div>

Hello!

May you please share your blocks? I’m sure it will help to better understand the issue

---

<div class="post-metadata">

**Author:** ![itsaqibdev228](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/itsaqibdev228/32/174512_2.png) [@itsaqibdev228](https://community.thunkable.com/u/itsaqibdev228)\
**Post date:** [March 26, 2024, 7:34am UTC](https://community.thunkable.com/t/having-problem-with-google-spreadsheet/2914747/3 "2024-03-26T07:34:52Z")

</div>

I have tried two ways to access the data one by this way  
 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/6/66681c01194407238364bed249a1ed56a3630e81.png)  
Second way is i just want that column give atleast something by these two ways as i have to compare lately to achieve my goal.

 ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/e/6/e6979708ae224453891c29d7f747ec3b0c7ab292.png)

**Both two ways return nothing like no change in the label**

---

<div class="post-metadata">

**Author:** ![maurizio.polverini89](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/maurizio.polverini89/32/145191_2.png) [@maurizio.polverini89](https://community.thunkable.com/u/maurizio.polverini89)\
**Post date:** [March 26, 2024, 9:42am UTC](https://community.thunkable.com/t/having-problem-with-google-spreadsheet/2914747/4 "2024-03-26T09:42:29Z")

</div>

First thing that pops up in my mind is that i rarely used a text to display a list of values.  
Maybe you want to try with a Simple List component?  
Just set the Simple List text items to the list of values and it’ll give you a better idea.

As second thing, i think since “list of values” is a list, you can’t use the “lenght of text” component.  
Try using the “lenght of” from the “List component” (the skyblu color).

Let me know if it works

---

<div class="post-metadata">

**Author:** ![itsaqibdev228](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/itsaqibdev228/32/174512_2.png) [@itsaqibdev228](https://community.thunkable.com/u/itsaqibdev228)\
**Post date:** [March 26, 2024, 9:54am UTC](https://community.thunkable.com/t/having-problem-with-google-spreadsheet/2914747/5 "2024-03-26T09:54:34Z")

</div>

But this is giving me values for other columns but not for this i have seen the cause was keep the some rows empty in that column

---

<div class="post-metadata">

**Author:** ![maurizio.polverini89](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/maurizio.polverini89/32/145191_2.png) [@maurizio.polverini89](https://community.thunkable.com/u/maurizio.polverini89)\
**Post date:** [March 27, 2024, 7:51am UTC](https://community.thunkable.com/t/having-problem-with-google-spreadsheet/2914747/6 "2024-03-27T07:51:56Z")

</div>

I apologize then, i think i misunderstood your message.

I still have troubles to understand what your problem is, have you tried to fill the empty column with “-” or just “Not available” instead of a blank space, if that’s your issue?  
Worth a try

If you have chance please explain better your problem, at least for me as english is not my native language.

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/f/0f59f292712368bce16ff80133ae10de8a6f27e8.png) [@system](https://community.thunkable.com/u/system)\
**Post date:** [June 25, 2024, 7:52am UTC](https://community.thunkable.com/t/having-problem-with-google-spreadsheet/2914747/7 "2024-06-25T07:52:02Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.
