AnsweredAssumed Answered

Filter records by multi-selecting values for a field

Question asked by user28097 on Mar 10, 2015
Latest reply on Mar 10, 2015 by Mike_Mitchell

We have a table of people, each of whom are assigned one of 12 possible statuses (i.e. New Applicant, Screened, In Training, Trained, ...). I want to generate a report of people based on one or more statuses. For example, a list of people who are “Screened” and “Trained.”


One option I can use is a Drop-Down list that the user can multi-select the statuses they want (or a repetition field if a reasonable maximum number of choices), and then create a series of Finds that enumerate the list and extend the found set.


Are there simpler or better options anyone has used?


(I tried to post this earlier, but couldn’t find it. Sorry if double-posted.)