General

Re: Auto-formating Phone Numbers in InfoPath Form

Evanz — Tue, 11 Aug 2020 23:36:14 GMT

Thank you for your quick response. It works perfectly as to what I am looking for. You're the best Hilary! Much appreciated. :) You have a wonderful evening!

Re: Auto-formating Phone Numbers in InfoPath Form

Hilary Stoupa — Tue, 11 Aug 2020 22:33:25 GMT

Here, I added a validation rule. :-)

Re: Auto-formating Phone Numbers in InfoPath Form

Evanz — Tue, 11 Aug 2020 19:17:30 GMT

Yes, It's a field just for entering numbers. Thank you very much for your sample. It's very helpful. :-). Just one more question, is it possible to add another condition into your sample provided that if user enter more than or less than 10 digit phone numbers, the phone number field will display a red margin around the field? I mean user should enter the correct 10 digit numbers for this field. Any hint? Thanks again. :-)

Re: Auto-formating Phone Numbers in InfoPath Form

Hilary Stoupa — Tue, 11 Aug 2020 15:36:06 GMT

Where do you intend to use this? It looks like it would be for the field if only numbers were entered... In which case, in a rule on the field you wish to format, set the same field using this formula, probably with a condition that the field doesn't contain () or -. See attached sample - save the file locally, right click and select design.

Re: Auto-formating Phone Numbers in InfoPath Form

Evanz — Mon, 10 Aug 2020 18:15:11 GMT

Hi, thank you for your prompt response! since the form created for the company's internal use only, so it should have to be 10 digit numbers that I did not even think about adding a country code or something, etc...:-)

Below is a calculate value that I have been searching for from google but I am not sure if it works or do I have to use any rule/condition? Any advices? I really appreciate it.

concat("(", substring(translate(., "()-", ""), 1, 3), ")", substring(translate(., "()-", ""), 4, 3), "-", substring(translate(., "()-", ""), 7, 4))

Re: Auto-formating Phone Numbers in InfoPath Form

Hilary Stoupa — Fri, 07 Aug 2020 01:57:15 GMT

Hmmmm. I mean.... maybe? Perhaps you could use translate to remove everything that isn't a number, then split it up and add in the parenthesis and the dash... but then, who knows if someone is going to add a country code or something. That might get a little tricky. Maybe have a field (number only) for country code (if needed) and another field (number only) for phone, and then display it formatted in a calculated value? I just can't think of a robust way to do this with rules / form logic.....

Auto-formating Phone Numbers in InfoPath Form

Evanz — Thu, 06 Aug 2020 01:01:39 GMT

Hi,

Is it possible to set auto-formatting phone number field in InfoPath form? if yes, what code would be using? any assistance would be much appreciated.

Thank you,