Update a Column with other Column when editing from same view only if first value is 0

[dherly]

Hi everyone,

I have a single table/view containing a ‘Planned Quantity’ column. The concept is that when a user edits a row, the ‘Real Quantity’ column, initially set to 0 or null, should be updated with the ‘Planned Quantity’ value only if it is 0 or null. In this scenario, I can’t utilize an initial value because I’m not adding a new record.

[Joseph_Seddik]

Use:

OR(ISBLANK([column]), 0 = [column])

Here: