-
I did what you said but it came out as the following:
(+14) 103-6352... it cut the last two numbers... Did I do something wrong?
-
should look like this....
see attached
-
That didnt come out too user friendly not sure why. I spaced everything out but it all came together when i submitted it. private message me your contact info if you dont get it..
-
on the field you want to format put a rule:
conditions:
"Field you are formatting" does not match pattern "Phone Number Pattern" AND
The expression "string-length(translate(., "()-. 0123456789", "")) = 0" AND
Then run these actions:
Set a fields value:
The field you want ...
-
OMG!!! Thank you so much.. I have been pulling my hair out....
-
Yes I just got your message. I have your solution. Give me a few to get it out to you.. :)
-
Hi Nwrann,
you can set up a rule, when the form is loaded with actions:
1) set a field value -> field: switch to the data connection to your list (create one, if you don't have it) -> query fields -> ID; value: add a funktion max of the field -> switch to the data connection to your list -> data fields ...
-
Hi I know this post is very old however its great... can you please help me format a number that is set up like this +12223334444. I would like it formatted like this 1 (123) 456-7890. Please I hope you get this message today because I am so trying to finish this project and I have searched the net and driving myself crazy.
Thanks so much!!!
-
Thanks Shmul,
A follow up question though, where do I specify in the query process to take the one with the max ID?
There's no option in the Data Connection.
The Query action only has 2 fields (Action, Data Connection)
The Conditions in the rule don't allow for "If (max)ID Assigned To ="
I can Set A ...
-
Hi SusanP,
you could try creating a new field in sharepoint as a calculated value with the information from your Request_Status field. This new field should be edditible.
Hope it helps.