Prevent updating DB with empty values

[Christian_Liebig]

• Goal: I want to prevent updating Retool Database with NULL values.

I have a very simple table that pulls data from Retool Database. Within this table, I have 2 columns editable. I now have the problem, that whenever I update only 1 field within 1 row the other field, that I left untouched also gets updated but with basically an empty value.

I use the "Update an existing record" query and have the following Key Value pairs defined:

The changesetArray is looking as follows:

So what I think I need to achieve is

• either ignore empty values / non-existent keys
• or make sure to only take the the value from the changesetArray in case the value / key is present

Any help would be highly appreciated

[ZeroCodez]

Hi @Christian_Liebig, By enabling the 'Include full rows in changeset array' option in the table, you'll receive both the existing and updated values, even if you change the value for just one column.

[Christian_Liebig]

Thank you so much! Awesome!