You need to sign in to do that
Don't have an account?
sakthivel
Need Help on lpad formula
i want to convert 1 to 001 by workflow or anything..
My custom field name - Number_of_Vacancies
i used this formula
lpad( Number_of_Vacancies2__c ,3,'0')
giving error, to change the filed type to text
lpad( text(Number_of_Vacancies2__c) ,3,'0') Not helping.. any idea ? ?
Hi sakthivel,
Salesforce by default removes the leading 0's from a number value.
So, you can achieve it by making the field type to "TEXT' and use the same formula you used i.e. lpad( Number_of_Vacancies2__c ,3,'0')
After making it to TEXT type, you can apply a validation rule in order the field allows only numeric values, if you need.