Is it possible to update a local data source table dynamically based on a web api response or by by downloading data from a google sheet ,

ok , that’s a great solution . but when I tried it didn’t work, and here is the blocks, I’ve tried 2 strategies but none of them works , So there is a missing thing here, and here is the api url and it works fine https://script.google.com/macros/s/AKfycbwhsM1QA6Z9sYuAewzzBtR9tIMWLeKGl_949OD804TCB…

Hi, I came up with this so far https://x.thunkable.com/projects/650d9b530196d37537ea9c77/f0ee3329-ddd4-4e84-9c4c-92b4374e1dc1/blocks which extracts a specific row from the JSON response. I just dropped the responses in labels for testing purposes. You can have a look here for an explanation of …

The problem is that the list you want is inside of the “data” property but you’re not referencing that with your blocks. You’re attempting to get the list from the object but you need to get the list from the “data” property of the object. You can see that in this screenshot from Best JSON Viewer an…

Hi @tatiang , Thanks for the response and I had watched the video before. The blocks that I have to extract the data into the labels work fine; it is getting the count from the data list that is my problem. But following the logic, if I get the properties “Full Name”, etc. from the data list, then…

[image] tatiang: Best JSON Viewer and JSON Beautifier Online You’re on the right track but you made a mistake by adding a [gear] list block. The value of the get property block is already a list so when you add that [gear] list block in front of it, you create a list of lists. That’s going to…

I tried this one but still is not working [Screenshot 2023-09-23 103157]

It was great to receive your help, and it would be better to make the blocks running inside the create new row block ، especially as it was working fine to extract the data from api in the above example, I’m really appreciating your help

That’s because of the for loop. The variable Response is non-numeric so that loop cannot run. This is why I am trying to get the length of the list to set to a variable that you can then use to run the for loop.

@tatiang Beautiful! Thanks, that worked. @minamaestro2023kg and @drmina2007er0sjg see blocks below. I tried the “for each” block but that didn’t work, so I get the size of the list and then use a “count with” block. So to push these into a local data source, instead of showing the value in a la…

Your solution steve works like magic in populating labels, for create row in data source, is not working . So I think there is a problem in the create new row in data block. here is screenshot [Screenshot 2023-09-24 152230] And here is the project itself so maybe you can tinker about it https:…

Populate local datasource table dynamically

Questions about Thunkable X

minamaestro2023kg September 23, 2023, 7:38am 9

I tried this one but still is not working

Topic		Replies	Views
Help needed with a Local Table Data Source problem Questions about Thunkable X	20	828	December 30, 2023
Local data source behaves weirdly Questions about Thunkable X	3	106	November 8, 2024
[Solved] Not updating data in stored data source local table Questions about Thunkable X	13	833	October 12, 2023
From today rowID not work in "Create a local data source" Questions about Thunkable X data-viewer	102	3510	November 8, 2024
Refresh Google Sheet Data Source while the app is open Questions about Thunkable X	12	1469	November 8, 2024

Populate local datasource table dynamically

Related topics