Drop Down dependent based on two dropdown ?

Hi @All,

I want to solution to dropdown Listing based on two parent dropdown condition 

scenario- i have 3 Drop Down 1-categeory 2-Subcategeory 3- application office

current fun-: subcategory dropdown list is shows based on category and application office list of dropdown shows on subcategory as per my current functionality.

but now i want application office Dropdown list of value based on both category and subcategory list of some values or conditions. 

  Thanks

Parents
  • Hi ,

    My first thought is the Dependent (visible if) formula on the new field, based of the other fields...
    I thought I had done similar before but havent found where it was yet!   

    Something like a big ifElse formula in here:

    (ifElse(
     and( first bunch of options),
     Next bunch of options - can we nest ifElse?  not sure
     )

    If I do find what I think I did ages ago and it is helpful I will post again, sorry - on a deadline (in a rush) and just looking in club for another solution and spotted this - hopefully this brief comment helps...

Reply
  • Hi ,

    My first thought is the Dependent (visible if) formula on the new field, based of the other fields...
    I thought I had done similar before but havent found where it was yet!   

    Something like a big ifElse formula in here:

    (ifElse(
     and( first bunch of options),
     Next bunch of options - can we nest ifElse?  not sure
     )

    If I do find what I think I did ages ago and it is helpful I will post again, sorry - on a deadline (in a rush) and just looking in club for another solution and spotted this - hopefully this brief comment helps...

Children
No Data