Create an application with dynamic filter

[ByranCarter12]

Hello, 

I am trying to create an application to allow an user to select a list of field.

This list of fields is already configured in a file. The user will only need to choose the list.

I give you an example : 

Field	Product	Customer	Provider
ID_Product	True	True	True
Product_Name	True
Customer_Name		True	True
Customer_City		True	True
Customer_Country		True
Customer_ZIPCode		True
Provider_Name		True	True
Provider_City		True	True
Provider_Contry		True	True
Provider_ZIPCode		True	True

So, the user choose for example Customer, and where the value is True, that mean the Field would be on the result. 

In this way the user chooses one of the 3 possibilities (Product, Customer, Provider) and according to his choice, a filter will be applied if the field is included in the list or not (True, or empty).

My database look like this : 

ID_Product	Product_Name	Customer_Name	Customer_City	Customer_Country	Customer_ZIPCode	Provider_Name	Provider_City	Provider_Contry	Provider_ZIPCode
1	AAA	Peter	Mobile	USA	1000	John	Caldwell	USA	5200
2	BBB	Marc	Montgomery	USA	1001	Robert	Coeur d’Alene	USA	5201
3	CCC	Oliver	Opelika	USA	1002	Michael	Idaho City	USA	5202
4	DDD	Julian	Ozark	USA	1003	William	Idaho Falls	USA	5203
5	EEE	John	Phenix City	USA	1004	David	Kellogg	USA	5204
6	FFF	Hilary	Prichard	USA	1005	Richard	Lewiston	USA	5205

For example, the user choose the value "Provider " and the result will be :

ID_Product	Customer_Name	Customer_City	Provider_Name	Provider_City	Provider_Contry	Provider_ZIPCode
1	Peter	Mobile	John	Caldwell	USA	5200
2	Marc	Montgomery	Robert	Coeur d’Alene	USA	5201
3	Oliver	Opelika	Michael	Idaho City	USA	5202
4	Julian	Ozark	William	Idaho Falls	USA	5203
5	John	Phenix City	David	Kellogg	USA	5204
6	Hilary	Prichard	Richard	Lewiston	USA	5205
7	Smith	Paris	Joseph	Moscow	USA	5206
8	Parker	London	Thomas	Nampa	USA	5207

So I tried differents ways, for example a listbox with 3 values (Product, Customer, Provider) to give the choice to the user, and then apply a filter on the user's choice to keep only the fields that correspond to the value True. 

But it doesn't work.

There is also another difficulty is that I cannot transpose the columns from the database, because I have millions of rows

i don't know if i was clear about my purpose. 
Do not hesitate to ask me for more information.

Thank You.

[clmc9601]

Hi @ByranCarter12,

Have you considered using radio buttons?

This will work best if those columns you mentioned for the "Customer" option, "Provider" option, and "Product" option will be the same every time (please let me know if this is not the case). You would effectively put three radio buttons to enable or disable the corresponding select tool as I demonstrated in the attached app workflow. Don't be alarmed by the union tool-- it will be unioning the results of a single select tool with two empty ones. Hope this helps!

Thanks to this solution for the formula to use in the action tools!