Understand Fields | Zoho Creator Help

Understand fields

Understand fields

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

Notes
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
Barcode / QR Code StringGenerates scannable QR codes or barcodes based on input. Supports automation using static text and data fields. 
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

Notes
Note: Please be informed that the number of fields you can add to a form depends on the character limit set for each field. When the character limit is set to the default values, email fields (limit of 80) can accommodate up to 200 fields, choice fields (limit of 100) allow for 160 fields, and single-line fields (limit of 255) permit up to 60 fields; reducing the character limit to 1 enables up to 10,000 fields for each type. For more information, visit the Limitations page.

Field navigation using TAB key

The TAB key enables users to swiftly move from one interactive element to another. In Creator, you (admin/super-admin) can customize the order (top to bottom or left to right) in which users can navigate through your form fields using the TAB key.  Learn more
  1. Add a field
  2. Rearrange fields
  3. Delete fields 

      Create. Review. Publish.

      Write, edit, collaborate on, and publish documents to different content management platforms.

      Get Started Now


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







                              Quick LinksWorkflow AutomationData Collection
                              Web FormsRetailOnline Data Collection Tool
                              Embeddable FormsBankingBegin Data Collection
                              Interactive FormsWorkplaceData Collection App
                              CRM FormsCustomer ServiceForms for Solopreneurs
                              Digital FormsMarketingForms for Small Business
                              HTML FormsEducationForms for Enterprise
                              Contact FormsE-commerceForms for any business
                              Lead Generation FormsHealthcareForms for Startups
                              Wordpress FormsCustomer onboardingForms for Small Business
                              No Code FormsConstructionRSVP tool for holidays
                              Free FormsTravelFeatures for Order Forms
                              Prefill FormsNon-Profit
                              Forms for Government
                              Intake FormsLegal
                              Mobile App
                              Form DesignerHR
                              Mobile Forms
                              Card FormsFoodOffline Forms
                              Assign FormsPhotographyMobile Forms Features
                              Translate FormsReal EstateKiosk in Mobile Forms
                              Electronic FormsInsurance
                              Drag & drop form builder

                              Notification Emails for FormsAlternativesSecurity & Compliance
                              Holiday FormsGoogle Forms alternative GDPR
                              Form to PDFJotform alternativeHIPAA Forms
                              Email FormsWufoo alternativeEncrypted Forms
                              Accessible FormsTypeform alternativeSecure Forms

                              WCAG

                                          Create. Review. Publish.

                                          Write, edit, collaborate on, and publish documents to different content management platforms.

                                          Get Started Now






                                                            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

                                                                  Use cases

                                                                  Make the most of Zoho Desk with the use cases.

                                                                   
                                                                    

                                                                  eBooks

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

                                                                   
                                                                    

                                                                  Videos

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

                                                                   
                                                                    

                                                                  Webinar

                                                                  Sign up for our webinars and learn the Zoho Desk basics, from customization to automation and more

                                                                   
                                                                    
                                                                  • Desk Community Learning Series


                                                                  • Meetups


                                                                  • Ask the Experts


                                                                  • Kbase


                                                                  • Resources


                                                                  • Glossary


                                                                  • Desk Marketplace


                                                                  • MVP Corner



                                                                    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 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 ...
                                                                                                                            • 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 Section Field

                                                                                                                              Understand Section Field The section field enables you to arrange the fields in your form in sections, and thereby provide your users a visual grouping of fields. Below image shows three section fields titled General, Group Status Details, and ...
                                                                                                                            • 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 ...
                                                                                                                            • Understand rich text field

                                                                                                                              Understand rich text field The Rich Text field enables your users to enter rich-text, i.e., text that's in the Rich Text Format (RTF). Character limits The rich text field can accept an input that takes up to 64 Kilobytes (KB) of space. Support for ...
                                                                                                                              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