how can i use text encrypted field in validation. i created a PANCARD field and i am trying to apply validation on it but it seams like they are considering some value in it even after leaving it blank.... this is validation formula i used

Question

Rajamohan Vakati · Accepted Answer

use LEN instead of ISBLANK for encrypted text.

IF(LEN(Password__c)==0,0,1)

use this

AND(ISPICKVAL( City__c ,'Hyderabad'),
IF(LEN(PANCARD__c )==0,0,1)
IF(LEN(Phone_No__c)==0,0,1)
IF(LEN(Email__c )==0,0,1)
 )

Umair Khan · Answer

Thank you so much. This Len function worked but I didn't use as you said. I used the following formula AND(ISPICKVAL( City__c ,'Hyderabad'), LEN( PANCARD__c )==0, ISBLANK( Phone_No__c), ISBLANK( Email__c )  ) but as I am a complete beginner in sales force it will be great if any of you can tell me why you used that additional (0,1), I want to know how it is used.

how can i use text encrypted field in validation. i created a PANCARD field and i am trying to apply validation on it but it seams like they are considering some value in it even after leaving it blank.... this is validation formula i used

Formulas

관련 학습

도움 더 받기