Skip to main content
All CollectionsSupport
How can I edit a specific column for a database record without affecting the values of other columns that are not being edited?
How can I edit a specific column for a database record without affecting the values of other columns that are not being edited?

I don't want my field with existing data to get set to null when I don't provide a value.

Jake Spirek avatar
Written by Jake Spirek
Updated over a week ago

Let's say you have an app and you want your users to be able to edit their profile. When they submit form that saves their updated profile, the only field they edited was their first name, but your API endpoint in Xano is expecting all the values and assumes that if you are submitting empty values, you want to clear those out.

Basically, Conditional Set Filters allow you to tell your function stack: "if this field isn't empty, then update it."

To use conditional set filters...

1) GET the record you want to edit

2) Update the variable that record is stored in using the conditional set filters

3) UPDATE the record using that variable

Did this answer your question?