nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

How do I get a Smart Dropdown to JOIN based on another dropdown?

Kathleen Janiszewski_e5imvw

I have a ConfiForm full of fiscal years, week numbers and text for each week that I want displayed on a smart dropdown. Right now, I have all of the weeks for FY 2023 and FY 2024 in there.

weeks confiform.PNG

I also have a dropdown with the fiscal years hardcoded in the dropdown:

I want the smart dropdown to populate with the week titles (there could be 52 or 53 of them) depending on the fiscal year. How can I do a JOIN from the fiscalYear field to the Fiscal Year of the smart dropdown? I have tried a smart classifier, but this won't work, because they're in different div's. I tried a filter, and that did not work. Any ideas?

Accepted answers

Alex Medved _ConfiForms_

Hi @Kathleen Janiszewski

The easiest way is just to put a smart classifier field in the form that will use your weeks form as a source.

No need to join anything

First field in the smart classifier would be the year and the second would be the week number or the week range

Other option is to set up 2 fields, one to source the data from years form and another from the weeks form and use the https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Field+Definition+Rules#ConfiFormsFieldDefinitionRules-ApplyFilteronafield rule to filter out items from the second field (weeks) based on the selection being made in the first (year)

Alex

All comments

Alex Medved _ConfiForms_

Hi @Kathleen Janiszewski

The easiest way is just to put a smart classifier field in the form that will use your weeks form as a source.

No need to join anything

First field in the smart classifier would be the year and the second would be the week number or the week range

Alex

Kathleen Janiszewski_e5imvw

Alex,

The Fiscal Year is at the top, and the Start Week and End Week are in a 2nd div that is hidden and unhidden based on the next value, which is a radio button. Is it possible to use a smart classifier when the dropdowns are not sequential? According to my colleague, it's not. This is what my registration form looks like: Registration form.PNG
Thank you for your help here!

-Kathleen J

Alex Medved _ConfiForms_

Hi @Kathleen Janiszewski

Not sure what do you want to show with this screenshot, but your colleague is right - the smart classifier field cannot be split into multiple pieces. It is just one field - it can be rendered as an N number of (cascading) dropdowns (selects), but it is still a 1 field.

Alex

Kathleen Janiszewski_e5imvw

Alex,

Sorry to have blacked out so much. The user selects the fiscal year. The next field is a radio box which I'll call, "type." Depending on "type", the bottom div will display or not display. The Fiscal Year is relevant for all types. The Start Week and End Week are only relevant for 1 type.

Yes, the 2nd method you had recommended is the one I was going with. I wasn't able to get it working. Perhaps my filter is incorrect. Or perhaps I need to put the years in their own form rather than having them hardcoded. I can do that, but the value and text are the same: years 2023 thru 2030. However, I doubt they'll be using this software beyond FY 2026.

Thank you again for your help!

-Kathleen

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server

confiforms