2 Replies Latest reply on Nov 2, 2009 5:52 AM by Keystone

    Text Font + Formatting in a Field

    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!