function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
RonMTCRonMTC 

If . . . . then . . . .

Hello Community - need some help to figure out a field entry.

 

How do I go abouts creating a required field with a picklist, that if/when the user choses "Other", it then sends them to another  text field to enter details of what that "Other" is?  This also to be required.

 

Actually, I already have the required field with picklist.  I just need to know how to do the rest.

 

Any ideas?

 

Thanks in advance to all that post help/suggestions/comments.

:smileywink: 

Steve :-/Steve :-/
AND(ISPICKVAL(PicklistField, "Other"),
ISBLANK(TextField))

 
Shashikant SharmaShashikant Sharma

Try this if you want to chek both picklist and second field which you want to be req when values is other , Change the Field API names as per your Field API Names

 

OR(
          ISNULL(FieldAPINameOfPickList__c) ,
          AND(
                     ISPICKVAL(FieldAPINameOfPickList__c, 'Other') ,
                               OR(
                                         ISNULL(FieldAPINameOfOtherField__c) , ISBLANK(FieldAPINameOfOtherField__c)
                                      )
                   )
       )

 

 

If you have already made picklist req then  just this is enough

 

          AND(
                     ISPICKVAL(FieldAPINameOfPickList__c, 'Other') ,
                               OR(
                                         ISNULL(FieldAPINameOfOtherField__c) , ISBLANK(FieldAPINameOfOtherField__c)
                                      )
                   )

 
Steve :-/Steve :-/

@RonMTC  are you all set with this or do you still need help?
RonMTCRonMTC

Thanks you two - apologies for late reply.  Was Out of Town for a little and just got back.  I'll try these and let you know.
Steve :-/Steve :-/

Are you all set with this or do you still need help?
RonMTCRonMTC

Hi there - Just wanted to close this off and tell you both, "Thank you very much!" for your help with this.

I used:

AND(ISPICKVAL( Industry, 'Other') ,OR(ISNULL( Industry_Other__c) , ISBLANK( Industry_Other__c)))

 

and it works great!

 

Apologies for such a long delay in getting back.  I was moved around on assignments and didn't have a chance to get back to this till now.

 

Thank You, THANK YOU again to Stevemo and Shashikant Sharma for their help with this.

 

Ron