AnsweredAssumed Answered

Structure of Multiple Finds (refining results)

Question asked by bbringardner on Jun 22, 2014
Latest reply on Jun 24, 2014 by bbringardner

I would like to create functionality which allows the user to filter a list based on the contents of the list and then further refine it based on a selecton from a second field (and a third and fourth). I have been able to do this for single single field and for multiple fields, but only when entered in a redetermined order. I would like to be able to allow the user to select up to four terms in any order. I get stuck when establishing the "Find Records" because I must indicate a specific field to search, which is okay if the order in which the finds are going to occur is predetermined, but since they are not it poses a problem.

 

Here is an example of what I would like to do:

 

Field1 Field2 Field3

a c e

a b e

a b e

ff b j

 

If the user clicks on "a" in field 1 the list fileters to be:

Field1 Field2 Field3

a c e

a b e

a b e

 

then if the user clicks on "c" in field 2 the list fileters to be:

Field1 Field2 Field3

a c e

 

I would like to get the same result if they selected the same records, but in a different order as well.

 

 

Thanks in advance!

Ben

Outcomes