Update column & row failed

[ozel1978]

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.

[actech]

Hi,

What message is in error block?

[kartik14]

What message is in error block?

@ozel1978
To check the error, setLabel1.text to error.

Thanks

[ozel1978]

“no _id property was specified in the provided object”

[actech]

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?

[kartik14]

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

[ozel1978]

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.

airtable sample

[actech]

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

See the scrAirTable in project

https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/

[ozel1978]

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.

[ozel1978]

in kodular i am get start value and it worked but in thunkable x, i did not find such as component.

[kartik14]

Hi, @ozel1978

@ozel1978

start value

I made such tutorial a few days ago -

How to use StartValue in Thunkable X with LocalStorage

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… So, finally, I found myself a solution and I want you all to have a look at it 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…

[actech]

Look block for get _id field.

[kartik14]

@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

[ozel1978]

yeah i should explain earlier my structure is.

It really help. Meanwhile about update row & column, i still stuck.

[ozel1978]

i still trying.

[actech]

UpdateRowNum - this block works

UpdateRow - this block works too

[ozel1978]

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.

second come out such as error.
trouble updating row"" invalid parameter validation failed. check your request data

[kartik14]

@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 -

@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!

[actech]

I have improved example of the work on scrAirTable

https://x.thunkable.com/projects/5d70f93f8a62b4079eedaff2/project/properties/designer/

[ozel1978]

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.