• Spring naar de hoofdnavigatie
  • Door naar de hoofd inhoud
  • Spring naar de voettekst

Taskform: De flexibele app voor uw bedrijfssoftware

|

023-2340999

|

info@taskform.nl

|

Knowledge Base

|

Remote Support

|

LOG IN

Logo Taskform

TaskForm

De flexibele mobiele app voor uw bedrijfssoftware

  • Home
  • Hoe werkt Taskform?
    • TaskForm Data Connector
    • TaskForm Appbuilder ™
    • Taakbeheer
  • Voorbeelden
    • Werkbon app
    • Werkplekinspectie app
    • Urenregistratie app
  • Referenties
    • Proteus apps
    • Factuursturen apps
  • Prijzen
  • Blog
Gratis Proberen

Outputting Checkboxes, Hyperlinks and Other Special Characters (Unicode support)

Taskform > Outputting Data with Templates > Outputting Checkboxes, Hyperlinks and Other Special Characters (Unicode support)
Welcome to our Knowledge Base

Often you will have scenarios where you want to output checkboxes in your template with a tick or a cross corresponding to the answers in a Choices field of your form design.

Or maybe you want to include links to content or files captured in the Form entry.

And if you are using non-English languages, you’ll probably have cases where you need Unicode support to display text.

The way you do this in a Data Template is to use formula functions and Unicode characters to output the desired symbols.

Outputting Hyperlinks

Our LINK formula function makes it easy to output a Word/Excel hyperlink that can be clicked to navigate to a URL.
These links also carry into PDF outputs.

Here’s an example of LINK in action:

{( LINK(‘Go to Google’, ‘https://www.google.com’) )}

This will output a link like this: Go to Google

Outputting Check Boxes

Our template engine has built-in support for outputting checkboxes via the CBOX formula function.

For example, let’s say you want to output a ticked checkbox when the answer to a field is (or in the case of multiple selections, contains) ‘Yes’, and a crossed checkbox if not.

Use the following formula in your Data Template to do so:

{( CBOX({{myField}}, ’Yes’) )}


This will output one of the following:

☑ ☒

If you want to display an empty (i.e. not crossed) box when the answer does not match the specified result, then use the CBOXB function:


{( CBOXB({{myField}}, ’Yes’) )}


This will output one of the following:

☑ ☐


Change the font size or font weight (e.g. bold) of your formula text to set the display size of the output symbol.



Outputting Unicode characters


IMPORTANT! 
YOU MUST USE THE FONT Segoe UI Symbol TO OUTPUT SPECIAL SYMBOLS


APPLE MAC USERS: Currently Segoe UI Symbol is not available for Mac OSX – you MUST use a Windows PC to apply the font to your templates.

A full list of all supported characters for Segoe UI Symbol can be found here:

http://www.kreativekorp.com/charset/font.php?font=Segoe%20UI%20Symbol

Note the Unicode number under each symbol in the link above – this is the value you can use in formula functions that output values.

{( IF({{myField}} =’Yes’, ‘\u263A’, ‘\u263C’) )}


Assuming the section where the above formula appears is set to use Segoe UI Symbol font, then you could expect to an output of (either or):

☺ ☼

Change the font size or font weight (e.g. bold) of your output formula to change the display size of the symbol.

Non-ASCII languages such as Chinese

Our platform has extensive Unicode support given our Windows operating system base, however, only specific fonts can be supported.

By default the fonts found at this link are all supported:

https://docs.microsoft.com/en-gb/typography/font-list/

When creating a Word or Excel template, you need to be mindful of the specific font you use for your Unicode areas.

If you use a font that is not in the supported list above, you will find that the generated output has unpredictable results – usually missing characters in your output.

Tags:
  • Outputting Data with Templates
Geïnteresseerd om gratis te proberen?

Laat uw gegevens achter en probeer onze app 30 dagen gratis.

Footer

Blog

  • Taskform wordt zelfstandig bedrijf en verwelkomt nieuwe directeur
  • Parijs Release: Innovatieve en Diverse Functies
  • Kopenhagen Update: Focus op Tijd Besparing
  • Berlijn update: Mobile app met OCR en Netsuite Koppeling
  • Roma update: Verbeter je apps

Support

Knowledge Base
Contact

Contact

info@taskform.nl
+31 023 2340 999

App store downloads

Download-Taskform-Android-app Download-Taskform-Apple-app