System Fields
Introduction
Feature(s)
System fields include submission information fields, workflow information fields, the URL parameter, and so on. System fields are automatically generated or accessed by the system, and they cannot be edited.
Application Scenario(s)
- In the case of viewing form data, you can filter data by system fields.
- In the case of designing a dashboard, you can select system fields as dimensions or measures to calculate data.
- In the case of using aggregate tables, you can select system fields as filters.
Submission Information Fields
Submission information fields include Created User, Created Time, and Updated Time.
Created User
A created user refers to the person who submitted the form data. If data is collected by the public link, the created user is not available.
How to View: In Manage Data/Permission Set, you can view the Created User field in the form data.
Taking a permission set as an example, you can switch the permission set to view/manage data and tick Created User in Display Fields to view fields in the form data.
Created Time
Created Time refers to the time when the form data is submitted, which is accurate to the second.
How to View: In Manage Data/Permission Set, you can view the Created User field in the form data.
Taking a permission set as an example, you can switch the permission set to view/manage data and tick Created Time in Display Fields to view fields in the form data.
Updated Time
Updated Time refers to the time when the form data was last modified. If the form is not modified after submission, the Updated Time is the same as the created time.
How to View: In Manage Data/Permission Set, you can view the Updated Time field in the form data.
Taking a permission set as an example, you can switch the permission set to view/manage data and tick Updated Time in Display Fields to view fields in the form data.
Where to Call
Submission information fields can be retrieved in the following scenarios:
Scenario/Field | Created User | Created Time | Updated Time |
Field Initial Value |
|
|
|
Multi Select Options | / | Lookup | Lookup |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
| |
|
|
|
Workflow Information Fields
Workflow information fields include Workflow Status, Current Node, and Current Approver.
Workflow Status
Workflow Status refers to the current flow status of the workflow form, including In Progress, Completed, and Manual End.
How to View: In Manage Data/Permission Set, you can view the Workflow Status field in the workflow form.
Taking a permission set as an example, you can switch the permission set to view/manage data and tick Workflow Status in Display Fields to view fields in the workflow form data.
Current Node
Current Node refers to the current flow node of the workflow form. For details about the settings, see Introduction to Workflow Nodes.
How to View: In Manage Data/Permission Set, you can view the Current Node field in the workflow form.
Taking a permission set as an example, you can switch the permission set to view/manage data and tick the Current Node/Approver in Display Fields to view fields in the workflow form data.
Current Approver
Current Approver is the current approver for the workflow form. If the workflow has ended, the current approver is empty.
How to View: In Manage Data/Permission Set, you can view the Current Approver field in the workflow form.
Taking a permission set as an example, you can switch the permission set to view/manage data and tick the Current Node/Approver in Display Fields to view fields in the workflow form data.
Where to Call
Workflow information fields can be retrieved in the following scenarios:
Scenario/Field | Workflow Status | Current Node | Current Approver |
Print templates | Print templates | Print templates | |
Permission configuration in the share link for a record | / | / | |
Filter | Filter | Batch-edit node approvers | |
| / | / | |
| / | / | |
Input source | / | / |
Other System Fields
Other system fields include URL Parameter and data_id.
URL Parameter
URL Parameter is used to mark the data source of the collected information when members fill out the form through public links. For details about the settings, see Form Fill Link.
How to View: In Manage Data/Permission Set, you can view the UL Parameter field for data collected through Form Fill Link.
Taking a permission set as an example, you can switch the permission set to view/manage data and tick UL Parameter in Display Fields to view fields in the form data.
Data_id
The data_id field shows the data ID of form data.
How to View: In Manage Data/Permission Set, when exporting form data, tick Export with data_id to view the data_id in the exported Excel.
Where to Call
URL Parameter and data_id can be retrieved in the following scenarios:
Scenario/Field | URL Parameter | Data_id |
Field Initial Value |
| The data_id fields are not available to be retrieved. |
Multi Select Options | Lookup | |
| ||
Validations on form submission | ||
| ||
| ||
| ||
| ||
| ||
| ||
|