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!
Solved
Checkbox Fields Vs Multi-Select Fields for Tracking
Best answer by MarkShnierYou
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.
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US β quickbase.com Login with Quickbase EU β quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.