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

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!

0 Liam Hastings over 8 years ago

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.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Anna Osanmaz over 8 years ago in reply to Liam Hastings

Hi Liam,
Sorry for not getting back to you sooner.
Thanks a lot and you´re right the formula you proposed makes more sense when only looking at one value.
Thanks,
Cancel
Vote Up 0 Vote Down

Sign in to reply

Reject Answer

Cancel
0 Johannsen Quinio over 8 years ago in reply to Liam Hastings

I had the same question and was about to create a new topic for this. Luckily I found this! Thanks!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tanja LeMotte over 4 years ago 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
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Justin Kuehlthau over 4 years ago 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
Cancel
Vote Up +1 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tanja LeMotte over 4 years ago in reply to Justin Kuehlthau

That worked! Thank you Justin Kuehlthau!
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel