Phone Number formatting - InfoPath Dev

InfoPath Dev

Use our Google Custom Search for best site search results.

Phone Number formatting

Last post 07-26-2021 08:40 AM by Hilary Stoupa. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 07-20-2021 10:20 AM

    Phone Number formatting

     Hi I am sure you have had this question before but I haven't been able to find the answer I need. In my solution I have a phone number field that is populated using the User Information data connection. My challenge is that I would like it if the data that goes into the WorkPhoneNumber field which is set by the LogInUser field would look like this 443-995-8229.  Can you help? Right now it looks like this 4439958229...

  • 07-26-2021 08:40 AM In reply to

    You could use substring formulas for this, I suppose - see the attached sample form. Right click the link in the post header, and select the option to save the file locally. Right click the saved file, and then select Design to open. Note - you may want to add some error handling to this, or not run the rule if the string isn't 10 chars long, or something like that, this is just a rudimentary sample.
    Hilary Stoupa

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.