# Update column & row failed **URL:** \ **Category:** Questions about Thunkable X\ **Tags:** spreadsheets\ **Created:** [October 23, 2019, 8:00am UTC](https://community.thunkable.com/t/update-column-row-failed/284607 "2019-10-23T08:00:11Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\ **Post date:** [October 23, 2019, 8:00am UTC](https://community.thunkable.com/t/update-column-row-failed/284607/1 "2019-10-23T08:00:11Z")
Hi All, I have return data to the textbox which is worked as expected but when i try to update it wont update in airtable. I been searching example in forum but nothing similar. Hope anyone can suggest me about this issue. Here it is my block. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/b/abe24d41837a8ffd73983e6478aec6515b868ba8.png) ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [October 23, 2019, 9:47am UTC](https://community.thunkable.com/t/update-column-row-failed/284607/2 "2019-10-23T09:47:16Z")
Hi, What message is in error block? ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [October 23, 2019, 10:50am UTC](https://community.thunkable.com/t/update-column-row-failed/284607/3 "2019-10-23T10:50:43Z")
> [@actech](#): > > What message is in error block? @ozel1978 To check the error, `setLabel1.text` to **error**. Thanks 😊 ---
**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\ **Post date:** [October 24, 2019, 10:50am UTC](https://community.thunkable.com/t/update-column-row-failed/284607/4 "2019-10-24T10:50:55Z")
“no \_id property was specified in the provided object” ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [October 24, 2019, 11:18am UTC](https://community.thunkable.com/t/update-column-row-failed/284607/5 "2019-10-24T11:18:59Z")
That’s right, you update the object, but did not specify the value of the \_id. How does the program know which line you want to update in the table? ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [October 24, 2019, 11:33am UTC](https://community.thunkable.com/t/update-column-row-failed/284607/6 "2019-10-24T11:33:49Z")
Forward to this, take the **`update row by number`** block, add your **Row ID** in the “ID property” of the block. Lastly, add your **`object`**. Thanks 😊 ---
**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\ **Post date:** [October 24, 2019, 4:38pm UTC](https://community.thunkable.com/t/update-column-row-failed/284607/7 "2019-10-24T16:38:12Z")
what is my raw ID? i try doing by putting number 1 and only row number 1 only. In my design i have plenty of list name in list view. below is block. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/c/cc739e2578c455811cd6bf4d4212e830fc3080ff.png) airtable sample ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/4/c4fdb3c2164461867f30d577838d445c8c8cb796.png) ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [October 24, 2019, 8:41pm UTC](https://community.thunkable.com/t/update-column-row-failed/284607/8 "2019-10-24T20:41:52Z")
All rows in the table have the \_id field. This hidden field, but it can be obtained by using the block to get all the records from the table. An example from my table ![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/4/1449f14af72df9dd6051cede9472b0ab661a1c63.png) See the scrAirTable in project [https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/](https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/) ---
**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\ **Post date:** [October 25, 2019, 3:24am UTC](https://community.thunkable.com/t/update-column-row-failed/284607/9 "2019-10-25T03:24:01Z")
Actech, I have look before of your project but seem complex for me to understand. how to get id field from block or airtable? or direct me what should i change in my block. ---
**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\ **Post date:** [October 25, 2019, 3:26am UTC](https://community.thunkable.com/t/update-column-row-failed/284607/10 "2019-10-25T03:26:34Z")
in kodular i am get start value and it worked but in thunkable x, i did not find such as component. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/a/d/ad978d228ca4bbe0f1f10e75fe7212888648b9c9.png) ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [October 25, 2019, 5:04am UTC](https://community.thunkable.com/t/update-column-row-failed/284607/11 "2019-10-25T05:04:51Z")
Hi, @ozel1978 👋 > [@ozel1978](#): > > start value I made such tutorial a few days ago 😇 - > [@How to use StartValue in Thunkable X with LocalStorage](http://community.thunkable.com/t/how-to-use-startvalue-in-thunkable-x-with-localstorage/115613): > > Hello, Thunkers! In this post, we’ll talk about How to implement StartValue in App I saw many users seeking for the solution for StartValue in Thunkable X… thinking So, finally, I found myself a solution and I want you all to have a look at it grin So, if you want to transfer any type of value to another screen, you may try using LocalStorage for this. I have some code blocks related to the above idea. You may take reference from them below : Sending Start Value [image] Getting Start… ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [October 25, 2019, 7:50am UTC](https://community.thunkable.com/t/update-column-row-failed/284607/12 "2019-10-25T07:50:47Z")
Look block for get \_id field. ![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/0/a/0ad7a5d194e85f9b384aaa8c0a8162822efa4786.png) ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [October 25, 2019, 11:08am UTC](https://community.thunkable.com/t/update-column-row-failed/284607/13 "2019-10-25T11:08:00Z")
@actech I think he wants to send the **rowID** from some other screen like `Screen1` to `Screen2`. That must be the reason he asked for StartValue feature in Thunkaable X 🙃 Thanks! 😊 **P.S.** he got the solution for StartValue 😇 ---
**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\ **Post date:** [October 26, 2019, 5:50pm UTC](https://community.thunkable.com/t/update-column-row-failed/284607/14 "2019-10-26T17:50:13Z")
yeah i should explain earlier my structure is. It really help. Meanwhile about update row & column, i still stuck. ---
**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\ **Post date:** [October 26, 2019, 5:50pm UTC](https://community.thunkable.com/t/update-column-row-failed/284607/15 "2019-10-26T17:50:53Z")
i still trying. ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [October 26, 2019, 6:23pm UTC](https://community.thunkable.com/t/update-column-row-failed/284607/16 "2019-10-26T18:23:49Z")
UpdateRowNum - this block works ![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/1/3/13276efe856e2d0d1a92ce238c9e4b265dd247b3.png) UpdateRow - this block works too ![%D0%B8%D0%B7%D0%BE%D0%B1%D1%80%D0%B0%D0%B6%D0%B5%D0%BD%D0%B8%D0%B5](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/f/0/f0ab6b2008242ff9937e6d5756c785b236605ff3.png) ---
**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\ **Post date:** [October 28, 2019, 2:25am UTC](https://community.thunkable.com/t/update-column-row-failed/284607/17 "2019-10-28T02:25:57Z")
first block First block it worked but in only save for first row. i have plenty of list from spreadsheet. suppose when i click any row from list below. it should able to update. below is my list in airtable. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/b/1/b1a64de5672fd6ffb32c9b618041f8658bf29b68.png) second come out such as error. trouble updating row"" invalid parameter validation failed. check your request data ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/c/2/c25767a821c8b0713c885f331a1be50f284afc55.png) ---
**Author:** ![kartik14](https://sea1.discourse-cdn.com/flex015/user_avatar/community.thunkable.com/kartik14/32/44782_2.png) [@kartik14](https://community.thunkable.com/u/kartik14)\ **Post date:** [October 28, 2019, 5:15am UTC](https://community.thunkable.com/t/update-column-row-failed/284607/18 "2019-10-28T05:15:33Z")
> [@ozel1978](#): > > suppose when i click any row from list below. it should able to update You might be using a **listview** for displaying the column from Airtable. If you click **`1621`** (which is the first item in Airtable’s column), the first row will update. If you click the second one, the second one will update & so on. If you want to do like this, these blocks might help you - ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/6/3/63d617391c62bfa501bb89f216c866c83554eb61.png) > [@ozel1978](#): > > trouble updating row"" invalid parameter validation failed. check your request data Because in Airtable, you have a column named **`id`**. In blocks, you have added the property name as **`_id`**. That’s why this error is coming… Thanks! 😊 ---
**Author:** ![actech](https://avatars.discourse-cdn.com/v4/letter/a/3d9bf3/32.png) [@actech](https://community.thunkable.com/u/actech)\ **Post date:** [October 28, 2019, 1:00pm UTC](https://community.thunkable.com/t/update-column-row-failed/284607/19 "2019-10-28T13:00:24Z")
I have improved example of the work on scrAirTable [https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/](https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/) ---
**Author:** ![ozel1978](https://avatars.discourse-cdn.com/v4/letter/o/3ec8ea/32.png) [@ozel1978](https://community.thunkable.com/u/ozel1978)\ **Post date:** [October 28, 2019, 4:17pm UTC](https://community.thunkable.com/t/update-column-row-failed/284607/20 "2019-10-28T16:17:36Z")
here it is my full block. i have tried as per suggest but still get an error. what was wrong on my block at row object at button 4? on list view should be fine because i want to be like that. ![image](https://us1.discourse-cdn.com/flex015/uploads/thunkable/original/3X/7/b/7bc1e1e88e79bf782fafc8412dec2abac56fbdd1.png) [Next page](https://community.thunkable.com/t/update-column-row-failed/284607.md?page=2)