You need to sign in to do that
Don't have an account?
Swapnil Patne 20
Multiple fields required when a specific value is selected in picklist field
Hi,
Please can someone help with rectifying the error- surely I am missing something? Managed to create this formula to make fields required if certian picklist values are selected, but for some reasons it is not working.. (able to save the record without a value in required fields). Not sure if it is beacuse of type of fields as mentioned below in comments.
AND(
OR(
ISPICKVAL(Contact_Status__c, "Unqualified / Inactive"),
ISPICKVAL(Contact_Status__c,"Qualified & Actively looking"),
ISPICKVAL(Contact_Status__c, "Passive C"),
ISPICKVAL(Contact_Status__c,"Placed By Us"),
ISPICKVAL(Contact_Status__c, "Contracting For Us")),
AND (
ISBLANK(User_Group__c), [is a multi-picklist]
ISBLANK(TEXT(Domain__c)), [is a picklist]
ISBLANK(TEXT(Industry__c)), [is a picklist]
ISBLANK(Technology_Skills__c))) [is a multi-picklist]
Would really appreciate your help here.
Thanks in advance.
Swapnil
Please can someone help with rectifying the error- surely I am missing something? Managed to create this formula to make fields required if certian picklist values are selected, but for some reasons it is not working.. (able to save the record without a value in required fields). Not sure if it is beacuse of type of fields as mentioned below in comments.
AND(
OR(
ISPICKVAL(Contact_Status__c, "Unqualified / Inactive"),
ISPICKVAL(Contact_Status__c,"Qualified & Actively looking"),
ISPICKVAL(Contact_Status__c, "Passive C"),
ISPICKVAL(Contact_Status__c,"Placed By Us"),
ISPICKVAL(Contact_Status__c, "Contracting For Us")),
AND (
ISBLANK(User_Group__c), [is a multi-picklist]
ISBLANK(TEXT(Domain__c)), [is a picklist]
ISBLANK(TEXT(Industry__c)), [is a picklist]
ISBLANK(Technology_Skills__c))) [is a multi-picklist]
Would really appreciate your help here.
Thanks in advance.
Swapnil
Please try the below.think you have to check if any of these fields are blank.Is that right?
All Answers
Please try the below.think you have to check if any of these fields are blank.Is that right?
Thanks