Every record has the following system columns:

• Complete date
  • The date the submission was completed.
• Create date (Date_Created)
  • The date the submission was first sent.
• Form
  • The name of the form.
• Id
  • The unique identifier of the record. Unique across all forms and accounts.
• Index
  • The numeric identifier of the record. Unique for the form.
• Owner
  • The mobile number of the device the record was Sent to.
  • Or, the email of the user the record was Sent to.
• Receive date (Date_Received)
  • The date the record was first received by the system. Always after Create date.
• Sent by
  • The name of user that added the dispatch or submission.
  • Or, the name of the device that added or forwarded the submission.
• Sent to
  • The name of the device the dispatch is assigned to.
  • Or, the name of the device a submission was forwarded to.
  • Or, the email a submission was emailed to.
• Source
  • The mobile number of the device that the record was Sent by.
  • Or, the email of the user the record was Sent by.
• Start date
  • The date the record was added to the system.
  • Or, if the record is a Scheduled dispatch, the date the dispatch is scheduled to be started.
• Status
  • The current status of the record. See submissions and dispatches for possible Status values.
• Status date
  • The date the status last changed.
• Time zone
  • The name of the time zone of the device or user that created the record.