Community
Showing results for 
Search instead for 
Do you mean 
Reply

Global Change

New Member
Posts: 5
Country: USA

Global Change

My contact phone fields are all formatted differently. Can I make one change that will format them all the same, like (###) ###-#### or do I have to change them one at a time?

Moderator
Posts: 4,395
Country: USA

Re: Global Change

[ Edited ]

Legbo,

 

Use the following knowledgebase article.

How To Replace Phone Format For Multiple Records

 

Just for future references, there have been other posts regarding this how to.  The Community has a search feature in the upper left.  Searching for a other threads similar to your question/issue can save you a lot of time so you don't wait for a response.  It can be a huge time saver from just a couple minutes searching compared to waiting hours for a response.

Message Edited by DLunceford on 07-10-2008 10:10 AM
New Member
Posts: 5
Country: USA

Re: Global Change

Thanks for the response, I will try to use the search feature in the future. When I click on the link you posted, I get a "Fatal Error, Access Denied, Contact Knowledge Center Administrator" Any idead why I can't view this?
Copper Contributor
Posts: 156
Country: USA

Re: Global Change

Hi,

 

Try this: LINK

   

 

Moderator
Posts: 4,395
Country: USA

Re: Global Change

Thanks Tashina.

 

I've corrected my link also.

New Member
Posts: 5
Country: USA

Re: Global Change

Thanks to all - this worked perfectly! Now my problem is how they show up on the Contact List page - I searched and learned that the only way to fix that is to export to excel, reformat the cells as "phone", and bring it back in. I don't think I want to mess with that, way too much room for error there. Anyone know of another way to fix the list view? If not, I can live with it, but it would be nice to fix.

Next time we upgrade, I think we will pay up to have a Certified Act Consultant come in and map our database over - using a local "network specialist" has proved a total waste of time and money.

Moderator
Posts: 4,395
Country: USA

Re: Global Change

Legbo,

 

Contact list phone format can be corrected using the following knowledgebase article.

 

Phone Format Appears Correct In The Contact Detail View But Incorrect In The Contact List View

New Member
Posts: 1
Country: Canada

Re: Global Change

I've tried your links, and they all default to the Sage main page. Can you give me a basic run through? I'm currently updating them by changing the masking format on each record, and have over 3000 of them... long boring days.

Lindsay