2 forms, one uses fields from another and have them filtered with Apply Filter rule

[Dieter Hoppek]

I am using the functionality based on the example.

wiki.vertuna.com/spaces/TEST/pages/21234088/2+forms+one+uses+fields+from+another+and+have+them+filtered+with+Apply+Filter+rule

Unfortunately, filtering doesn't work.

Maybe someone can help

[Dieter Hoppek]

Many thanks for the video. The problem was sitting in front of the screen. I had a spelling mistake and used a round bracket instead of a square bracket. Now it works.

[Alex Medved _ConfiForms_]

Hi @Dieter Hoppek 

Will you provide the details you have and what doe snot work for you if you followed the example in our wiki

Thanks

Alex

[Dieter Hoppek]

I have a table with the following values:

Collum 1 Collum2

a - 1

a - 2

b - a

b - b

c - z

If I choice in the Form in a field (smart dropdown) the value a, so in the secound field in the form I should see only the options 1 and 2. But I see all options. 

[Dieter Hoppek]

[Alex Medved _ConfiForms_]

For this, particular case... may be you can just switch to the smart classifier which will do this for you automatically?

[Dieter Hoppek]

[Dieter Hoppek]

But then I am missing the selection options that are available in the reference table as a dropdown in the field.

Maybe I didn't understand you correctly.

[Alex Medved _ConfiForms_]

May be a video helps?

[Dieter Hoppek]

Thank you very much. It's great. I am going tr try it in the next week.

[Dieter Hoppek]

I have chosen the variant again. 

wiki.vertuna.com/spaces/TEST/pages/21234088/2+forms+one+uses+fields+from+another+and+have+them+filtered+with+Apply+Filter+rule

 It works now. I would like use a multi select field. If I select two of three options, the corresponding values of the subcategory should be filtered.

Do you have any advice on this?

[Alex Medved _ConfiForms_]

What filter do you have now?

You will need to construct something with "join" function https://wiki.vertuna.com/spaces/CONFIFORMS/pages/2359385/Virtual+functions

to make it work for multiple selected values in the first field

[Dieter Hoppek]

I use Confiforms Rules for Field Definition. In the field "Filter to apply on a field" is the references to the multiple selected value.

If the selection is a and c, the result of this selection in the sub category should be 1,2 and z.

Collum 1 Collum2

a - 1

a - 2

b - a

b - b

c - z

[Alex Medved _ConfiForms_]

I dont quite understand this anymore, sorry

Is this a form where you store the possible options?

Extending a video I have shared previously