Creating a Cascading Dropdown in a Custom Form | Community
Skip to main content
L
LeifBr2
Level 3
April 6, 2020
Question

Creating a Cascading Dropdown in a Custom Form

  • April 6, 2020
  • 2 replies
  • 1950 views

Hi,

I've received a request to add cascading dropdowns in a custom form. In the past, I was able to use a matrix from which the dropdowns can narrow down values. I know I can use display logic to hide and show dropdowns; however, this becomes messy as we hundreds of rows with multiple combinations.

Has anyone encountered this issue and how were you able to address the ask?

Thanks,

LB

    This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.

    2 replies

    imgrund
    Adobe Employee
    imgrundAdobe Employee
    Adobe Employee
    April 7, 2020

    Hi Leif - yeah, unfortunately, to my knowledge, there is no way to accomplish this. We had to go the route where there were different drop downs (hence different field) and used display logic.

    One thing that helped, we added a Calculated field on the custom form called "Subcategory" that looked at all the different drop downs and displayed the name of the one that had a value. So for groupings you just had the two fields to worry about instead of 9 different subcategory fields.

      K
      keegan_oconnor
      Level 2
      April 7, 2020

      We use multiple drop downs and display logic as well. I am definitely going to copy the subcategory idea, though!

      K
      KevinQu1
      April 9, 2020

      Same here. As mentioned by others, we have created "- Composite" fields using CONCAT to create a final value for reporting.

      One caveat! If the user goes down a set of branches and changes their mind and backs-up, the original selected values get mangled-up with the new selections. This is because the display logic hack doesn't erase values if you-select farther up the hierarchy.

      Maybe someone else can articulate this better than I can/ I just know if makes a mess of reports and the work-around (delete the custom form, re-add, and start over) is painful. Of course, so is manually reconciling it offline.

      Does make me wish there was a "reset form" option.

        imgrund
        Adobe Employee
        imgrundAdobe Employee
        Adobe Employee
        April 9, 2020

        Good point! I guess I have been lucky and haven't run into the issue (Although, now I feel like I need to do an audit to be sure. LOL!)

        If you don't have too many options in the first drop down, maybe you could do an IF statement for the "subcategory" field so that you wouldn't have to worry if there is an old value in place.

        If my audit goes poorly, I'll be redoing mine and will share. LOL!

        K
        KevinQu1
        April 9, 2020

        LOL. Despite having only a three level hierarchy, there are 10 items at level one and 10 more each at level 2, so the multiplication gets out of hand fast (and the values change every so often). So IF statements as a psuedo-hash/error-correction isn't practical.

        This mostly feeds two offline systems (one for asset management and one for financial reconciliation) so it's easier for it to be corrected in those systems. We've also taught our PMs how to delete the custom form and start over when this happens (really bugs me to teach PMs these sorts of kludges, but...).

        Terms & ConditionsAccessibility statement

        Loading footer...