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