Return blank PostCode when address is blank

#1

Sorry if this is covered elsewhere but my searching has failed to uncover the answer…

I want my data to have blanks within the Address field, but when this is blank I would like to also receive a blank Zip / post code for that record.

I am not a programmer so am struggling a little with the syntax to put together a formula so would appreciate any help that can be spared…

Thanks in advance.

UPDATE
I have done some additional playing and this seems to work, but would appreciate some feedback on weather this is returning a true null value or is it a blank text value?

the formula i am using is: my reference filed is address.

if adress.nil? then ‘’ else this end

#2

That’s returning a blank string. To return a null use:

if address.nil? then nil else this end
#3

Excellent! Thank you for the response.

#4

If you set both fields to have the same value in % blank then they will either both be blank, or both be filled.