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
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.
Note : You can also use Deluge scripts to perform actions using the system fields. Learn more about system variables to perform these actions.

  1. Understand forms
  2. Understand form builder
  3. Understand System Variables

    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









                                    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.




                                        Manage your brands on social media

                                          Zoho Desk Resources

                                          • Desk Community Learning Series


                                          • Digest


                                          • Functions


                                          • Meetups


                                          • Kbase


                                          • Resources


                                          • Glossary


                                          • Desk Marketplace


                                          • MVP Corner


                                          • Word of the Day


                                            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 System Integrations

                                                                                                        1. What does this page cover? Learn about the different backend-integrated Zoho services and how it benefits the users. 2. Availability System Integrations can be accessed in all the paid plans of Creator. Can only be created and managed by the super ...
                                                                                                      • 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 ...
                                                                                                      • Manage System Integrations

                                                                                                        1. What does this page cover? Learn how to enable 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 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 ...
                                                                                                        Wherever you are is as good as
                                                                                                        your workplace

                                                                                                          Resources

                                                                                                          Videos

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



                                                                                                          eBooks

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



                                                                                                          Webinars

                                                                                                          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