# Some data source blocks not working
**URL:** https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604
**Category:** Questions about Thunkable X
**Tags:** design, beginner
**Created:** [May 13, 2021, 8:51pm UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604 "2021-05-13T20:51:04Z")
**Posts on this page:** 20
**Page:** 1
### Author:  [@bnice](https://community.thunkable.com/u/bnice)
#### Post date: [May 13, 2021, 8:51pm UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/1 "2021-05-13T20:51:04Z")
Hello,
I am having some trouble with my app and I am hoping someone has a solution. I am currently importing some Google Sheets data into my app but not all of the Data Source blocks seem to be working. If I specify an index on a given sheet, everything works fine and it polls the needed value. However, when I use the “List of Values” block in the data sources tab, it doesn’t retrieve anything from my Google Sheets. The “number of rows” block doesn’t work either. To troubleshoot, I also tried it with a local table and that didn’t work either. Does anyone have any ideas? Any insight would be much appreciated.
-Byron
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [May 13, 2021, 9:08pm UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/2 "2021-05-13T21:08:35Z")
This is a known issue. It was posted about earlier today. I’ll see if I can find the post.
**Edit:**
> [@Data Sources: List Of Values from \[Column\] block does not update during app runtime](https://community.thunkable.com/t/data-sources-list-of-values-from-column-block-does-not-update-during-app-runtime/1257205/22):
>
> Hey @muneer @ozel1978, Thunkable team member Janhavi has written a fix for this behavior. It should go live next week. Thanks to you both for providing info on this behavior!
---
### Author:  [@bnice](https://community.thunkable.com/u/bnice)
#### Post date: [May 13, 2021, 9:27pm UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/3 "2021-05-13T21:27:50Z")
Thanks for the update! Sorry for the repost, but I was looking for 10 mins and my keywords were not pulling anything up.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [May 13, 2021, 9:45pm UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/4 "2021-05-13T21:45:29Z")
The actual issue is that you can get the list but not the updates made by the app.
If you are saying that you are not getting any values then it could be something else wrong with your code.
---
### Author:  [@bnice](https://community.thunkable.com/u/bnice)
#### Post date: [May 13, 2021, 10:11pm UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/5 "2021-05-13T22:11:53Z")
I was able to do a bit more testing and I was able to get the Local table data, but it still was not working with Google Sheets. For some reason, the local table is not working on my live preview phone app, but it is on the live web preview.
---
### Author:  [@tatiang](https://community.thunkable.com/u/tatiang)
#### Post date: [May 13, 2021, 10:30pm UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/6 "2021-05-13T22:30:20Z")
Can you post a screenshot of the blocks you’re using?
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [May 13, 2021, 10:58pm UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/7 "2021-05-13T22:58:54Z")
If you are certain that your local table works and the same blocks fail to get data from Google sheet then it would worth verifying your connection to the sheet.
Go to My Data Sources tab from the main screen and view the sheet and see if it displays data. This is how you test your connection as part of your debugging procedure.
---
### Author:  [@bnice](https://community.thunkable.com/u/bnice)
#### Post date: [May 13, 2021, 11:21pm UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/8 "2021-05-13T23:21:00Z")
My sheet does display the data. I have been checking that view within the app editor as well. I am getting some messy things on my end, so I will send some screenshots. I am also getting different results depending on if I am using the web version or the live app on my iPhone.
Here is a set where it is working using one sheet. (Web, code, iPhone)
---
### Author:  [@bnice](https://community.thunkable.com/u/bnice)
#### Post date: [May 13, 2021, 11:21pm UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/9 "2021-05-13T23:21:51Z")
Sorry for the second message, I got an error that said I could only upload three screenshots as a new user.
But then it doesn’t work here using a different sheet: (Web, code, iPhone)
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [May 14, 2021, 1:43am UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/10 "2021-05-14T01:43:48Z")
I can see that the [list of values …] works for the Google sheet in your first scenario and did not work for the other sheet which means there is a sort of issue in the other sheet such as
- the sheet does not have column names in row 1
- the sheet has no values
- the first row after column names is empty
- not synchronised
The other issue is the typical use for [list of values…] is to bind it with a list viewer to see it as a list. You are assigning it to a label therefore it is displayed as comma delimited values.
[Suggestion]
Instead of the block is associated with the screen open event, I suggest to add a button and copy the [list of values…] to the click event so you can try retrieving data after the screen opens and if there is a connection timing issue you would see if working when you click the button and you can try it more than once.
Also if you add [List Viewer] instead of displaying the list in a label.
---
### Author:  [@bnice](https://community.thunkable.com/u/bnice)
#### Post date: [May 14, 2021, 4:40pm UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/11 "2021-05-14T16:40:35Z")
Thanks for the suggestion. Sorry for the confusion, but my actual app doesn’t use the labels I showed above. This was for troubleshooting. The code in my app is still in development, so there are some other things holding it back. In this case, I made a separate screen to make sure everything with Google Sheets was syncing/pulling/working, and as I showed, things are not. In my actual code, I am wanting to set the [List of values…] to a list, so I can search the list later. Here are some screenshots of my sheets to show you what I have.
Working sheet
Non-workign sheet
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [May 14, 2021, 9:49pm UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/12 "2021-05-14T21:49:49Z")
Hi @bnice
Can I ask you to try something sounds silly? Change the sheet name “N22” to something longer such as “N22N22”.
I believe I found a bug related to number of characters in the sheet name affecting both [List of values…] and [number of rows] blocks.
Just want you to try and confirm my findings
CC:
@tatiang
@domhnallohanlon
@jane
---
### Author:  [@bnice](https://community.thunkable.com/u/bnice)
#### Post date: [May 14, 2021, 11:54pm UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/13 "2021-05-14T23:54:08Z")
@muneer I think that worked. I was able to get the list that I was looking for. There was one other variable that was having some issues that might have also fixed something? (I may have just been impatient and was thinking it would be faster), but the data source was not syncing with the sheet name change. I readded the source and the changes were there. I have a feeling I just wasn’t waiting long enough because I have not had any syncing problems with this app.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [May 15, 2021, 5:36am UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/14 "2021-05-15T05:36:37Z")
Thank you for your confirmation. The synching issue is not something that happens automatically. When you change the sheet name or add/remove columns in you sheet you need to go to “My Data Sources” tab in the main Thunkable screen and look for your Google sheet connection and \*\*resynch" again to get the changes.
---
### Author:  [@jane](https://community.thunkable.com/u/jane)
#### Post date: [May 17, 2021, 8:05am UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/15 "2021-05-17T08:05:32Z")
Hey Muneer,
Do you think that a Data Source needs a minimum number of characters in its title to work in Thunkable?
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [May 17, 2021, 11:45am UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/16 "2021-05-17T11:45:46Z")
My opinion is:
When you have a sheet name such as T1, T2, T3 and connect then to a Thunkable project, you will see that the data viewers work and the blocks to get/set cells work but **list of values** and **number of rows** don’t work.
The reason these two don’t work is the **sheet name** less than **4** characters which is OK but if this is a requirement then it should be **uniform** across all **Data Sources** blocks. Having it as a requirement/restriction for two blocks while others are ok brings confusion.
That’s all.
---
### Author:  [@jane](https://community.thunkable.com/u/jane)
#### Post date: [May 18, 2021, 7:02am UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/17 "2021-05-18T07:02:42Z")
Thanks for the insight - I’ll see if I can reproduce this behavior and file a report.
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [May 18, 2021, 8:14am UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/18 "2021-05-18T08:14:07Z")
Very easy to reproduce the situation @jane
Create a Google sheet with one or more sheets/tabs and give these tabs title less than 4 characters.
You will see that you can view the tab content in the data viewer but you will get an empty list if you use [list of values…] block.
---
### Author:  [@domhnallohanlon](https://community.thunkable.com/u/domhnallohanlon)
#### Post date: [May 18, 2021, 3:06pm UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/19 "2021-05-18T15:06:55Z")
Hi @muneer,
I created a sheet named `pi` and tried both these blocks and wasn’t able to reproduce this behaviour.
I tested on Thunkable Live on Android, iOS and web preview but they all worked fine for me
---
### Author:  [@muneer](https://community.thunkable.com/u/muneer)
#### Post date: [May 18, 2021, 3:45pm UTC](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604/20 "2021-05-18T15:45:44Z")
This is what I did
A screen with
- 2 list viewers
- 2 labels
- 2 data viewers
I created a test sheet with two tabs (tables) P1 and P2
I connected the Google sheet and bound the 2 tables to the two data viewers.
In the screen Opens event I put the following
with this the list viewers should show the same result as the data viewers and the two labels with show the numbers of rows.
Check this and let me know the outcome.
Sorry, I forgot to add the outcome on my side.
[Next page](https://community.thunkable.com/t/some-data-source-blocks-not-working/1281604.md?page=2)