Forum Discussion

AlexGale's avatar
AlexGale
Qrew Captain
6 years ago

Summary report on a number of checkboxes

I have a table which contains a number of different checkbox fields. Any combination of those fields can be checked on each record.

I want to create a report which totals the number of records on the table for which each checkbox field is checked. Ideally I would also be able to drilldown on each different checkbox field. Is there a way to do this?
App builders
reports and charts
Tips and tricks
  • EvanMartinez's avatar
    EvanMartinez
    Quickbase Staff
    6 years ago
    Hi Alex,

    For your summary report on the number of checkboxes would you want it to show each checkbox as an option and then the number of records that have that checkbox checked with the ability to click on that and see the full list of record or are you looking for a summary that calls up each possible combo and how many records land in each combination?
    • AlexGale's avatar
      AlexGale
      Qrew Captain
      6 years ago
      Hi Evan, 

      I don't need every possible combo, I just want it to show the number of records that have each checkbox checked with the ability to click on that and see the full list of records.
    • EvanMartinez's avatar
      EvanMartinez
      Quickbase Staff
      6 years ago
      Hi Alex,

      Typically a summary report will try to break down each combo possible in the fields added.When it can be a number of different checkbox fields I have created reports by making use of a master parent record. Essentially I create a table with 1 record in it that is my master record. Then I relate all the records in my original table to that one record in the master parent table. Then you can create a summary field that gives you number of records that have a specific checkbox. Then you can add as many summary fields as you need to match up to every checkbox. Then you have a report which will just have each checkbox count and clicking into the totals will take you to a report filtered down to just those records. 

      For getting them all related I usually make a formula numeric field and set the formula to just be a value of 1. Then I change the field type over to a numeric field with a default value of 1 so any future records will be automatically related. This way you can get a report that is narrowed down on just what you are looking at. It will just live in that master parent reporting table. I hope this suggestion is helpful Alex.