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.
  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


            Get started with Zoho Sign

            in a few quick steps!

            Download Help Guide





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

                        Write to us:  support@zohoforms.com


                              




                            

                          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 SalesIQ Resources



                                                    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

                                                                                        Understand fields 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 field in a form holds an individual piece of that data. For example, a form to collect the contact ...
                                                                                      • Understand system connections

                                                                                        When a user connection cannot be applied where integration is required in your application, the system automatically generates a connection with access to all modules of the target service in the backend. The super admin of the application can ...
                                                                                      • Understand forms

                                                                                        A form is the component of your Zoho Creator app that enables you to collect and store data. In other words, it enables your users to enter data into your app. This makes forms one of the main points of interaction between your users and your app. If ...
                                                                                      • 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 ...
                                                                                      • Understand reports

                                                                                        A report is a compilation of data collected using a form in the created application. Zoho Creator incorporates reports as one of the components to complete the purpose of the application that you create. A report collates and presents information to ...
                                                                                      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