Checkboxes in Exact Forms

  • 38
  • 1
  • Question
  • Updated 2 weeks ago
  • In Progress
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?
Photo of Derek Roush

Derek Roush

  • 98 Points 75 badge 2x thumb

Posted 2 weeks ago

  • 38
  • 1
Photo of Keith

Keith, Champion

  • 1,020 Points 1k badge 2x thumb
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
Photo of Derek Roush

Derek Roush

  • 98 Points 75 badge 2x thumb
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!
Photo of QuickBase Tools

QuickBase Tools

  • 22 Points
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