Zoho Creator Platform Features
Everything you need to build your database application like a pro!
Drag and Drop Interface
- HTML Form Builder
Zoho Creator's easy to use HTML Form Builder helps you create forms/tables easily and quickly . All you have to do is just drag-and drop the required fields. You can create UNLIMITED forms/tables. No programming skills required.
- Script Builder
Deluge or Data Enriched Language for the Universal Grid Environment as we call it, is an online scripting language integrated with Zoho Creator. It enables users easily add business rules and create custom workflows to streamline important business processes. Zoho Creator provides easy drag and drop script builder to add actions/triggers.
- 20 Field Types/Data Types
|Single Line Text
||Signle Line Text can hold plain text, numbers or anything. Text fields are the most versatile field type, in which you can input any kind of characters.
|Multi Line Text
||As name suggests, Multi Line text can hold multi-line inputs. Multi Line text can also hold any characters. Use Multi-line field for collecting Comments, descriptions, feedback or anything that requires room to fill in the more data.
||Used to capture email-ids from your users. This field automatically authenticates and accepts the data only if it is in the format of email id.
||Use this to collect phone numbers, Amount, Quantity, Zip Code...
||Decimal is used to represent binary values. For example: 1000.25
||Supports 104 currency types like - Dollars, Euros, Pounds Sterling, Yen and more...
||A numeric field that displays as a percentage. For example: 65%.
||Dropdown (Picklist) allows your users to select single value from the list of values. For example: Selecting 'India' from the Country picklist.
||Allows your users to choose only one of a predefined set of options. For Example: Status - Closed, Open
||Permits your users to make multiple selections from a number of options. For Example: Hobbies - Tweeting, Blogging, Socializing, Sports
||Use this field type when you want users to select a entry instead of typing.
||Use this field to capture a date (and only a date). When a date field appears on a form it features date Picker, which lets users select a date easily.
|Date and Time
||This field is an extended date field that can also capture the time. This field also provides Data and Time Picker, which lets users to pick both date and time.
||Lookup field is used to create relationship between two forms/tables. You will need this to create reports that includes information from two different forms. When you create a relationship between two forms, one is the "master" another is the "details" form. In other words, the forms have a one-to-many relationship. For example, if you have a form of Authors you could relate it to a Books form. Here Author -is- Master and Books -is- Details.
||Used for computing values entered by the users. Can be used for calculating Total Marks, summing up the values of English and Maths. Total Marks = English + Maths
||This field can have only two values - Yes or No. Users can turn on a checkbox, by placing a checkmark in it, or turn it off, by leaving it blank. For Example: You can find 'Keep me signed in' check box in all the Zoho services Login box.
||Use this field if you want insert images
||Using this field you and your users can upload images, reports and documents related to the database. Maximum size for a file is 5 MB.
||Url field displays a URL (Web address) as a link. Users can enter a URL address and also specify the link name which will be displayed in the data view. For Example: 'YouTube Video' as the linkname and Url will be //www.youtube.com/watch?v=N3BhPJMIngA You can also specify if you want to open the link in same window or in a new window.
||Add descriptions, instructions or comments which will help users while filling the form. For Example: "Please fill in the details below and help us serve you better."
- Stateless Forms
By default, every form created in Zoho Creator will generate a table at the back-end to store the data. But for a Stateless Form Zoho Creator does not generate any tables at the backend. Instead you can add custom buttons and write action scripts for "on click" of a button to perform any actions. Some common usages: Create multiple forms to update data in a single table, Fetch and Display information from other forms, Execute send mail... Learn More
A relationship is a link between two forms/tables. When you create a relationship, Zoho Creator will connect a single record in one form to one or many records in another form. In other words, the forms have a one-to-many relationship. You can create relationships between any two forms within the same application or with any application in your account. Learn how to create relationships
- Actions/Triggers - Form and Field Level
Using Deluge Script you can perform custom actions/triggers at Form and Field Levels.
Form Actions -
On Load, Validate, On Success.
Field Actions -
On User Input, On Update Learn More
- Custom Validations
Zoho Creator supports following validations:
On Add, On Edit, On Delete Learn More
- Form Schedule
Form schedules are events that are scheduled based on a date/time field in your form. (i.e) you will be able to specify a field in the form, whose value will be taken as the scheduling due date (or as start date and end date). For example: Consider an 'Appointment' form with a date-time field named 'Due time'. You can schedule a generic reminder that reminds you 2 hour before every appointment.
- Report Schedule
Report schedules are events scheduled based on the data view in your application. You can send your data view as reports by specifying fixed date and time with repeats like 'monthly' or 'yearly'.
- Custom Schedule
Custom Schedules are events/actions scheduled by specifying fixed dates and time with repeats. This will be mostly useful for tasks like sending monthly reports, deleting previous month's records at the start of every month, sending meeting remainders every monday etc. Learn more about Scheduler
- URL based controls for easy navigation
Get URL - The get URL task corresponds to a HTTP GET request. It is normally supported by services to perform read-only operations like fetching data from external websites. Learn More
Post URL - The post data corresponds to a HTTP POST request. It is normally supported by services to perform write operations like adding or updating data. Learn More
Open URL - OpenURL task can be invoked from form and field actions to redirect the form to a specified URL. The URL can be opened in the same window or a new window. Learn More
- Custom Actions
Custom Actions are the actions performed on selected records in the data view. You can define a function and configure it as your custom action. For eg: You can define your custom Action to 'Send Email Notification'. Learn More
Zoho Creator provides an intuitive user interface - XPath Builder to find the required XPath expression from a given XML/ JSON file. The builder automatically converts JSON to XML so that XPath can be applied to filter the nodes.
Learn more about XPath
- Through HTML Forms
Zoho Creator makes it easy and convenient for you to collect information over the web using HTML Forms. Share a particular form with users. Your users wil automatically receive a email notification with the url to access the form.
- Through Email
Zoho Creator also offers the convenience of adding new data/record right from your email client. Each form will be supplied with a private perma-link and simple format to email the data. Learn More
- From your Mobile Devices
You can access all your databases and shared databases from your mobile devices using the URL - //creator.zoho.com/mobile or //creator.zoho.com/m. Supported browsers: Internet Explorer 6 or higher, Opera, Safari, other WAP Browsers. Zoho Creator's interface has been optimized to work well in iPhone also.
- Embed in your Website
Zoho Creator lets you embed Forms and Views in your website/blog just by pasting few lines of code. You can customize the look of the form/view to match your website. Learn More
- Pivot Tables
Allows you to create a powerful view with data summarized in a grid, both in horizontal and vertical columns (also known as Matrix Views or Cross Tabs). Multi-level pivots can be created by specifying multiple fields to the column, row and data axis.
- Pivot Charts
A pivot chart is an interactive graphical representation of the data. You can rearrange the layout, select a different type of chart, and add or remove data. A Pivot Chart gives you a quick summary of text entries. For example if you have a list of products sold, create a Pivot Chart to show the percent of the total sales for each product. Learn More
Dynamic HTML Pages
List, Grid, Calendar, Summary, and Charts
List: This is similar to a table view with rows and columns of data. The list view enables you to sort, search, filter and group data.
Grid: Data is presented in the form of a tabular view where each column represents a field and each row represents a record. The grid view enables you to edit your records very easily.
Calendar: A calendar view is displayed based on a date field in your form. If there are more than two date fields, you have to select the date field based on which the calendar view will be displayed.
Summary: Displays the summary of each record
Chart view: Zoho Creator supports 15 types of charts -
- Column, Stacked Column, Column 3d, Stacked Column 3d
- Bar, Stacked Bar, Bar 3d, Stacked Bar 3d
- Line, Step
- Pie, Pie 3D
- Area, Stacked Area
- Web Chart
One of the powerful features of Zoho Creator. You can create customized views by combining HTML code and Deluge script. You can create a static HTML page as a view and use this page to deliver dynamic content from your datastore. The HTML Builder provides an intuitive drag and drop interface to create HTML view easily. Learn More
- Set Criteria
By default view will display all the records. You can restrict the display by setting criteria.
For example: Name » Starts With » John to see records only related to John
- Search Data
You can search records in a view using the Search button The Search option is supported in List view and Grid view.
- Sort Data
Sorts data in ascending or descending order. You can also set sorting based on a column while creating the view itself.
Zoho Creator automatically creates filters for drop-down and date fields. You can also create custom filters.
Zoho Creator lets you group the records by a specific column(s). Group view is used to arrange reports within reports
- Create view out of another view
Do sorting, filtering and then save the view as a new view.
Look and Feel Customization
Zoho Creator offers different types of layout options - Pane Left, Pane Right, Tab, Tab Pane Left, Tab Pane Right and Drop Down Menu
Change color themes to go with your branding or taste. You can also create your own theme by setting Font Family, Font Size, Application Header Style, Section Style and much more. You can create a custom theme and apply to all your database applications. Learn how to create your own theme
By default, all the forms and views will be listed under the Home section. You can rearrange them under different sections.
Sharing and Collaboration
- Collaborate with specific users - Private access
Share your "Private" application with your friends, colleagues, managers and clients by specifying their e-mail id's. You can share your database at different levels
- Levels of Sharing
- Application Level - Entire database application will be shared
- Page/Tab level- All the forms and views places in the page/tab will be shared
- Form/View Level - More granular sharing control. You can share a particular form/view
- Access Privileges
You can set permissions to add, edit or delete records for your users. By default, shared users do not have permission to add, edit or delete records, but they will just have access to see the data. The application owner has to grant access permissions.
- Separate Login
Zoho Creator supports for zoho.loginuser and zoho.loginuserid to fetch records based on the login username or login user id
- Dynamic Sharing
Make use of Share/UnShare task to dynamically share or unshare au email address to an application, page, form or view.
- Publish to the internet - Public access
Provide access to everyone/anyone by making your database public. Data will be indexed by search engines like Google and Bing.
- Database Application Backup
Backup your database application with data (available only for the paid versions). Take multiple backups for the same application with version numbers and date.
Zoho Creator supports SSL. Access all your databases via HTTPS://
- Manage Users
Add new users, delete existing, activate or deactivate users.
Zoho Creator provides REST APIs and RPC style APIs that allows external websites to collaborate with Zoho Creator databases. Users can now build their web application in PHP, JSP, ASP, Perl or on any other programming language while the data is stored in Zoho Creator. The API opens up lot of avenues for external websites and developers to collaborate with Zoho Creator database.
Zoho Creator API guide
- XML, CSV, JSON
A mashup is a web application that combines data from multiple resources or services. Mashing-up data is thus a process of acquiring XML ( through APIs exposed by external websites), processing and combining that data, and publishing the results. Web 2.0 applications, such as Flickr, del.icio.us etc., expose APIs that return XML as the default format.
Zoho Creator supports tasks that get the XML from one place to another, manipulate and publish XML data to easily create sophisticated web applications.
Learn more about creating Mashups
- get Url - Fetch data from a specific url using HTTP GET request.
- post Url - Fetch data from a specific url using HTTP POST request.
- open Url - Redirect a form to the specified url.
- Execute XML - Execute an XPath in the context of the specified XML and returns the value as a string.
- Data Export
Zoho Creator supports industry standard export options - Spreadsheet, PDF, HTML, .CSV, .TSV, RSS feed and JSON feed
- ICal Feed
iCalendar (iCal) is a standard format for exchanging calendar data. iCal Feed enables an application to publish event-oriented data to an external calender (Google calendar) via the iCal standard. Learn more