Skip to main content
menachem cohen (menach) 님이 #Collaboration에 질문했습니다
number of the company-only 9 numbers allowed validation rule
답변 2개
  1. 2020년 10월 25일 오전 9:35
    Hi Menachem,

     

    What is the field type where you enter the company number, is it text or number?

     

    If it's text, you can use the LEN function:

     

    AND (

     

        NOT(ISBLANK(Company_Number__c)),

     

        LEN(Company_Number__c) != 9

     

    )

     

    If it's a number, you will need to convert it to text first:

     

    AND (

     

        NOT(ISBLANK(Company_Number__c)),

     

        LEN(TEXT(Company_Number__c)) != 9

     

    )
0/9000