+ Start a Discussion
manuel.johnsonmanuel.johnson 

Display formatted phone number in pdf

I created a visualforce page that displays the opportunity owner's phone number with the standard U.S. formatting "(555) 555-5555". Since the phone number is retrieved from the database unformatted (e.g. "5555555555"), I uploaded the jquery 1.9.1 library as a static resource and added a script to format the number as shown below. It works perfectly, however, when I try to render the page as pdf it no longer displays with the formatting. Is there any way to display it without having to create a controller extension? And if not, what is the simplest controller extension that would format the phone number?

 

<apex:page standardController="Quote" renderAs="pdf">
<head>
<apex:includeScript value="{!$Resource.jquery}"/>
<script>

$(document).ready(function() {
// Attach masks to correct input fields

$(".phone").text(function(i, text) {
text = text.replace(/(\d\d\d)(\d\d\d)(\d\d\d\d)/, "($1) $2-$3");
return text;
});

});

</script>
</head>
<apex:outputText styleClass="phone" value="{!Quote.Opportunity.Owner.Phone}" />
</apex:page>

Best Answer chosen by Admin (Salesforce Developers) 
TanejaTaneja

Hi Manuel,

 

The quick solution that I can think of now is, why don't you change and save the phone number in the Apex object itself. You can use the string function .replace() in the apex class to format accordingly.

 

Quote.Opportunity.Owner.Phone = Quote.Opportunity.Owner.Phone.replace ('+','00');

 

 

Best,

Ankit

 

P.S.: Mark it as a solution if it helped you.

All Answers

TanejaTaneja

Hi Manuel,

 

The quick solution that I can think of now is, why don't you change and save the phone number in the Apex object itself. You can use the string function .replace() in the apex class to format accordingly.

 

Quote.Opportunity.Owner.Phone = Quote.Opportunity.Owner.Phone.replace ('+','00');

 

 

Best,

Ankit

 

P.S.: Mark it as a solution if it helped you.

This was selected as the best answer
manuel.johnsonmanuel.johnson

Thanks Ankit - I ended up creating a Quote extension class and formatted the phone number as shown below. It's not a pretty solution but it works.

 

Quote.Opportunity.Owner.Phone='('+Quote.Opportunity.Owner.Phone.substring(0,3)+') '+Quote.Opportunity.Owner.Phone.substring(3,6)+'-'+Quote.Opportunity.Owner.Phone.substring(6,10);