Checkboxes in Exact Forms

Question

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?

KeithJusas · Answer

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 fieldIf ([Checkbox],"","[ ]")Option 2 - Advanced - formula rich text field with html codesIf ([Checkbox],"☒","☐")Option 3 - Advanced - formula rich text field with image linksIf ([Checkbox],"

";,"

")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/bknf8jnuyGood Luck!Keith

Sign up

Login to the community