Skip to main content
Swetha S 님이 #Formulas에 질문했습니다
Hi Developers,

Need a help to achieve below functionality. 

how to write a validation rule such that it should not allow any special characters(!@⌗$%^&*) and not allow all zeros in a field. (eg: 0 or 00 or 000 or 0000). 

I have used the below validation rule that is restricting special characters but allowing all zeros. 

NOT(REGEX(Phone__c,"^[a-zA-Z0-9]*$"))
답변 6개
  1. 2018년 10월 5일 오전 7:54
    Hi Swetha,

     Correction to the previous reply.

    OR(NOT(REGEX(test__c,"^[a-zA-Z0-9]*$")),REGEX(test__c,"^[0]*$"))
0/9000