AnsweredAssumed Answered

Text Font + Formatting in a Field

Question asked by Keystone on Nov 1, 2009
Latest reply on Nov 2, 2009 by Keystone

Title

Text Font + Formatting in a Field

Post

There's probably an obvious answer to this, but I'm missing something in my "Missing Manual".

 

I simply need to format a phone number field OnEnter to do two things... remove the formatting of the number I've copied, as well put it into the (555) 666-7777 format.

 

I have these two calculations:

 

TextFormatRemove (  Self )

 

Let(phone = Filter(Phone_number_field;"0123456789");"(" & Left(phone;3) & ") " & Middle(phone;4;3) & "-" & Middle(phone;7;4)) 

 

But what's the syntax to have them both work together? i.e. what exactly should I put into "Specify Calculation" box?

 

Thanks! 

 

Outcomes