Applying filter criteria on data list based on multiple attributes having custom select list
I am trying to achieve filtering data list (shipment data) based on two filters - carrier name and status of shipment.
Both the attributes are custom list type where user can select one or more than one values. Based on selection, user will able to see data from the data list after user clicks on "Find" button. Screen attached as attachment.
Case1: user selects carrier as UPS
Case2: user selects carrier as UPS and FedEx
Case3: user selects carrier as UPS and status as "Intransit" and "Delivered".
How to define my filters to achieve this?
Thanks.
Files:
MultiFIlter.png
We can add some conditions that will check to see if anything is selected in the checkboxes, which will allow you to filter for one of the checkboxes. We've added 4 conditions, here's what they do:
1. Checks to see if nothing is selected in both checkboxes, and will show a 'nothing selected' text if so.
2. Checks to see if the Status checkbox has something selected and if the Reason checkbox is not. If so, it will filter only according to the Status checkbox.
3. Checks to see if the Status checkbox has nothing selected, and if the Reason checkbox does. If so, it will filter only according to the Reason checkbox.
4. Checks to see if both are selected, and will filter according to both checkboxes.
Hope this helps! Please let me know if you have any questions about it.
We can add some conditions that will check to see if anything is selected in the checkboxes, which will allow you to filter for one of the checkboxes. We've added 4 conditions, here's what they do:
1. Checks to see if nothing is selected in both checkboxes, and will show a 'nothing selected' text if so.
2. Checks to see if the Status checkbox has something selected and if the Reason checkbox is not. If so, it will filter only according to the Status checkbox.
3. Checks to see if the Status checkbox has nothing selected, and if the Reason checkbox does. If so, it will filter only according to the Reason checkbox.
4. Checks to see if both are selected, and will filter according to both checkboxes.
Hope this helps! Please let me know if you have any questions about it.
Check out the attached prototype, which builds on this example. The first checkbox list is used to filter the Data List using the Data Master's value, and the second checkbox list filters the result of that filter.
Check out the attached prototype, which builds on this example. The first checkbox list is used to filter the Data List using the Data Master's value, and the second checkbox list filters the result of that filter.
Replies have been locked on this page!