Skip to main content
Katie DeLuna a posé une question dans #Data Management
Hello!

 

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
  1. 5 févr. 2019, 21:08

    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

     

    You could try the long way around. Create a formula field and in the formula have it mirror whatever the Picklist value is.
0/9000