Customize your reports and e-mails with the tags

Each component of your form is defined by an item tag, for example ##contact##. The item tags represent the reference code for each element and allows you to customize your reports and your e-mails.

The item Tags.

To customize your Word, PDF, Excel files or your e-mails, you need to know the item tags of your element.

  • Click on the pencil Icone "Modifier" and go to the Help tab to find the item tags of your element. For example, the “date” element is defined by ##date##. You can note that the item tag always start and end with ##.

go to the Help tab to find the item tags of your element

  • Go to Options in the form and then to the Information tab to review all the item tags of your forms.

Go to Options in the form and then to the Information tab to review all the item tags of your forms

NB: You can also use the example provided by Kizeo (Option -> Export -> Add -> Word). The advantage of this example is that it includes all the item tags for your properly written form.

The item tags to customize your report.

To go further in the customization, you can use these following tags. You can find this list at the end of the Information tab.

/!\ The same typeface should be used for your tags (same colour, font and size).

Add general information
  • ##_last_name##: user’s surname
  • ##_first_name##: user’s first name
  • ##_phone##: user’s phone number
  • ##_email##: user’s email
  • ##_login##: user’s ID
  • ##_answer_time##: date of reply
  • ##_id##: unique identifier
  • ##_record_number##: n° of response to this form (identifier)
  • ##_answer_time##: date of response to the form.
  • ##audio##: allows you to obtain a link that returns to the audio.
  • ##attachment##: allows you to obtain a link that returns to the attachment.
  • ##list:label##: allows you to increase the wording (especially for the custom-made Excel that displays the code by default).
  • ##list:code##: allows you to increase the code (especially for the custom-made Word that displays the label by default).
  • ##_line_number:table1##: allows to display the line number ; table1 correspond to the tag id of the table.
  • ##field_id[n]##: allows you to retrieve the entry of an element of a specified row (n) in a table. If you have a checkbox in your table, for example, and want to retrieve its value on line 3, you can now use the ##checkbox[3]## tag.
  • ##field:caption##: allows you to retrieves the title of a field.
Date and time tags
  • ##datetime##: numeric format (01/01/2016).
  • ##datetime:short##: short text format (1er Jan. 2016).
  • ##datetime:medium##: medium text format (1 January 2016).
  • ##datetime:long##: long text format ( Friday 1 January 2016).
  • ##datetime:iso##: ISO format (2016-01-01).

‘datetime’  corresponds to the tag of your date and time field.

Geolocation tags:

Regular Geolocation tags
  • ##geoloc##: allows you to obtain the coordinates.
  • ##geoloc:latitude## and ##geoloc:longitude##: allow you to obtain latitude and longitude.
  • ##geoloc:link##: allows you to obtain a link that returns to the map when clicked.
  • ##geoloc:time##: allows you to obtain the time when the geolocation was taken.
  • ##geoloc:map-z12-200x200-satellite##: allows you to display a satellite map view on you customised export. Please note that this is the letter “X” and not the multiplication sign.
    « -200x200 » corresponds to the dimension of the image.
    « z12 » corresponds to zoom in/out on the word map.  To have an idea: 1 displays the word map and 18 displays the corresponding street. 12 displays more or less the neighborhood.
    « satellite » map type. The following map types are available: roadmap (the default road map view), satellite (Google earth satellite images), hybrid (a mixture of normal and satellite views) and terrain (displays a physical map based on terrain information).

Photo, drawing and signature tags:

Define the size of your images (photo, drawing and signature)

##id_element##: if one doesn’t want to define the size.
##id_element-heightxwidth##: if one wants to define the size.
##id_element-width##: if one wants to define just the width.
##id_element-xheight##: if one only wants to define the height.

/!\ To define the size of your images (photo, signature or drawing), you can choose to define the height and/or the width.  The undefined value is automatically defined to conserve the image’s proportions. For example, if you want a signature that appears in 100 pixel (height), you need to insert ##id_element-x100##.

Define the size of your multiple pictures, multiple drawings

##id_element:n##: if one doesn’t want to define the size.
##id_element:n-widthxheight##: if one wants to define the size.
##id_element:n-widthx##: if one wants to define just the width.
##id_element:n-xheight##: if one wants to define just the height.

n corresponds to the image’s number. Numbering starts at 1.
Tip: You can use a table to have a better presentation of you multiple pictures!

Display the date and time of your photos when they were taken

##photo:time##: allows you to obtain the date and time when the picture was taken.
##photo:time:short##: allows you to obtain the date and time in the short text format (1 Jan. 2016).
##photo:time:medium##: allows you to obtain the date and time in the medium text format (1 January 2016).
##photo:time:long##: allows you to obtain the date and time in the long text format (Friday 1 January 2016).
##photo:time:iso##: allows you to obtain the date and time in the ISO format (2016-01-01).

Display the date and time of your signatures

##signature:time##: allows you to obtain the date and time when signing your form.
##signature:time:short##: allows you to obtain the date and time in the short text format (1 Jan. 2016)
##signature:time:medium##: allows you to obtain the date and time in the medium text format (1 January 2016).
##signature:time:long##:allows you to obtain the date and time in the long text format (Friday 1 January 2016).
##signature:time:iso##: allows you to obtain the date and time in the ISO format (2016-01-01).

Geolocation display of your photos and signatures

##photo:latitude## and ##photo:longitude##: allows you to obtain the latitude and longitude when taking a picture.
##signature:latitude## and ##signature:longitude##: allows you to obtain the latitude and longitude when signing your form.

Note: please, tick the “Get the location automatically” checkbox in the options of your field in the Advanced tab.

Display a link of your photos and signatures

##photo:link##: allows you to obtain a link of your photo when clicked.
##signature:link##: allows you to obtain a link of your signature when signed.

Bar-code tags:

Bar code display in 128B format

##barcode:128##: if one doesn’t want to define the size.
##barcode:128-width##: if one wants to define just the width.
##barcode:128-height##: if one wants to define just the height.

Bar code display in QR code format

##barcode:qrcode##: if one doesn’t want to define the size.
##barcode:qrcode-widthxheight##: if one wants to define the size.
##barcode:time##: allows you to obtain the date and time when the information was taken.

Display your fields in 128B bar code or QR Code formats

The following fields are compatible with the bar code format:

  • Text field
  • text area,
  • Slider,
  • NFC tag,
  • Calculation,
  • Reference,
  • Counter.

##field:128##: to make its fields in QR Code Format.
##field:qrcode##: to make its field in 128B bar code format.

Check boxes tags:

Display of check boxes

##check_box:Yes:No##: to make Yes or No appear depending on whether the box is checked or not.
##check_box:☑:☐##:  to make ☑︎︎ or ☒ appear depending on whether the box is checked or not.

New: You can now define the display color of your check box depending on the response!

##check_box:Yes:##: check box is checked Yes in the color green.
##check_box:No:## : check box is checked No in the color red.

Display of lists, slider or choice field in the check box format

The syntax to make ☑︎ or ☐ appear before various list or field choice items, depending on whether they are selected or not is ##list-Element:☑︎:☐## . For example, you have a list containing the three following items: Train, Car and Airplane.

##list-Train:☑:☐##: to make ☑︎ or ☐ appear depending on whether the element Train is selected or not.
##list-Car:☑:☐##: to make ☑︎ or ☐ appear depending on whether the element Car is selected or not.
##list-Airplane:☑:☐##: to make ☑︎ or ☐ appear depending on whether the element Airplane is selected or not.
/!\  If your list items are word groups, it is essential to define a Code to be able to use certain item tags.

For instance (Code:item):

  • A: Tourist airplane
  • T: High-speed train
  • C: Race car

In our example, the syntax to make  ☑︎ when the value = “Race car” will be: ##list-V:☑︎:☐##

For more details, you may consult our tutorial: List with code.

List tags:

General list tags
  • ##list:code##: to display the code in your reports.
  • ##list:☑:☐##: to make ☑︎ or ☐ appear before various list, depending on whether they are selected or not.
  • You can define the display color of each item. For example, you have a list containing the three following items (Code:Item):
    – T:Train
    – C:Car
    – A:Airplane

/!\ It is essential to define a code to be able to use this item tag. For more details, you may consult our tutorial: List with code.

The following syntaxes will allow you to set a color for each item:

  • ##list-T:Train:##: if you want the Train item to appear in green when selected.
  • ##list-C:Car:##: if you want the Car item to appear in red when selected.
  • ##list-A:Airplane:##: if you want the Airplane item to appear in blue when selected.
Bullet-point list and line feed tags

You can use these following item tags with a list or choice field.

  • In a custom-made Word:

##list:break## and ##choice:break##: allow you to duplicate the row and maintain the chip format used.

  • In a custom-made Excel:

##list:break## and ##choice:break##: allow you to duplicate the row and maintain the chip format used.

##list:unordered## and ##choice:unordered##: to make an hyphen appears before list or choice field.

##list:ordered## and ##choice:ordered##: allow you to have your list or choice field in numerical order.

Hierarchical tags

Display of your Hierarchical Lists path:

You want to display all or part of your Hierarchical list‘s path in your custom-made Word/PDF or Excel report, the following tags allow you to do so:

As an example, let’s take the following hierarchical list:
FR-fr:France\83:Var\83700:Saint-Raphaël

  • The syntax to display the entire hierarchical path is: ##list:path##

In our example, « France / Var » will be displayed on the Word/PDF report.
In our example, « FR-fr / 83 » will be displayed on the Excel report.

  • The syntax to display the entire path as well as the label is: ##list:fullpath##

« France / Var / Saint-Raphaël » will be displayed on the Word/PDF report.
« FR-fr / 83 / 83700 » will be displayed on the Excel report.

  • The syntax to display each element of your list individually is: ##list:path-1##, ##list:path-2##, etc…

In your Word/PDF report:

  • ##list:path-1## will display « France »,
  • ##list:path-2## will display « Var ».

In your Excel report:

  • ##list:path-1## will display « FR-fr »,
  • ##list:path-2## will display « 83 ».

Tips:

  • It is possible to display the Code in all exports by using the following tags: ##list:pathcode-1## / ##list:fullpathcode##
  • It is possible to display the label in all exports by using the following tags: ##list:pathlabel-1## / ##list:fullpathlabel##

Display or delation of a table or a block of paragraph with the block tag:

/i\ It is only available in the custom-made Word/PDF.

General rules:

  • It can be configured with all fields.
  • It enables you to: display or hide a part of your Word document, which may contain text, tables, images, etc.
  • It is always built in two parts to frame the table or the block of paragraphs to make it appear or disappear: One tag before and the same tag after.
  • It does not work in the header of the Word document.

Configurations:

If a field is empty (no mobile entry) or invisible (due to visibility condition), you can choose to delete an entire part in your Word document or table with the block tag.

##_block:field##
Make part of the Word document disappear.
##_block:field##

For instance:

You have a table in your form. You do not want it to appear in you Word document if it is not completed during mobile or tablet entry. You must build your block tag in two parts, one before the table, to make it disappear if empty, and one, after this same table to frame it.

##_block:table##
Make part of the Word document disappear.
##_block:table##

Display of a block of paragraph in your custom Word document determined by a condition:

The block tag allows you to determine the visibility of a table or a block of paragraphs in you Word document based on the results of a list or choice field.

/!\ It is essential to define a code to be able to use this item tag. For more details, you may consult our tutorial: List with code.

Configurations:

##_block:list-Code##
Make part of the Word document appear.
##_block:list-Code##

If an other element will be entered, the block of paragraph will disappear.

For example:

You have a list with code containing these following items (Code:Item):

  • R:Red
  • G:Green

You want your block of paragraphs in your Word document to appear only if you have entered “Red” in your list. You must build your block tag in the following manner:

##_block:list-R##
Make part of the Word document appear.
##_block:list-R##

Display of a table or a block of paragraph determined by a field check box:

You want your block of paragraphs or table in you Word document to appear only if you have checked Yes in the check box. You must build you Block tag in the following manner:

##_block:check_box##(/code)
Make part of the Word document appear.
##_block:check_box##(/code)

You want your block of paragraphs or table in your Word document to appear only if you have checked No in the check box. You must build your Block tag in the following manner:

##_block:check_box-0## (-zero)
Make part of the Word document appear.
##_block:check_box-0## (-zero)

Note: It does not work in the header of the Word document.

 

 Do not hesitate to comment on this article!
All your questions, comments and suggestions are most welcome!

Post a comment

Your email address will not be published. Required fields are marked *