Understand System Fields | Zoho Creator Help

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

Note: System fields are not available for integration forms as integration forms enable storing data in external services (i.e., outside your Zoho Creator app).

System fields
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.
  1. Understand forms
  2. Understand form builder

    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 CRM Training
      Redefine the way you work
      with Zoho Workplace

        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 CRM Training

          Create, share, and deliver

          beautiful slides from anywhere.

          Get Started Now

            Zoho Sign now offers specialized one-on-one training for both administrators and developers.

            BOOK A SESSION

                        Still can't find what you're looking for?

                        Write to us:  support@zohoforms.com



                          Manage your brands on social media

                              Zoho Marketing Automation

                                Zoho Sheet Resources


                                    Zoho Forms Resources

                                      Secure your business
                                      communication with Zoho Mail

                                      Mail on the move with
                                      Zoho Mail mobile application

                                        Stay on top of your schedule
                                        at all times

                                        Carry your calendar with you
                                        Anytime, anywhere

                                              Zoho Sign Resources

                                                Sign, Paperless!

                                                Sign and send business documents on the go!

                                                Get Started Now

                                                        Zoho TeamInbox Resources

                                                                Zoho DataPrep Resources

                                                                  Zoho DataPrep Demo

                                                                  Get a personalized demo or POC

                                                                  REGISTER NOW

                                                                    Design. Discuss. Deliver.

                                                                    Create visually engaging stories with Zoho Show.

                                                                    Get Started Now

                                                                                          • Related Articles

                                                                                          • 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 forms and each ...
                                                                                          • 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 Permissions

                                                                                            What Does This Page Cover? Learn how you can define unique permission sets such as Read, Write, or customized ones that decide on how different users can access the records. Availability Permissions can be accessed in all plans of Creator. Addition ...
                                                                                          • Understand Forms

                                                                                            What Does This Page Cover? Learn about forms and how they are used to collect and store data in Creator. Availability Forms built from scratch, by importing data, and from a template can be created in all plans (Free, Professional, andUltimate) of ...
                                                                                          • Understand Connections

                                                                                            This help page is for users in Creator 6. If you are in the older version (Creator 5), click here. Know your Creator version What Does This Page Cover? Learn about connections and their types that can be used to integrate your Creator application ...
                                                                                          Wherever you are is as good as
                                                                                          your workplace



                                                                                            Watch comprehensive videos on features and other important topics that will help you master Zoho CRM.


                                                                                            Download free eBooks and access a range of topics to get deeper insight on successfully using Zoho CRM.


                                                                                            Sign up for our webinars and learn the Zoho CRM basics, from customization to sales force automation and more.

                                                                                            CRM Tips

                                                                                            Make the most of Zoho CRM with these useful tips.

                                                                                              Zoho Show Resources