Skip to main content
Question

Checkbox values display as 1 and 0

  • November 7, 2019
  • 0 replies
  • 56 views
I have a number of fields that are Formula-Checkbox resulting in True or False. In Qbase tables, the values show as checkboxes and total nicely.
However, when Save as Spreadsheet, the yes/no of course does not total.
Is there anyway to set a Field Setting to make true, false show as 1 and 0 in Save as Spreadsheet but still show lovely checkboxes in Tables in Qbase?

------------------------------
Ruby Kapil
------------------------------

MarkShnierYou
Forum|alt.badge.img+22
  • MarkShnierYou
  • Quickbase Alumni
  • November 7, 2019
I think that you would need make mirror formula numeric fields for each checkbox field to change them to 0 / 1.

------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.com
markshnier2@gmail.com
------------------------------
Mark Shnier. Your Quickbase Coach
    • BabiPanjikar
    • Quickbase Alumni
    • November 8, 2019
    Make a formula numeric field and use that in your report for export.

    ------------------------------
    Babi Panjikar
    ------------------------------
      Forum|alt.badge.img+17
      • EvanMartinez
      • Community Moderator
      • November 8, 2019
      Hi Ruby,

      I would agree with Mark and Babi they are spot on, one of the easiest ways to do that is to create a formula numeric field that will convert the checkbox to a 1/0 value and then use that in exports. This way you maintain the nice visual checkbox field but your exports are in the values you need.

      ------------------------------
      Evan Martinez
      Community Marketing Manager
      Quick Base
      ------------------------------
        Terms & ConditionsAccessibility statement