Understand System Fields
Understand system fields
In addition to the data that is submitted through a form , Zoho Creator captures a few details like - which user added the record, when did the user add the record, which user was the last one to update it, etc. These details are stored in the system fields.
As the name suggests, adding and updating data in system fields is handled by the system - Zoho Creator. You and your users will neither be able to set values for these fields, nor be able to edit the values stored in these fields. However, you can make use of these fields in your app. Refer this section to see examples.
System fields available in Zoho Creator
System fields | Description |
| ID | Stores the record's identification (ID) - an auto-generated numeric value that is unique for all records. |
Added Time | Stores the date and time of when the record was added. |
Added User | Stores the username of the user who added the record. |
Added User IP Address | Stores the public IP address of the device from which the user added the record. |
Added Location | Stores the physical location (address) from where the user added the record. |
Last Modified Time | Stores the date and time of when the record was last modified. |
Last Modified User | Stores the username of the user who was the last one to update/modify the record. |
Modified User IP Address | Stores the public IP address of the device from which the last modified user updated/modified the record. |
Modified Location | Stores the physical location (address) from where the user last updated/modified the record. |
Things to know
- Zoho Creator will populate the fields - Added Location and Modified Location , only when capturing location has been enabled for that form. The address stored in these fields is the nearest physical address using the latitude and longitude data.
- Zoho Creator will populate the fields - Added User IP Address and Modified User IP Address , only when capturing IP address has been enabled for that form
- The date-time values stored in the fields - Added Time and Last Modified Time , will be displayed as per the date and time zone format set in that app
- If you have published your form, Zoho Creator will populate the fields - Added User and Last Modified User , with the value Public
- Ownership of records is tracked using the Added User field, unless you've added a users field to your form and configured it to make the selected user as record owner
How to view the data stored in them?
You can enable your users to view the data stored in the system fields by adding them in the quick view layout and/or detail view layout of the reports that your users have access to.
Examples of using system fields in an app
Added Time
- Consider an IT asset management (ITAM) scenario, where employees place a request for a device - smart phone, tablet, laptop, desktop, etc. Instead of using a separate date-time field to capture the date and time at which the employees submit requests, the added time field can be used
- In an order management scenario, the added time field may be used for two purposes:
- Capturing the date and time at which an order is placed
- Calculating the expected date of delivery based on the date of order (which can be fetched from the added time field)
Added User
- You can configure a report to display user-specific records. For this, you will need to set a filter that makes the report display the records where the value stored in the added user field matches the username of the logged-in user (which is stored by the system variable zoho.loginuser ).
Added Location
- You can view records in a map. For this, you will need to create a map report based on the added location field (that would need capturing location enabled on the form). The map report will point out the locations from where records are added.
Related Topics:
Access your files securely from anywhere
Zoho CRM Training Programs
Learn how to use the best tools for sales force automation and better customer engagement from Zoho's implementation specialists.
Zoho DataPrep Personalized Demo
If you'd like a personalized walk-through of our data preparation tool, please request a demo and we'll be happy to show you how to get the best out of Zoho DataPrep.
- Zoho Workerly Home
- Forums
- Connect With Us:
- Zoho Recruit Home
- Forums
- Connect With Us:
All-in-one knowledge management and training platform for your employees and customers.
Create. Review. Publish.
You are currently viewing the help pages of Qntrl’s earlier version. Click here to view our latest version—Qntrl 3.0's help articles.
Zoho Sheet Resources
Zoho Forms Resources
Zoho Sign Resources
Sign, Paperless!
Zoho TeamInbox Resources
Design. Discuss. Deliver.
Related Articles
Managing System Integrations
1. What does this page cover Learn how to configure the different Zoho services in your Creator account from System Integrations. Learn more about System Integration and it's usage before moving ahead. 2. Availability System Integrations can be ...Understand fields
Understand fields Note: Ensure to not enter sensitive terms while naming your form fields or collect confidential information in them. A field is the basic unit or building block of a form. In your Zoho Creator app, you collect and store data using ...Understand expression
Understand formula field's expression The formula field's Expression is what defines the value it will store and display. For example, the Amount field in an Order form is usually a result of multiplying the values in Unit Price and Ordered Quantity ...Understand kanban report
Kanban report provides an ideal solution to visualize records capturing a process flow, the progress of a process, or status of the process. The report displays records as cards, and these cards are compartmentalized into separate entities. This ...Understand users field
Understand users field The users field features a single-select dropdown menu that displays the users you've shared your app with. The users are listed by their usernames that Zoho Creator assigns to them when they sign up. Below is an example of how ...