changesetArray Null

I am trying to update my cells on a table and than return the updated cells to a mysql database.

I use 'Update an existing record' action. The issue is, table consists of multiple columns and when I update a cell, only that spesific item appears in changesetArray['0'] so that the rest of the items in that row is updates with null.

How to update only the changed cell without updating the rest, or at least updating with their current value to not return null.

Thank you!

HI there @mkurt,

You can use bulk update via primary key, see here.

Change to action type "Bulk update via primary key", select your table and primary key, and then add {{table_new_entry.changesetArray}}

Thanks a lot @MiguelOrtiz , it looks like it worked :blush:

1 Like