Skip to main content
All CollectionsSupport
Edit Record: Only modify certain fields
Edit Record: Only modify certain fields
Chris Coleman avatar
Written by Chris Coleman
Updated over a week ago

Conditional filters are able to be used in place of Conditional (If-then-else) statements for certain use-cases. They will make your business logic appear much smoother and with less headache. They will be extremely helpful when editing a record but you only wish to update fields that are not empty or not null, in addition to updating objects where a field is not null or not empty.

In basic terms, it's a way to say "if this field isn't empty, then update it. But if it has an existing value then leave it alone."

Here are the examples:

first_notempty - returns the first value that is not empty (example shown in the video above)

first_notnull - returns the first value that is not null

set_ifnotempty - Good for updating objects. (example shown 4m in the video above)

set_ifnotnull - Similar to above, but useful for when you are dealing with null values.

set_conditional - Updates the value if the conditional specified is true

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?