Forum Discussion

MeaganMcOlin's avatar
MeaganMcOlin
Qrew Cadet
2 months ago
Solved

Checkbox Fields Vs Multi-Select Fields for Tracking

Hi, I have a table with physicians and the advanced privileges they may have. There are 9 advanced privileges (there could be a few more down the line), and each physician may have a unique combination of these privileges.

I’m trying to decide whether to store each privilege in its own checkbox field or use a multi-select field where you can choose the privileges that apply.

I like the multi-select approach because it’s more compact, but my concern is that I need to be able to select a single privilege from the list of 9 and see all the physicians who have that privilege. I'm not sure how to do that with a multi-select field.

Can anyone advise on the best way to set this up?

Thanks!

  • I think a multi select field is the way to go. It can be used as a Dynamic Filter on reports and can also be used as a regular filer on a report.

  • I think a multi select field is the way to go. It can be used as a Dynamic Filter on reports and can also be used as a regular filer on a report.

    • MeaganMcOlin's avatar
      MeaganMcOlin
      Qrew Cadet

      Mark,

      You’ve been a lifesaver! I will now go and learn how to use the multi-select field as a filter in a report. :) Great to know that’s possible!