Format On Display

[LWSChad]

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?

 

Thanks
CHAD

[Jan]

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]

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.)

[Jan]

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]

I'm good,,, I forgot to mark solved.

Thanks Again