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

    Text Font + Formatting in a Field



      Text Font + Formatting in a Field


      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?