# Update some cells in Airtable **URL:** \ **Category:** Questions about Thunkable X\ **Created:** [September 24, 2020, 8:31pm UTC](https://community.thunkable.com/t/update-some-cells-in-airtable/846531 "2020-09-24T20:31:37Z")\ **Posts on this page:** 11\ **Page:** 1
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 24, 2020, 8:31pm UTC](https://community.thunkable.com/t/update-some-cells-in-airtable/846531/1 "2020-09-24T20:31:37Z")
I have an airtable sheet with some names on it. When the user goes into the app and selects the same name but a different location, I just want to update the location in my airtable sheet. I have looked high and low and my google fu seems to be failing me. I didn’t think that it would be that difficult to update a cell in a table, Any hep would be appreciated. ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [September 24, 2020, 9:05pm UTC](https://community.thunkable.com/t/update-some-cells-in-airtable/846531/2 "2020-09-24T21:05:26Z")
Is your airtable dat structure some thing like this? {“Name”, “location”} If so, I’d do a vlookup to get row number. Then update the cell. Get column nAme Save to variable “columnData” Update cell Where row num = in list columnData find first occurrence of name Where Column = data Value = new data string ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 24, 2020, 9:18pm UTC](https://community.thunkable.com/t/update-some-cells-in-airtable/846531/3 "2020-09-24T21:18:41Z")
@jared Yes the structure is similar with some other fields. I will try your suggestion and report back. Is the vloolup done with the blocks you outlined ornis it done in airtable? I hate to ask for the blocks but let me try first and I’ll let you know. Thx! ---
**Author:** ![jared](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/jared/32/138473_2.png) [@jared](https://community.thunkable.com/u/jared)\ **Post date:** [September 24, 2020, 9:39pm UTC](https://community.thunkable.com/t/update-some-cells-in-airtable/846531/4 "2020-09-24T21:39:40Z")
Check this project [https://x.thunkable.com/copy/43d8bc23bf4562a5047ef0d44d5b1900](https://x.thunkable.com/copy/43d8bc23bf4562a5047ef0d44d5b1900) ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 25, 2020, 4:18pm UTC](https://community.thunkable.com/t/update-some-cells-in-airtable/846531/5 "2020-09-25T16:18:40Z")
Thanks for the direction @jared but I still don’t get it. Is there a way you can show me the blocks of a simple vlookup from airtable with 2 columns? Name and location in order to change the location field? ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 25, 2020, 6:03pm UTC](https://community.thunkable.com/t/update-some-cells-in-airtable/846531/6 "2020-09-25T18:03:40Z")
@jared, Here are the blocks I came up with from what you posted. The cell is not still not updating. If you could take a look, I would greatly appreciate it! ![Screenshot from 2020-09-25 14-02-13](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/3/0371bd023409762740e291aa6fe94664d762a65e.png) ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [September 25, 2020, 6:49pm UTC](https://community.thunkable.com/t/update-some-cells-in-airtable/846531/7 "2020-09-25T18:49:52Z")
@jared, I got it!!! In the blocks above I had to set the occurrence to a label that got populated from a list. Phew this one was tough but I appreciate your assistance in getting this working. Now my next part is to do this same thing for a date field as well as longitude and latitude fields. I’m assuming it is going to be nearly the same but of course any insight would be appreciated. I think these are going to be more difficult because there may be more than one of the same date and the lat and long won’t be something I can easily target. Is there a way to just overwrite a cell regardless of what is in there with new data, even if there is no data at all? Thanks again!! Dan ---
**Author:** ![gpo](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@gpo](https://community.thunkable.com/u/gpo)\ **Post date:** [November 27, 2020, 4:35pm UTC](https://community.thunkable.com/t/update-some-cells-in-airtable/846531/8 "2020-11-27T16:35:01Z")
Could you post the final solution? I am working on the same kind of problem. ---
**Author:** ![dpalusak](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/dpalusak/32/83327_2.png) [@dpalusak](https://community.thunkable.com/u/dpalusak)\ **Post date:** [November 28, 2020, 2:17pm UTC](https://community.thunkable.com/t/update-some-cells-in-airtable/846531/9 "2020-11-28T14:17:13Z")
@gpo, Here is a screenshot of what my final blocks look like. Let me know if you have any other questions. ![2020-11-28 09_12_40-Thunkable](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/8/08574464a39f752a0026aa493ceab89fbb72ddae.png) ![2020-11-28 09_18_02-Thunkable](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/a/6af34dd5cd11f5667c1460b54fa194fc1029832a.png) ---
**Author:** ![gpo](https://avatars.discourse-cdn.com/v4/letter/g/7993a0/32.png) [@gpo](https://community.thunkable.com/u/gpo)\ **Post date:** [November 28, 2020, 4:04pm UTC](https://community.thunkable.com/t/update-some-cells-in-airtable/846531/10 "2020-11-28T16:04:14Z")
Thank you ---
**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:** [November 8, 2024, 12:21pm UTC](https://community.thunkable.com/t/update-some-cells-in-airtable/846531/11 "2024-11-08T12:21:23Z")