Checkboxes in Exact Forms
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, ...
Forum Discussion
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
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
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
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
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!
