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.
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!