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

 

‘.’ (dot). round(). userexternalid(). asin(). Adding an SPF Record. utcnow(). Location Functions. string(). useremail(). imgurl(). orgname(). Logic. atan(). Advanced Math. Functions Table. cos(). boolean(). Contextual Functions. Template Functions. Repeats.