These functions are only used within a Word Template (docx) or Excel Template (xlsx) compatible format.
Function |
Name |
Description |
{{ [DataName] }} |
Data Name | Returns the result of the given Data Name of the form field. |
{{!HIDEIFSTART( [True/False] )}} |
HIDEIFSTART | Hides a section dependent on the result. Result must return a True or False.{{!HIDEIFSTART( {{myoption}} = ‘No’ )}} |
{{!HIDEIFEND}} |
HIDEIFEND | Must include HIDEIFEND when using HIDEIFSTART |
{{!HIDEROWIF( [True/False] )}} |
HIDEROWIF | Hides a row dependent on the result. Result must return a True or False.{{!HIDEROWIF( string-length({{chosenproduct}}) = 0 )}} |
{{!REPEATSTART}} |
REPEATSTART | This is inserted at the beginning of a section enclosing repeating Data Name fields. |
{{!REPEATEND}} |
REPEATEND | This is inserted at the end of a section enclosing repeating Data Name fields. |
{{!REPEATROW}} |
REPEATROW | This is inserted at the beginning of a row enclosing repeating Data Name fields. |
{{!REPEATROW|[val]}} |
REPEATROW|[val] | This is inserted at the beginning of a row enclosing repeating Data Name fields ‘val’ number of times. |
{{(CBOX(val, matchTo))}} |
To CheckBox (Ticked or Crossed) | Returns a Unicode checkbox that is ticked or crossed, depending on whether val equals matchTo. e.g. CBOX({{myfield}}, ‘Yes’) outputs ☑ or ☒ NB – you must set the font to Segoe UI for this to work properly. |
{{(CBOXB(val, matchTo))}} |
To CheckBox (Ticked or Blank) | Returns a Unicode checkbox that is ticked or blank, depending on whether val equals matchTo. e.g. CBOXB({{myfield}}, ‘Yes’) outputs ☑ or ☐ NB – you must set the font to Segoe UI for this to work properly. |
{{%ORGNAME}} |
ORGNAME | Inserts the name of your organisation as setup in the Organisation Setup. |
{{%ORGLETTERHEAD}} |
ORGLETTERHEAD | Inserts your organisation letterhead image as setup in the Organisation Setup. If no letterhead is found, the organisation logo image is used (if any exists). |
{{%ENTRYID}} |
ENTRYID | Inserts the integer number of this entry. The number is unique by Form code |
{{%ENTRYGUID}} |
ENTRYGUID | Inserts the unique identifier string of this entry. The identifier string is unique across all Forms and all entries. |
{{%USERFIRSTNAME}} |
USERFIRSTNAME | Inserts the first name of the user that completed the Form |
{{%USERLASTNAME}} |
USERLASTNAME | Inserts the last name of the user that completed the Form |
{{%USEREMAIL}} |
USEREMAIL | Inserts the email address of the user that completed the Form |
{{%USEREXTERNALID}} |
USEREXTERNALID | Inserts the external Id of the user that completed the Form |
{{%STARTTIME}} |
STARTTIME | Inserts the date and time that the user started the Form entry |
{{%COMPLETETIME}} |
COMPLETETIME | Inserts the date and time that the user completed the Form entry |
{{%COMPLETELAT}} |
COMPLETELAT | Inserts the GPS latitude (in decimal degrees) of the user when completing the entry |
{{%COMPLETELON}} |
COMPLETELON | Inserts the GPS longitude (in decimal degrees) of the user when completing the entry |
{{%COMPLETEMAP}} |
COMPLETEMAP | Inserts a map image for the GPS co-ordinates of the user when completing the entry |