Thread Details
  • State Not Answered
  • Replies 1 reply
  • Subscribers 354 subscribers
  • Views 439 views
  • Users 0 members are here
Forum Actions
Related

Drop Down dependent based on two dropdown ?

Manish kumar

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

  • 0

    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...