Skip to main content
Topics#CollaborationMichael Dely's Question
Michael Dely asked in #Collaboration
Sep 26, 2018, 4:14 PM

Dependent Field Solution for a Numerical Field

I was wondering if there is a way to make a number field grayed out or dependent based on a picklist field? I know there might not be a way, but wanted to check on potential solutions. 

 

I have a picklist field that has selections of monthly, quarterly, semi-annual, annual, and custom. The number field will automatically pull 30, 90, 180, 365 based on those selections except custom. I would like this field to stay grayed out unless the selection of "custom" is chosen. Please let me know some possibilities in order to achieve this.  Appreciate it.  

 

Thanks, 

 

Mike
2 answers
  1. Gaurav Malik (RAVS)
    Sep 26, 2018, 5:20 PM
    OR(

     

    TEXT(MonthField) = 'monthly' && NumberField <> 30,

     

    TEXT(MonthField) = 'quarterly' && NumberField <> 90,

     

    TEXT(MonthField) = 'semi-annual' && NumberField <> 180,

     

    TEXT(MonthField) = 'annual' && NumberField <> 365

     

    )

     

    If you use this validation rule, an error should show up if number field is changed when month field is anything other than custom.
Write an answer...
0/9000