Merge field only if empty

Is there a way to merge fields only if empty?

Psuedo code:
If (fieldA is null or FieldA = 0) then Field B Else Field A

Loving this program, btw



if.transform (1.9 KB)

You can also do it the Javascript transform, but if is simpler.


Line 3 of the solution offered by Admin should be ELSE IF A=0 to comply with your requirements

1 Like

You are correct. Thanks!