Forum Discussion

JonFroderberg's avatar
JonFroderberg
Qrew Cadet
3 days ago

Displaying Check Marks w/ Document Templates

If you recently started using the new Document Templates feature in Quickbase to generate pdf or Word documents, you may have noticed that checkbox fields on embedded table reports render as text strings "true" and "false", rather than the nicely formatted blue check mark symbol when viewing the table report natively in QB.

You can overcome this by using a report formula in the table report to render the check mark as a Unicode character.

If([Your Checkbox Field], "✓", "")

or

If([Your Checkbox Field], "☑", "☐")

document templates

1 Reply

  • Denin's avatar
    Denin
    Qrew Cadet
    2 days ago

    This is a great tip. I think another circumstance where this is helpful is if you print a report. On the print view of the report, likewise, checkboxes will be presented as "true" and "false" text strings which is not a great look and sometimes confusing for users.