Create Online Database Apps

As we all know,  Zoho offers many online productivity and collaboration
applications including Zoho Mail, Zoho Writer, Zoho CRM, Zoho Reports, etc. The
web-based online office suite  lets individuals and businesses manage their work
easily. In this article, we look at Zoho Creator, a database software that lets
you build custom database applications. Targeted at individuals,  small and
large corporations, this intuitive and feature-rich Platform as a Service (PaaS)
also allows you to host custom database applications. You can create forms,
tables, import data from standard formats like .xls, .csv, .tsv and .mdb. There
are three different ways in which you can create your own  database apps.

Zoho Creator lets you create databases from scratch and also allows you to
create forms, define actions/triggers easily using its drag and drop interface.
It gives you complete control over the database structure, relationship between
them, and fields/datatypes, etc that are used for capturing data.   Be it MS
Access Database or Spreadsheet, Zoho Creator helps in refining the database over
the web and helps in collaborating with your team. It allows to move the MS
Access database onto the web without porting through MS SharePoint, MySQL or
PostgreSQL. For using this feature, you simply need to download a plugin,
upload it and once migrated, start collaborating with the team easily.

Features at a glance

Business Logic: This feature contains different entities that comprise of
schedulers, custom validations, triggers, etc. Again, there are different types
of schedulers such as form schedulers, report, custom schedulers, etc. The Form
schedulers simply lets you schedule an event based on time/date field in the
form.

After signing in with your user name and password, you get this screen. Choose whether you want to start from scratch or import data from spreadsheet or MS Access Database.

After choosing the form template, you can start by filling up the details including uploading photos. You can edit field type, give permission, etc.

To perform different actions on user inputs, you just need to drag and drop fields and it allows you to define business rules.

To define different schedules like form, report or custom schedule, simply click on 'Schedule' menu on the top and then click on 'Create' button.

Drag and Drop interface: Two entities, HTML form builder and Script builder
enable users to add business rules and create custom workflows & with HTML form
builder, create forms/tables easily just by dragging and dropping the required
fields.

Data Analytics: This feature also contains different entities such as set
criteria, search data, filter, group-by, etc. As the name suggests, the search
data helps in searching the records and supports list and grid view. The sort
data field helps in sorting the data in ascending or descending order.

You can share the database application privately or publicly. For sharing it, simply click on Share menu, select Private or Public and enter email ids you want to share to.

You can also create reports by selecting the 'Report' menu. After this, specify the report type which could be a Pivot table or Pivot chart.

After filling basic details of the report, you can drag and drop different fields in the column, row and data fields & then click on 'Create here to generate pivot'.

You can also change the application settings by simply clicking on the Settings tab. Here, it shows you different options such as allow HTML tags, making this application private or public.