Checkboxes in Exact Forms | Discussions

Expand all | Collapse all

Checkboxes in Exact Forms

  • 1.  Checkboxes in Exact Forms

    Posted 11-29-2018 00:56
    I can't figure out how to show checkbox fields on an Exact Form, they show up as the values Yes or No. The general mail merge solution I found is to use IF statements with Wingdings checkbox objects, but it doesn't look like merge formulas work in Exact Forms. Is there another way to include checkbox fields on Exact Forms?


  • 2.  RE: Checkboxes in Exact Forms

    Posted 11-29-2018 21:35
    Hi Derek,
    you can use formula fields in Quick Base instead.  Create a formula field and reference that formula field in your Exact Form Template instead of the actual checkbox field.

    Option 1 - Simple - formula text field

    If ([Checkbox],
    "[X]",
    "[  ]")

    Option 2 - Advanced - formula rich text field with html codes

    If ([Checkbox],
    "☒",
    "☐")

    Option 3 - Advanced - formula rich text field with image links

    If ([Checkbox],
    "<div><img src=\"https://images.quickbase.com/si/16/211-check_all.png\"></div>";,
    "<div><img src=\"https://images.quickbase.com/si/16/804-button_1.png\"></div>")

    You can use whatever images you want..i just tried to find 2 from the Quick Base public images app, not the best images but its more to show you the concept

    -----------------------------------------------------------------------------------------------

    When Checked...

    When Unchecked...


    And when you get tired of fighting with Exact Forms, try Exact Forms Plus!
    https://juicedtech.quickbase.com/db/bknf8jnuy

    Good Luck!
    Keith


  • 3.  RE: Checkboxes in Exact Forms

    Posted 11-30-2018 16:16
    I ended up using Option 2, it worked but was pretty cumbersome to duplicate 25 checkbox fields into formulas.  We'll probably come around to Exact Forms Plus eventually.  Thank you for the help!


  • 4.  RE: Checkboxes in Exact Forms

    Posted 11-30-2018 16:32
    Glad it worked...sorry for the extra work.

    With Exact Forms Plus you could just reference the checkbox fields, no need to make the additional fields.  EF+ will convert the "Yes","No" to a checked or unchecked box

    Keith