
We would like to limit the Lead Source value on Accounts and Opportunities so that the values can only be up to 40 characters. Is that even possible to put a limit on there without code (or even WITH code)? It's not really an end user validation rule. It's more on the admin side so that we can't add values that are over 40 characters. Thanks!
7 réponses
You could try the long way around. Create a formula field and in the formula have it mirror whatever the Picklist value is. The formula would be this
TEXT(PICKLIST)
Now run a validation rule on that custom field to count the length of the CHARS and have it error out if over 40. Formula looks like this.
LEN( Count_of_Field__c ) > 40