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.
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