Built-in Data

Built-in Data

TABLE OF CONTENTS


Every form entry includes a number of built-in data fields that are available for use in your templates and connectors. Additionally, we provide built-in fields to access to some company-level settings like the name of your organization. Built-in values can be used in your templates by using the {{%BuiltInName}} syntax. For example, if you want to display the entry id as per the table below you would use {{%ENTRYID}}in your template or connector. The built-ins available are as follows:

Company Information

INTEGRATIONKEY
Inserts the integration key for the company. 

ORGID
Inserts the unique integer identifier of your company account on our platform. 

ORGLETTERHEAD
Inserts your organization letterhead image as set up in the Organization Setup. If no letterhead is found, the organization logo image is used (if any exists).

ORGNAME
Inserts the name of your company as setup in the Organization Setup.

User Information

USEREMAIL
Inserts the email address of the user that completed the form.

USEREXTERNALID
Inserts the external Id of the user that completed the form.

USERFIRSTNAME
Inserts the first name of the user that completed the form.

USERLASTNAME
Inserts the last name of the user that completed the form.

Entry Information

COMPLETELAT
Inserts the GPS latitude (in decimal degrees) of the user when completing the entry.

COMPLETELON
Inserts the GPS longitude (in decimal degrees) of the user when completing the entry.

COMPLETEMAP
Inserts a map image for the GPS co-ordinates of the user when completing the entry.

COMPLETETIME
Inserts the date and time that the user completed the Form entry (i.e. clicked upload in the app, regardless of connectivity). The correctness of this value is dependent on the users device time settings.

ENTRYGUID
Inserts the unique identifier string of this entry, without hyphens (i.e. 00000000000000000000000000000000). The identifier string is unique across all forms and all entries.

ENTRYGUIDFULL
Inserts the unique identifier string of this entry, including hyphens (i.e. 00000000-0000-0000-0000-000000000000). The identifier string is unique across all forms and all entries."

ENTRYID
Inserts an incremental calculated integer number for this form entry. The entry id for a specific entry is calculated as the current highest entry id for the form screen (all versions) plus one.

RECEIVEDTIME
Inserts the date and time that the form entry was received by our server. This may differ significantly from the "CompleteTime" value depending on the connectivity of the app.

STARTTIME
Inserts the date and time that the user started the form entry. The correctness of this value is dependent on the users device time settings.


    • Related Articles

    • FAQ- Data Captured

      Q: I have published a new Form version but I am still seeing some Data entries coming in against the old Form version. Shouldn't the users app have updated to the latest version automatically? A: The system will automatically update mobile users with ...

    • Platform Sync - Data Source Connector

      Platform Sync (previously known as Hosted GET) lets you set up a data source connector for any external database on any external system for which we do not have a live connector. While it is a bit more technical to configure, it does allow you to get ...

    • Nesting Repeatable Data - Nested Repeating Tables

      Capturing repeatable data using a repeating Table field is amazing, However, sometimes, you need to group data within other data, like putting a smaller box inside a bigger box. In the app builder, you can do this by nesting one Table Field inside ...

    • Pushing/Pulling Data To/From Other Systems

      One of the key features of our platform is the ability to "push" and "pull" data between the platform and other systems and services. This enables you to build apps and functionality that feature live business data. Examples of this can be jobs, ...

    • How can I pull/push data from/to other systems?

      1. Use one of our existing Connectors Generally, you can pull data into the platform using a Data Source Connector, while you can push data to another system using a Form Connector. We offer several pre-built Connectors for systems like Google Drive ...