Command Palette

Search for a command to run...

Part III · Zoho Creator · Chapter 2

Data Model: Applications, Forms, and Fields

903 words · preserved verbatim from the master reference

2.1 Applications

In Zoho Creator, an application is the primary container unit within a solution. It holds forms, reports, pages, and workflows. A single Creator account can host multiple applications. The platform supports unlimited applications on Professional and Enterprise plans, while the Standard plan allows one, and the Free plan also one (Pricing Comparison).

Applications can be created:

  • From scratch: Manually building forms and logic.
  • From templates: Pre-built templates available in the app marketplace.
  • Using Zia (AI): Generating the application from a natural language prompt or uploaded document (see Section 23).
  • By importing a .ds (Deluge Script) file: Migrating from another Creator account or on-premises instance.

2.2 Forms

Forms are the primary data-collection and data-storage mechanism in Creator. Each form corresponds to a relational table in the backend database. When a user submits a form, a record is created in that table. Forms auto-generate associated reports (e.g., a list view of all submitted records). Key form capabilities include:

  • Form drafts: Allow users to save incomplete entries and return to complete them later.
  • Offline mobile access: Forms can capture data even without an internet connection; data syncs when connectivity is restored.
  • NFC tag reading: Forms can read NFC (Near Field Communication) tags for asset tracking and similar use cases.
  • Integration forms: Special forms that pull schema from an external service (e.g., Zoho CRM, Salesforce) and allow workflow automation against that schema.
  • Subforms: A field type that embeds one form within another, supporting one-to-many data relationships (e.g., an order form containing multiple line-item subform entries).

All form components—fields, sections, workflows—are edited in the drag-and-drop form builder within the Application IDE (Forms Knowledge Base).

2.3 Fields

Fields are the atomic data-capture units of a form. Zoho Creator provides an extensive catalog of field types, each mapped to a specific database data type. As of April 2026, the full field type inventory is as follows (Understand Fields):

Basic Fields
Field TypeData TypeDescription
NameSTRINGComposite field for full name (first, last, etc.)
EmailSTRINGValid email address ([email protected] format)
AddressSTRINGComposite address field with map picker
PhoneSTRINGValid international phone number
Single lineSTRINGPlain text, single line
Multi lineSTRINGPlain text, multi-line area
Rich textSTRINGRich Text Format (RTF) input
NumberBIGINTInteger value
Auto numberBIGINTSequential numeric ID auto-assigned per record
DecimalDECIMALDecimal value
PercentDECIMALDecimal with percentage symbol
CurrencyDECIMALMonetary value with currency symbol
DateTIMESTAMPDate picker or typed
TimeTIMETime picker or typed
Date-timeTIMESTAMPCombined date-time picker
Drop downSTRINGSingle-select from predefined choices
RadioSTRINGSingle-select displayed as radio buttons
Multi selectLISTMulti-select from predefined choices, dropdown
CheckboxLISTMulti-select displayed as checkboxes
Decision boxBOOLEANTrue/false or yes/no
URLSTRINGWebsite or web page URL
ImageSTRINGImage capture or upload
AudioSTRINGAudio recording or upload (up to 30 minutes)
VideoSTRINGVideo recording or upload (up to 5 minutes)
SignatureSTRINGDraw signature
File uploadSTRINGSubmit arbitrary file
SubformOne form embedded within another (one-to-many)
LookupBIGINTRelates data between forms; single or multi-value
FormulaVariesComputed value based on predefined expression
Barcode / QR CodeSTRINGGenerates scannable QR or barcode from input
SectionVisual grouping of fields (no data capture)
Add notesSTRINGDisplays static note text on the form
UsersSTRINGSingle-select dropdown of app users
Advanced / AI Fields
Field TypeData TypeDescription
IntegrationSTRINGSingle-select from external service data (Zoho CRM, Salesforce, QuickBooks, etc.)
PredictionVariesAI-based value prediction for a target field
Keyword extractionSTRINGExtracts keywords from text in linked field
Sentiment analysisSTRINGDetermines positive/neutral/negative sentiment
OCRSTRINGOptical character recognition on an image field
Object detectionSTRINGClassifies objects in an image field

The Integration field deserves particular attention: it enables a live lookup into an external service (Zoho CRM, Zoho Recruit, Salesforce, QuickBooks, Zoho Projects, Zoho BugTracker, Zoho People, ManageEngine SDP OnDemand) and presents matching records in a dropdown. It supports customizable display fields (up to three fields from the external module), real-time data fetch on each field access, and field-level search. As of November 2025, admins can now trigger a manual data sync on integration fields from the Connections slider in live mode, updating existing Creator records with the latest data from the connected service (November 2025 Upcoming Updates).