Merge field only if empty

Question
1

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

2

Yes.

if

if.transform (1.9 KB)

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

Thanks!

3

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

1 Like
4

You are correct. Thanks!