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 ☒
{{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 ☐
{{%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

 

Data Conversion. format-num(). today(). Template Functions. string(). Repeating Data in Word/Excel. tan(). ‘.’ (dot). tanh(). Using Word/Excel Comments To Preserve Template Formatting. Built In Data for Templates. utcnow(). Location Functions. sinh(). sqrt(). pi(). Excel Financial Functions. globalval(). Choices Functions. Functions.