Skip to main content
chriss4489
chriss4489
Known Participant
Apr 25, 2023 6:35 PM UTC
Question

Setting up Cascading Dropdowns between 2 dropdowns that are record lists

I have a Matters dropdown and a Sub Matters  dropdown that get their options from related tables. I want to make the choices in the Sub Matters dropdown dependent on the the selection in the Matters table. I know there needs to be a Query in the following expression section somewhere, however I am still trying to learn Appian and was hoping someone help me with the query and where to insert it..

    2 replies

    sanchitg0002
    sanchitg0002
    Inspiring
    Apr 25, 2023 7:32 PM UTC

    In the local!SubMatterType, filter all the records having PSLM miscMatterSubType.miscMatterTypeId equal to local!selectedMatterType.

    FYI,what you are trying to do at line 36 is not the correct way to save a value in a variable inside saveInto, instead use a!save(ri!variable, local!variable)

    harshitb6843
    harshitb6843
    Brainy
    Apr 26, 2023 6:38 AM UTC

    displayValue() should do the magic if you already have all the sub matters. 
    If not, you can select the Matter, pass that as a filter in subMatter's query and then use the output of the query to populate the choiceLabels and Values of subMatter dropdown! 

    Terms & ConditionsAccessibility statement