Data Sources: List Of Values from [Column] block does not update during app runtime

@jane

thank you for step in. i am using data source to pull data from airtable. the block working fine but after updated it reflected at airtable but not in screen it self. If i am using web it can be right click and reload the page but if using the app how do that? i share how the block look like. thank to @muneer who help me with block arrangement.

image

reflected

not reflected
image

1 Like

I can see your update value block to update the value in your Airtable DB, but it looks like you don’t update the List Viewer’s text items after changing a value in your Airtable DB. The List Viewer won’t update automatically, you’ll need to add a block to display the new data yourself.

Can you add in a block after your update value in Imported Base block to set List_Viewer's text items to [list of values in Imported Base in bank in number]? This should pull the new data and display it in your List Viewer.

1 Like

@jane

same behavior it only updated at airtable not at listviewer.

1 Like

Those purple blocks are asynchronous. The first one may not be done before the second runs. Try adding a 1s wait before you update list viewer. If that fixes the problem, then you’ll know it’s a timing issue only.

1 Like

@jane
The update value block is simply to update the value in the table and it does what it supposed to do but what is not performing as expected is the item click event of List Viewer1 which should update the content of the lower list viewer (List Viewer2).
image
I have tested it and injected wait blocks in different places but that does not seem to have any effect.

@muneer/
also i try on local db and worked perfectly but at airtable does not seem reflected at app unless app is close and open again.

@jane
is there anyway to refresh the screen?

2 Likes

i recreating the block using airtable block, it able to save and reflected at airtable and at screen.

here the block.

image

image

image

2 Likes

@jane does this mean there is a cache problem with the block list of values? The block will read from the Data Source only the first time and subsequent calls will reflect the cached values.

3 Likes

Thanks for the tag, @muneer - I made a sample app to test this out and it seems correct. I’ll bring this matter to the team’s attention.

1 Like

Thanks for confirming, @ozel1978. If you use a Google Sheet as a data source, do you get the updated data?

1 Like

@jane no it wont updated. so meaning airtable and spreadsheet wont be effected using data source block. while for airtable working fine if using airtable block itself.

1 Like

Ok, so just to be clear:

  • The list of values from [column] block will not update if you are connected to an Airtable DB or Google Sheet
  • The list of values from [column] block will update if you are connected to a Local DB

Is that correct?

3 Likes

Yes, I confirm that.

1 Like

yes jane.

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!

3 Likes

Thanks @Jane . Can you share the fix @janhavi has written? I’m still having this issue of Google Sheets data not updating without restarting the app. I’ve used the block Data Viewer Grid - Refresh Data, then relink the field and even reload the screen. No luck.

Hello @khawschurch and welcome to the community. How are you testing your app? Are you using web, live, or native apps? This has been an ongoing topic for a few days, but the Thunkable team has fixed it as far as I can tell.

1 Like

I tried it in the browser, also clicked on open in different window, and used the Live app. Same result. It’s possible I don’t have all the needed blocks in place. I’ve tried several configurations of blocks. I simply use a Google Sheet with a hidden data viewer grid, and use labels to display specific cells of the Sheet. I was trying to use a button to refresh the data in the labels as the Sheet changed (changing the Sheet data not thru the app but thru a laptop. Just wanted to have an update button without having to restart the app).
Thank you!

1 Like

I think this is a known bug. @muneer can you confirm?

1 Like

Yes, the list of values block is an ON/OFF issue and @jane confirmed twice that the issue is solved but it comes up again in different ways.