Skip to main content
Topics#CollaborationMichael Dely의 질문
Michael Dely 님이 #Collaboration에 질문했습니다
2018년 9월 26일 오후 4:14

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개
  1. Gaurav Malik (RAVS)
    2018년 9월 26일 오후 5:20
    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.
답변을 작성하세요...
0/9000