# Update data source specifying column

**URL:** <https://community.thunkable.com/t/update-data-source-specifying-column/3107091>\
**Category:** Questions about Thunkable X\
**Created:** [July 21, 2024, 3:25am UTC](https://community.thunkable.com/t/update-data-source-specifying-column/3107091 "2024-07-21T03:25:02Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![franc.pozo21qlruw9](https://avatars.discourse-cdn.com/v4/letter/f/a9a28c/32.png) [@franc.pozo21qlruw9](https://community.thunkable.com/u/franc.pozo21qlruw9)\
**Post date:** [July 21, 2024, 3:25am UTC](https://community.thunkable.com/t/update-data-source-specifying-column/3107091/1 "2024-07-21T03:25:02Z")

</div>

Is it possible to specifically select the cell where the data source will be updated? I have many columns where the data will be updated, I need to be able to select the specific cell in different cases for different columns, if I use the update block for each column I would need too many blocks.

I attach the image of what I would need as a block and all the columns I use. Comparatively to take the result of a cell if it can be done by specifying the column and row id using object get property,

 ![Captura de pantalla 2024-07-21 a la(s) 00.10.41](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/4/c4753a47555967a263f2fbfff6a71e5a79a8af5e.png)  
 ![Captura de pantalla 2024-07-21 a la(s) 00.14.39](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/9/d/9d6d2b03a7e1f8b31022be1dc34180f673e71580.png)

---

<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:** [July 21, 2024, 3:08pm UTC](https://community.thunkable.com/t/update-data-source-specifying-column/3107091/2 "2024-07-21T15:08:12Z")

</div>

You have two options as I see it:

1. Use the Google Sheets API so that you can update a cell dynamically instead of having to select it with a block.

2. Use Firebase instead which allows for cloud variable pathnames. This may or may not be a good option depending on what you need to do with your data and who needs access to it.

---

<div class="post-metadata">

**Author:** ![franc.pozo21qlruw9](https://avatars.discourse-cdn.com/v4/letter/f/a9a28c/32.png) [@franc.pozo21qlruw9](https://community.thunkable.com/u/franc.pozo21qlruw9)\
**Post date:** [July 21, 2024, 5:24pm UTC](https://community.thunkable.com/t/update-data-source-specifying-column/3107091/3 "2024-07-21T17:24:54Z")

</div>

Thanks for the reply. There are cases where I used the Firebase method. But in this case I need the data source update to be offline. It seems to me that in Google Sheets and Firebase I need an internet connection.

---

<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:** [July 22, 2024, 2:57pm UTC](https://community.thunkable.com/t/update-data-source-specifying-column/3107091/4 "2024-07-22T14:57:05Z")

</div>

You could use objects. You can create them in the format you want and then call on specific properties using dynamic text strings or variables.

---

<div class="post-metadata">

**Author:** ![ioannis](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/ioannis/32/146956_2.png) [@ioannis](https://community.thunkable.com/u/ioannis)\
**Post date:** [August 30, 2024, 7:07pm UTC](https://community.thunkable.com/t/update-data-source-specifying-column/3107091/5 "2024-08-30T19:07:52Z")

</div>

Hello @franc.pozo21qlruw9  
Now this is possible using our new Data source blocks!  
Check out our update here: [V471 Release Notes - Announcements / Release Updates - Community (thunkable.com)](https://community.thunkable.com/t/v471-release-notes/3168016)

---

<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:** [November 28, 2024, 7:08pm UTC](https://community.thunkable.com/t/update-data-source-specifying-column/3107091/6 "2024-11-28T19:08:29Z")

</div>

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