Dropdown filtering based on CheckBox group

[Andrzej]

Hello!

I have to apply  auto filter on the dropdown field bsaed on the checkbox group.

For example when a person mark Java and Python in the next field only those two field should appear. I found similar topic but I don't know how the condition in "Filter to apply on a field" should look like.

[Alex Medved _ConfiForms_ · Accepted solution]

What field type is the field "Jezyk Glowny"? A multi-select?

[Andrzej]

"Jezyk Glowny" is a dropdown. The idea is to select one of the languages selected earlier in the checkbox field

[Alex Medved _ConfiForms_]

What should happen when you select multiple in the checkbox group field?

[Andrzej]

In the dropdown should appear a list with all checked fields in the checkbox. But I should chose only one option (that's why dropdown "Jezyk Glowny")

[Alex Medved _ConfiForms_]

id:[entry.Jezyki.transform(id).join( OR id:)]

[Andrzej]

It's working. Thank you!!

[Alex Medved _ConfiForms_]

Yes, it is a filtering expression

The condition of "Jezyki:true" - what is it? What is should do? Jezyki is a checkbox group, why do you check it to be with value "true"?

[Andrzej]

Can I filter similar way the related dropdown?

Let's say I have one dropdown with MPK and second with combined user+MPK. And I want to narrow output of the second field to the MPK choosen ealier. The condition would be similar? The fields are Database dropdown advance

id:[entry.Jezyki.transform(id).join( OR id:)]

This on the other hand is working but retrives only one person, while there might be many more so I need to render a list. 

id:[entry.ZrodloLimitu]

[Alex Medved _ConfiForms_]

Should not you filter the second dropdown by "MPK"? not by ID...

What is the SQL you have for the second dropdown? Do you select the "MPK" in the query?

[Andrzej]

.

[Alex Medved _ConfiForms_]

I think I have helped you with the very same on a different question you have asked...

Do you want to filter by the ManagerID?

[Andrzej]

yes, you're right but I switched to another form as I'm working on a few of them right now. The solution didn't work previously, so I left it. The case is similar I think as in the topic for checkbox.. and the solution for checkbox worked

I need to filter based on MPK. The output of 'WybierzWakat' (which is Name + MPK) should be narrow to the MPK choosen in 'ZrodloLimitu'

[Alex Medved _ConfiForms_]

I still dont get it - what FIELD in the SQL query is MPK?

[Andrzej]

MPK = [Employee MPK]

for the first filed it's ID as well as output of the field for the sceond field it is placed as a description e.g. Name + MPK (combined)

[Andrzej]

Is it clear now for you? 

[Alex Medved _ConfiForms_]

No, sorry

Give me the example of what selects the first query and what selects the second and how the second should be filtered out

[Andrzej]

It should be like this but with the list of all people with the chosen MPK (right now it's filtering only one which is incorrect)

[Alex Medved _ConfiForms_]

Give me the EXAMPLES

2 tables that show the subset of data with column names for EACH dropdown and show how the second dropdown should be filtered (using WHICH field from the query/table)

[Andrzej]

.

[Alex Medved _ConfiForms_]

I dont need your real data, I just want to understand what DATA do you get from those 2 queries

To be able to link them together and (finally) help (loosing my hope already)

[Andrzej]

.

[Alex Medved _ConfiForms_]

You know what a TABLE is, right?

I will give you an example

Assuming the first query returns (field name is field1)

SELECT DISTINCT mpk as id, name FROM SecretTable

id	name
1	MPK 1
2	MPK 2

And the second returns (field name in ConfiForms is field2) 

SELECT id, label, mpk FROM SecretTable

id	label	mpk
1	Hello	1
2	Beautiful	2
3	World	1

In order to filter the second dropdown I would have an "Apply filter on filed" rule with a filtering expression like

mpk:[entry.id]

Alex

[Andrzej]

anynone? 

[Andrzej]

@Alex Medved _ConfiForms_ maybe you could help?