Understand Fields | Zoho Creator Help

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 details of your employees may contain separate fields to capture name, email address, phone number, residence address, etc. Each record stored in this form represents the contact information of an employee and each field in a record stores one piece of that information.

A form takes on the same role in your Zoho Creator app as a table in a database or a sheet in a spreadsheet. A field takes on the role of a column within the sheet or table.

Below is an example of an  Employees  form, which contains a few different types of fields:
  • When a user accesses from a web browser:

What is a field made of?

When added to a form, almost all types of field have:
  • Field name: The text or label that denotes what data the field captures
  • Input area: The input box, dropdown, radio button, checkbox, or a combination of these input elements which a user can use to enter data in the field

The following images show how two types of fields:  name  (labelled  Name ) and  email  (labelled  Email Address ). The input area of the  Name  field contains one dropdown for  Prefix  and input boxes for  First Name  and  Last Name . The input area of  Email Address  contains one input box.

  • When a user accesses from a web browser:

  • When a user accesses from a phone or tablet:

Types of fields

Zoho Creator offers many types of fields – each meant to capture a specific kind of data. They are listed in the table below.


In addition to these field types, Zoho Creator also has system fields. Refer to this page to learn more about them.
Field type Data type Description
Name STRING A composite field that enables your users to enter their full name
Email STRING Enables your users to enter a valid email address, i.e., an email address that is in the format  xx@xx.xx
Address STRING A composite field that enables your users to enter an address. They can pick an address from a map, or type it.
Phone STRING Enables your users to enter a valid international phone number, i.e., a phone number that has the required number of digits for the selected country
Single line STRING Enables your users to enter a single line of plain text or text that can contain any character
Multi line STRING Features a bigger text area than the Single line field. It enables your users to enter plain text that can contain any character
Rich text STRING Enables your users to enter data in Rich Text Format (RTF)
Number BIGINT Enables your users to enter an integer value
Auto number BIGINT Enables a sequential numeric value to be associated with each record submitted through the form
Decimal DECIMAL Enables your users to enter a decimal value
Percent DECIMAL Enables your users to enter an integer or decimal value. A percentage symbol will be displayed next to the input.
Currency DECIMAL Enables your users to enter a monetary value. A currency symbol will be displayed next to the input.
Date TIMESTAMP Enables your users to enter a date value. They can pick a date from a date picker, or type it.
Time TIME Enables your users to enter a time value. They can pick a time from a time picker, or type it.
Date-time TIMESTAMP Enables your users to enter a date-time value. They can pick a date and time from a date-time picker, or type it.
Drop down STRING Enables your users to select a value from a defined set of choices displayed in a dropdown menu
Radio STRING Enables your users to select a value from a defined set of choices displayed as radio buttons
Multi select LIST Enables your users to select one or more values from a defined set of choices displayed in a dropdown menu
Checkbox LIST Enables your users to select one or more values from a defined set of choices displayed as checkboxes
Decision box BOOLEAN Enables your users to enter a true/false or yes/no response
URL STRING Enables your users to enter a URL for a website or web page
Image STRING Enables your users to submit an image, by either by taking or uploading a picture
Audio STRING Enables your users to submit an audio of up to 30 minutes, by either recording or uploading an audio file
Video STRING Enables your users to submit a video of up to 5 minutes, by either recording or uploading a video file
Signature STRING Enables your users to draw their signature
File upload STRING Enables your users to submit a file
Subform  -  Enables relating the data in two forms by displaying one form within the other. Each record in the main form can be related to multiple records in the subform.
Lookup BIGINT Enables relating the data in two forms by looking up data stored in a different form, and allowing users to select one or multiple values
Formula (depends on the result of its expression) Computes and generates a value based on a predefined formula
Section  -  Introduces a visual grouping of fields in the form
Add notes STRING Displays a note on your form
Users STRING Features a single-select dropdown menu that displays your app's users
Integration STRING Features a single-select dropdown menu that displays data stored in an external service
Prediction (depends on its target field) Predicts the value of a field in your form
Keyword extraction STRING Extracts keyword from the text stored in a single line or multi line field 
Sentiment analysis STRING Determines if the sentiment of the text stored in a single line or multi line field is positive, neutral, or negative
OCR STRING Performs optical character recognition - recognizes text from an image
Object detention STRING Determines the class of objects present in the image

  1. Add a field
  2. Rearrange fields
  3. Delete fields 

    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

                                                                                      • Rearrange fields

                                                                                        Rearrange fields in a form You can arrange the fields in your form in a mixture of one-column, two-column, and three-column layouts. How to rearrange fields in your form Things to know How to rearrange fields in your form Edit your app. Open the ...
                                                                                      • Making form fields Mandatory

                                                                                        Understand making form fields mandatory Applicable to the following fields: auto-number , formula , and add notes . Enabling this property for a  field  forces your users to enter an input in that field. Until they don't enter an input in that field, ...
                                                                                      • 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 ...
                                                                                      • Understand add notes field

                                                                                        Understand add notes field The  Add Notes  field enables you to display a note on your form. You can use it to provide any instruction or additional information to your users, and thereby assist them in submitting data through your form. You can have ...
                                                                                      • Understand auto number field

                                                                                        Understand auto number field The Auto Number field enables you to associate a sequential numeric value to each entry your users submit through your form. The number held by this field is automatically assigned immediately after your users submit an ...
                                                                                      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