You need to sign in to do that
Don't have an account?
MeghanQFS
123-456-789
I want to be able to type 9 digits but have the dashes automatically be inserted after every three digits.
I've made the custom field, but I cannot figure out the right formula.
Any ideas?
All Answers
Hello MeghanQFS,
If it is a custom field it will utilize __c after the normal name. Yours is most likely SIN__c. You can view the name by going to field in setup and viewing the API name.
Yup, that is the right API name; SIN__c, but it tells me that the field does not exist.
I think you are looking for a mask which isn't possible in the system at the current time. The REGEX() function is utilized in a validation rule to make sure the user enters the correct format but will not make the user's data format in that method. If you go to Help & Training and do a search for REGEX you will see how it is designed to work.
Your other option is to validate that the user enters the 9 numeric digits. You can then build a workflow and field update that will change that 9 digit value to the correct format of 999-999-999.
Unfortunately no.