Discussions

Expand all | Collapse all

Report of Only Checkbox Fields That Are Checked

  • 1.  Report of Only Checkbox Fields That Are Checked

    Bronze
    Contributor
    Posted 4 days ago
    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
    ------------------------------


  • 2.  RE: Report of Only Checkbox Fields That Are Checked

    Posted 4 days ago
    So you now have 1,776 fields?

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



  • 3.  RE: Report of Only Checkbox Fields That Are Checked

    Bronze
    Contributor
    Posted 4 days ago
    ​Yes

    ------------------------------
    Adam Keever
    ------------------------------



  • 4.  RE: Report of Only Checkbox Fields That Are Checked

    Posted 4 days 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
    ------------------------------



  • 5.  RE: Report of Only Checkbox Fields That Are Checked

    Bronze
    Contributor
    Posted 4 days ago
    Thanks Mark.

    ------------------------------
    Adam Keever
    ------------------------------