# Populate local datasource table dynamically

**URL:** <https://community.thunkable.com/t/populate-local-datasource-table-dynamically/2605749>\
**Category:** Questions about Thunkable X\
**Created:** [September 20, 2023, 8:22pm UTC](https://community.thunkable.com/t/populate-local-datasource-table-dynamically/2605749 "2023-09-20T20:22:43Z")\
**Posts on this page:** 12\
**Page:** 2

<div class="post-metadata">

**Author:** ![minamaestro2023kg](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@minamaestro2023kg](https://community.thunkable.com/u/minamaestro2023kg)\
**Post date:** [September 26, 2023, 5:56am UTC](https://community.thunkable.com/t/populate-local-datasource-table-dynamically/2605749/22 "2023-09-26T05:56:25Z")

</div>

@tatiang in such a case I would try the delete row block before getting a new API response so the old and new responses don’t get blended together, As I’d like to make the app as dynamic as possible, or are there a better choice?

---

<div class="post-metadata">

**Author:** ![steve\_synopsis](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)\
**Post date:** [September 26, 2023, 10:23am UTC](https://community.thunkable.com/t/populate-local-datasource-table-dynamically/2605749/23 "2023-09-26T10:23:19Z")

</div>

Have you given thought to using a Google sheet?

That changes dynamically as data is added/deleted and you can see it in real-time.

---

<div class="post-metadata">

**Author:** ![drmina2007er0sjg](https://avatars.discourse-cdn.com/v4/letter/d/5daacb/32.png) [@drmina2007er0sjg](https://community.thunkable.com/u/drmina2007er0sjg)\
**Post date:** [September 26, 2023, 11:06am UTC](https://community.thunkable.com/t/populate-local-datasource-table-dynamically/2605749/24 "2023-09-26T11:06:04Z")

</div>

The point, that I’d like to make it as dynamic and personalized as possible, using a google sheet could make conflicts between different users as a single Google sheet is gonna be shared between them, but for local data source the customer experience will be personalized For each user.

---

<div class="post-metadata">

**Author:** ![steve\_synopsis](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)\
**Post date:** [September 26, 2023, 11:25am UTC](https://community.thunkable.com/t/populate-local-datasource-table-dynamically/2605749/25 "2023-09-26T11:25:34Z")

</div>

Not too sure that I understand. The Google sheet does basically the same thing as the local datasource - allows you to CRUD data via the Thunkable app. I suggested the Google sheet as you indicated that weren’t seeing the updated data in the local datasource.

The Google sheet would serve as the datasource to the app and only be used by the admin to inspect data; your users would not have access to it. It is also easier to populate in the first instance as you can import from a CSV.

---

<div class="post-metadata">

**Author:** ![drmina2007er0sjg](https://avatars.discourse-cdn.com/v4/letter/d/5daacb/32.png) [@drmina2007er0sjg](https://community.thunkable.com/u/drmina2007er0sjg)\
**Post date:** [September 26, 2023, 1:11pm UTC](https://community.thunkable.com/t/populate-local-datasource-table-dynamically/2605749/26 "2023-09-26T13:11:53Z")

</div>

@steve_synopsis in the proposed apps different users would populate different sets of data upon an api response, and using a single Google sheet populated by different users would cause a conflict.

---

<div class="post-metadata">

**Author:** ![steve\_synopsis](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)\
**Post date:** [September 26, 2023, 1:34pm UTC](https://community.thunkable.com/t/populate-local-datasource-table-dynamically/2605749/27 "2023-09-26T13:34:44Z")

</div>

@drmina2007er0sjg So how are you going to handle it with the local datasource?

---

<div class="post-metadata">

**Author:** ![drmina2007er0sjg](https://avatars.discourse-cdn.com/v4/letter/d/5daacb/32.png) [@drmina2007er0sjg](https://community.thunkable.com/u/drmina2007er0sjg)\
**Post date:** [September 26, 2023, 3:15pm UTC](https://community.thunkable.com/t/populate-local-datasource-table-dynamically/2605749/28 "2023-09-26T15:15:49Z")

</div>

Sorry, I’m not sure what do you mean?

---

<div class="post-metadata">

**Author:** ![minamaestro2023kg](https://avatars.discourse-cdn.com/v4/letter/m/e19b73/32.png) [@minamaestro2023kg](https://community.thunkable.com/u/minamaestro2023kg)\
**Post date:** [September 27, 2023, 6:27am UTC](https://community.thunkable.com/t/populate-local-datasource-table-dynamically/2605749/29 "2023-09-27T06:27:36Z")

</div>

@tatiang there is a point I would like to understand, a local data source will be a part of the future device memory on which the proposed app will be installed, is that correct ?

---

<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:** [September 27, 2023, 6:30am UTC](https://community.thunkable.com/t/populate-local-datasource-table-dynamically/2605749/30 "2023-09-27T06:30:53Z")

</div>

> [@minamaestro2023kg](#):
>
> a local data source will be a part of the future device memory on which the proposed app will be installed, is that correct ?

Yes.

---

<div class="post-metadata">

**Author:** ![steve\_synopsis](https://avatars.discourse-cdn.com/v4/letter/s/48db29/32.png) [@steve\_synopsis](https://community.thunkable.com/u/steve_synopsis)\
**Post date:** [September 27, 2023, 6:29pm UTC](https://community.thunkable.com/t/populate-local-datasource-table-dynamically/2605749/31 "2023-09-27T18:29:28Z")

</div>

Hi,

I was having a look back at the blocks and have realised that the generate JSON from object blocks are not needed. I tried it without then and it works fine and it makes sense as you do not need to be created JSON again from the object property value.

 ![2023-09-27 14 24 40](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/6/f6dd2f6c7fe2e5f05ace9bcff2235821d902f000.png)

---

<div class="post-metadata">

**Author:** ![drmina2007er0sjg](https://avatars.discourse-cdn.com/v4/letter/d/5daacb/32.png) [@drmina2007er0sjg](https://community.thunkable.com/u/drmina2007er0sjg)\
**Post date:** [September 27, 2023, 6:58pm UTC](https://community.thunkable.com/t/populate-local-datasource-table-dynamically/2605749/32 "2023-09-27T18:58:09Z")

</div>

Ok that is better

---

<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:** [December 26, 2023, 6:58pm UTC](https://community.thunkable.com/t/populate-local-datasource-table-dynamically/2605749/33 "2023-12-26T18:58:23Z")

</div>

Closed on December 26, 2023, 6:58pm UTC

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

[Previous page](https://community.thunkable.com/t/populate-local-datasource-table-dynamically/2605749.md?page=1)
