Skip to main content
Question

Multi-Select Field in Reports

  • Oct 13, 2022 6:42 AM UTC
  • 0 replies
  • 106 views

Hi all,

I would like to use Multi-Select Fields in reports but I would like to have the data separated, as if they were used as tags.

As an example say I have three sites and for each site I do maintenance but on the one site I only do maintenance on the UPS and PSUs, while for another I do UPS and ISP and another I do ISP and On-Site, such that:
Site 1: UPS, PSU
Site 2: UPS, ISP
Site 3: ISP, On-Site

Currently if I use the multi-select field in reporting, I'd get:
UPS, PSU: 1
UPS, ISP: 1
ISP, On-Site: 1

But what I want is:
UPS: 2
PSU: 2
ISP: 2
On-Site: 1

Is there anyway for me to separate the multi-select field into it's separate texts? 

Thanks in advance!

------------------------------
Aylana Vorster
------------------------------
This topic has been closed for replies.

MarkShnierYou
Forum|alt.badge.img+24
If you use the field as a dynamic filter, you can isolate each one on a report.  But fir the reporting you actually want, you would need to have a relationship and a Many to Many join table.

one site has many equipment assignments
one equipment has many equipment assignments and your reporting would be off the equipment assignments table.

------------------------------
Mark Shnier (Your Quickbase Coach)
mark.shnier@gmail.com
------------------------------