If ( IsEmptty ( field1 ) ; field2 ; field 1)
That's what I tried in the first place but the field remains empty...Not sure why! I have not replace field contents selected on the calc and field type is number.
Any ideas what is happening?
calculation field or auto-entered calculation on a text field?
I recommend a calculation field for this.
Since phone numbers might include non-numeric characters such as ( ) or -, are you sure you don't want text as the return type?
Good points! For some reason the calc field escaped me as it has been a loooong day! Will alter to text too...