function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
yk will 5454yk will 5454 

Number Field Formula Update

How do I do a field update when ever the number Field is edited or created it should update a new field with only the numbers for example 2124441111 and not (212) 444-1111 with the symbols.

 
I need to do this for external ID, I could not use the number Field for an external ID.
From: Number__c Data 
Data Type: Phone
 
To: External_ID__c
Data Type: Text(12) (External ID)

 

Ispita_NavatarIspita_Navatar

In order to achieve your requirement you need to replace -  "(", ")' and "-" with "".

 

Try using the following function:-

 

SUBSTITUTE(text, old_text, new_text)

 

Your final formula will look somewhat like this:-

 

SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(text, old_text, new_text),old_text1,new_text) , old_text2 , new_text)

 

where text is  your field, old_text is "("  , old_text1 is ")" , old_text2 is "-" and new_text is "".

 

 

Did this answer your question? If not, let me know what didn't work, or if so, please mark it solved.