Iā€™m unable to update data to Airtable through the API

šŸ’¬ App Building
1

  1. My goal: Update different data back to Airtable via API.

  2. Issue: The value is not updating based on my selected option.

image
image1920Ɨ1258 187 KB

Please refer to the image ā€” when I only write "Container": "{{ table2.changesetArray[0].Container }}" in the code, the data is successfully sent back to Airtable.

image
image1920Ɨ914 116 KB

When I added the second line of code, the data update shows undefined.

Iā€™m really confused.

2

Hi there @April_Fgt,

So, I think what's confusing you is that with your current set up changesetArray only includes values that have been edited, rather than your full row. In fact, in your second screenshot there is an edit only in status, therefore Container comes across as undefined, as this column is not being included in changesetArray (as no edits are present).

What you can do is enable the below option in your table:

image
image558Ɨ446 25.7 KB

This will include the full row, which will then ensure that any column you're referring shows the value, whether the edited one or the current data.

Hope this helps!

Best,
Miguel