LWSChad Posted December 16, 2014 Report Share Posted December 16, 2014 Hello, I have been storing phone numbers with the special characters ( ) - and I would prefer to store numbers only and format the data into phone numbers on display. I can format one per page, but only the first one. Can anybody help me with this? ThanksCHAD Thomasea 1 Quote Link to comment Share on other sites More sharing options...
Jan Posted December 17, 2014 Report Share Posted December 17, 2014 Hello CHAD, What type of DataPage do you use? And how you format one per page? Could you please provide the Java Script code? LWSChad 1 Quote Link to comment Share on other sites More sharing options...
LWSChad Posted December 17, 2014 Author Report Share Posted December 17, 2014 Thanks for the reply Jan I figured out an approach, but after I got it I realized the pitfalls of formatting on display. (Users like to see the special characters while adding and editing so adding or editing phone numbers without special characters feels wrong from the end user point of view, editing now requires un-formatting and ensuring the user doesn't use special characters, tel: tags like special characters, etc.) My Javascript approach was from a few weeks ago, and when I couldn't get it I abandoned the effort until yesterday... It lacked a loop which is why I was only getting one per page. The approach I used yesterday to get it was a Caspio Calculated Field: this is from memory because I went back to storing special characters... '('+Left([@phoneField],3)+') '+Left(Right([@phoneField],7),3)+'-'+Right([@phoneField],4) (even thought I decided not to do this the formula above might be helpful to others.) Quote Link to comment Share on other sites More sharing options...
Jan Posted December 18, 2014 Report Share Posted December 18, 2014 Hello CHAD, There is a Java Script solution for Submission Forms. But I am afraid, I do not understand clearly what is your goal. LWSChad 1 Quote Link to comment Share on other sites More sharing options...
LWSChad Posted December 18, 2014 Author Report Share Posted December 18, 2014 I'm good,,, I forgot to mark solved. Thanks Again Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.