How to establish cascading check boxes/multi select in confluence form?

[sumer bhalla]

I have two smart multi selects. These are backed by a table view.

One for GENRE (Fruits, Vegetables, Dairy).

Other one for corresponding values (Apple, Banana, Carrot, Peas, Milk, Eggs).

Based on my selection on first multi select, values in second multi select should show.

Condition: My user has to select multiple genres.

Filtering is working fine, if user selects just one option in genre.

I need filter to work when two options are selected. For example: if Fruits and Vegetables both are selected in first multi select, second one should show (Apple, Banana, Carrot, Peas).

Goal: idea is to restrict user to select from available options only. I don't want my user to be selecting eggs, if user is looking for fruits or vegetables.

Note: I am a naive user here. Looking for a easier approach.

[Alex Medved _ConfiForms_ · Accepted solution]

Hi @sumer bhalla 

Added some labels to the question, so it would be easier to understand that it's ConfiForms related

From the original question it is rather difficult

Anyway, have a look at this video I have recorded for you

Hope it helps

Alex

[sumer bhalla]

Thanks @Alex Medved _ConfiForms_  it worked perfectly fine. Do you have any page listing such syntax?

Another issue: I want to use the info value attached to this record. Where info is the third column in the table. Below syntax is not working. OptionInfo is the text field to show the info value.

OptionInfo:[entry.OptionSM.Info]

[Alex Medved _ConfiForms_]

What the "OptionInfo:[entry.OptionSM.Info]" should do? What are you trying to filter and where?

[sumer bhalla]

I am trying to get the value from third column of the table. I have to show it in a text field on the form as well as our it on the JIRA issue.

Basically selection of Genre and Option will filter out the info.

[Alex Medved _ConfiForms_]

What it should show when you have multiple Options selected?

[sumer bhalla]

It should concatenate the values in Info column, and put it on the text field as well as in the JIRA.

[Alex Medved _ConfiForms_]

OK, something like this then

[sumer bhalla]

@Alex Medved _ConfiForms_ 

I need to print "Eggs Info; Milk Info" in Option Info field.

1. How will it filter out the value from Info based on Option selected? Because i have tried Set value ruke and used this under Values to set OptionInfo=[entry.OptionSM.Info], but it is not working.
2. Where should i put OptionSM.transform(info).asList?
3. How can I fetch the Info values to put in JIRA issue while creating it?

Basically i want to do following:

Set OptonInfo = (Value from Info column) where Genre is selected Genre and Options are selected Options.

[Alex Medved _ConfiForms_]

Honestly, makes no sense to me, but you can use the iterateAnPrint function, for example

OptionsSM.iterateAndPrint([entry.Options] [entry.Info] )

 I do show exactly on my screenshots where to put  these things...

Anyway, if you still want to have something like a Set Value rule... (and copy values over, insted of referencing them realtime) then 

the expression for the parameters would be

OptionInfo=[entry.OptionsSM.iterateAndPrint([entry.Options] [entry.Info] )]

[sumer bhalla]

Let me rephrase the ask.

I want to get the value from Info column and set to a text field OptionsInfo, based on the selections made on Genre(GenreSM) and Options(OptionsSM).

[Alex Medved _ConfiForms_]

I get that - I have no idea why would yo do that... but OK, you can see my previous comment that answers your "ask"

[sumer bhalla]

@Alex Medved _ConfiForms_ 

I guess i got the solution.

Issue: I was not able to get the value from Info column using OptionInfo=[entry.OptionSM.info]

Reason: Reference to records checkbox was not checked for OptionSM

Lesson: Reference to records checkbox need to be checked, if user wants to filter out the Info from third column, based on selections made on first two columns.

Observation: If Reference to records checkbox is checked, and Option column has same value for two different Genre, then form will display that same value twice. And user has to select both to get the Info. 

[sumer bhalla]

Thanks a lot @Alex Medved _ConfiForms_ 

[sumer bhalla]

@Alex Medved _ConfiForms_ Can you help here? Thanks in advance.

[Radek Dostál]

Well, clearly this isn't native, it's custom, thus it's more for https://community.developer.atlassian.com

Whoever has made those html forms knows how the select lists (which seems like select2, most likely atlassian aui select2 fork) are set up, and there will be something in javascript that makes the current filtering work.

That depends on how those select2 fields are set up to do searches - whether it's server-side, where you would need to make the filtering inclusive for multiple options, or whether it's client-side, in which case, the javascript code needs to be made inclusive for multiple options.

Can't suggest anything concrete without seeing either the javascript or the backend filtering api method.

[sumer bhalla]

@Radek Dostál Can you explain in simple words? Are you saying that behavior of these multiselect is done at organizational/admin level?

I am using ConfiForms Field Definition and ConfiForms rules for Field Definition.

And here multiselect behaving with AND condition between Dairy and Veggies. I want it to behave with OR condition between Dairy and Veggies.

[John Funk]

Hi Sumer - Welcome to the Atlassian Community!

Can you share a screenshot of what you have? 

[sumer bhalla]

@John Funk screenshots added

[sumer bhalla]

@Alex Medved _ConfiForms_ any help?