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?
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], "", "[ ]")
Option 2 - Advanced - formula rich text field with html codes
If ([Checkbox], "☒", "☐")
Option 3 - Advanced - formula rich text field with image links
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
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!
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