I have this rough assembly to add a phone area code based on the state postcode (zip code) of an entry. Its correct 90% of the time and cuts down on manual entry. However, I don't want it to calculate/generate a result if the field 'Landline Trimmed' is empty, as at the moment it creates "+61 2" in the field as the area code field always contains a value. Is there something I can add to this to stop it generating "+61 n"? Thanks

 

Let(

@NumbersOnly = Filter(Landline Trimmed; "0123456789");

"+61 " &  Area code from postcode first numeral   & " " &  Left(@NumbersOnly; 4)

 & " " &

Right(@NumbersOnly; 4)

)

Wrap the existing statement into an If:

 

If ( not isEmpty ( Landline Trimmed ) ;  yourExistingStatement )

 

btw, why not GetAsNumber ( Landline Trimmed ) ?

Thanks for that. As for get as number, I do that initially via another field then work on it to build up a trimmed and formatted number.