if this, then that, else do nothing

[Jake_Naude]

Please could someone advise if AppSheet has an if this, then that, else do nothing expression...?

IFS() is designed to produce a blank result when it evaluates to false.

When I save a row in another table called surveys, an action there fires that increases the value in the trigger-column of this table, called design, by +1.

The expressions in the design table use app formulas in order to update with the trigger-column changes.

In some instances I do want the existing value of a column to be updated.

In some instances I do not want the existing value of that column to be updated.

I tried applying a conditional edit but failed because of the app formula.

IFS() obviously doesn't help here either because it forces a blank result if FALSE and sometimes deletes the value I wanted to keep.

Thanks in advance for your assistance... 😉

[Jake_Naude · Accepted solution]

Oops... I found it... There was trouble between the chair and my keyboard...!

Thinking slightly differently about the scenario, and using IF() properly solved it... 😉

IF(

ISNOTBLANK[results_column],

(results_column],

[do_the_thing_that_gets_the_result_if_there_is_no_result_column]

)