Forum Discussion

AdamKeever1's avatar
AdamKeever1
Qrew Commander
6 years ago

Report of Only Checkbox Fields That Are Checked

To quickly capture opinions on a long list of key words (1,776 words), I imported the words as field titles for checkbox fields.

This allows a user to quickly check words that they agree are key.

My problem is the reporting portion. I want to create a report with only the fields that have been checked and show a summary of the number of checks.

Any suggestions?

------------------------------
Adam Keever
------------------------------
    • AdamKeever1's avatar
      AdamKeever1
      Qrew Commander
      6 years ago
      ​Yes

      ------------------------------
      Adam Keever
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Icon for Qrew Legend rankQrew Legend
        6 years ago
        You should be able to use the import export menu to 
        Export a table to a file

        Then it will be in Excel.
        The use the =COUNTIF(B2:B1776,"yes") function to count up the yes values for each field name.

        The you actually have a count by Key word and if you want to get that back into Quick base you could copy paste special and use the "Transpose" option to get a vertical list of field names and their counts, and that can be imported back into a Quick Base table
        table.



        ------------------------------
        Mark Shnier (YQC)
        Quick Base Solution Provider
        Your Quick Base Coach
        http://QuickBaseCoach.com
        markshnier2@gmail.com
        ------------------------------