How to connect two fields to one dropdown

Forums Cascading dropdowns How to connect two fields to one dropdown

This topic contains 3 replies, has 3 voices, and was last updated by  Alexander Bautz 3 months, 1 week ago.

  • Author
    Posts
  • #21415

    Ezra Goodnoe
    Participant

    I am struggling to configure a form so that when I select an option in a drop down, two fields respond – one gives choices (one to many) the other auto-populates (one to one). Eg. I have a list with organizational structure (managers) and associated teams and I want the user to be able to select a Level 1 Manager and have one field return as a dropdown of 2nd-level Managers and another text field automatically display the name of the team that Level 1 Manager ‘owns’. I also want this behavior for 2nd and 3rd-level managers. Is this possible or am I asking too much of the plug-in?

    This could be asked more generally in the following way:

    Given the following fields: Field1,Field2,Field3,Field4,Field5,Field6
    And the following relationships:
    Field1>Field2
    Field3>Field4
    Field5>Field6
    Field1>Field3>Field5
    I want the following behavior:
    select from Field1: Field2 autopopulates and Field3 returns filtered list of values

    The root question is: how would I configure the sections in the Cascading Dropdowns tab to accommodate this?

  • #21436

    Alexander Bautz
    Keymaster

    Hi,
    This cannot be done without the use of some custom js. I’m currently on holiday, but can help you with this code when I return home in about 10 days. Please email me some screenshots of your lists (both the org structure and the form you are trying to configure) so I can set it up in my test site.

    Alexander

  • #21687

    Mike
    Participant

    I would also be interested in this solution. Thank you for your help.

  • #21759

    Alexander Bautz
    Keymaster

    Hi,
    Look at this post which describes how you can create cascading dropdowns by chaining together multiple SPJS-Lookup fields: http://spjsblog.com/forums/topic/combing-spjs-lookup-with-cascading-dropdowns/#post-9408

    Alexander

You must be logged in to reply to this topic.