Details about this thread
  • State Verified Answer
  • Replies 6 replies
  • Subscribers 294 subscribers
  • Views 2077 views
  • Users 0 members are here
Related content from around SugarClub

Set up of dependency between multiple drop-downs and one textfield.

Anna Osanmaz

Hi,

I would like to set up the following:

     1. Let´s say I have 3 drop-down lists of which "other" is one of the values

     2. If "other" is selected for drop-down 1, 2, or 3 I would like to see a textfield becoming mandatory

I know I have to put in the following formula in "dependent" for the textfield to make it work for one drop-down:

          isInList($dropdown1,createList("Other"))

But is there also a chance to extent this formula so that I don´t need to create three textfields but can combine this in one.

That means no matter from which dropdown I choose "other" this one textfield becomes available.

Many thanks for your support!

Parents
  • 0

    Hi Anna Osanmaz,

    You can indeed make this single field appear as long as any of the 3 Dropdowns have "Other" selected. In this instance you would have to use the "Or" function so that you can tell the system to show the field if any of them are set to "Other". If you hover over the function when in Formula Builder then it should give you an example of this.

    Additionally your formula above, although what you have done is good in your instance you could get away with equal($dropdown1,"Other") as you are only ever looking at one value. I personally only use the isInList function when I want the field to be dependant on many options for that one field.

  • 0 in reply to Liam Hastings

    Hi Liam, 

    Do you know how you would do this if the value was different between the three dropdowns?

    I have two dropdowns that both represent a status, but the terms within this status use different language between the two dropdowns.  Do you know how I would get the dependent field to show if the value in the first dropdown equaled one thing but the second dropdown is based on it equaling another?  I'm trying to avoid creating two fields for the same function, which in this case is to capture a relationship status upon leaving.  I've tried both of these but I'm sure I'm not using the 'or' correctly:

    isInList($franchise_status_c,createList("Inactive","Released")or($status_c,createList("Cancelled"))

    (isInList($franchise_status_c,createList("Inactive","Released")))or(isInList($status_c,createList("Cancelled")))

    Thank you,

    Tanja

  • 0 in reply to Tanja LeMotte

    Hi Tanja,

    Please try one of these formulas:

      
      ifElse  (  isInList  (  $franchise_status_c  ,  createList  (  "Inactive"  ,  "Released"  )),  true  ,  isInList  (  $status_c  ,  createList  (  "Cancelled"  )))
      
      or
      
      or  (  isInList  (  $franchise_status_c  ,  createList  (  "Inactive"  ,  "Released"  )),  isInList  (  $status_c  ,  createList  (  "Cancelled"  )))

    The "or" function works like any other function in Sugar Logic: or(true,false) and returns true or false.

    Regards,

    Justin

Reply Children
No Data