You need to sign in to do that
Don't have an account?
JC5
Syntax Error on Formula in Text Field
I created a custom text field called "Contract ID Number" and I want to only enter numbers. I was trying to use this formula
OR(LEN(Contract ID Number) <> 20)
But I get Error: Syntax error. Missing ')' I checked and I seem to close everything out properly. I'm pretty new to salesforce so any help would be much appreciated.
*Note: I could have used a number field, but I didn't because of the comma it generate (ex show 2000 instead of 2,000)
OR(LEN(Contract ID Number) <> 20)
But I get Error: Syntax error. Missing ')' I checked and I seem to close everything out properly. I'm pretty new to salesforce so any help would be much appreciated.
*Note: I could have used a number field, but I didn't because of the comma it generate (ex show 2000 instead of 2,000)
I think you should use Api Name Insted of Label.
E.g - OR(LEN(Contract_ID_Number__c) <> 20)
I am sure It will not generate any error.
let me know if it helps you and marking it as best.
Thank you
All Answers
Thanks,
Try The Following Validation Rule Please Mark It As Best Answer If It Helps
Thank You!
I think you should use Api Name Insted of Label.
E.g - OR(LEN(Contract_ID_Number__c) <> 20)
I am sure It will not generate any error.
let me know if it helps you and marking it as best.
Thank you