{"id":5609,"date":"2011-03-08T00:31:42","date_gmt":"2011-03-07T16:31:42","guid":{"rendered":"http:\/\/www.softwareforenterprise.us\/?p=5609"},"modified":"2017-03-15T20:03:44","modified_gmt":"2017-03-15T12:03:44","slug":"zoho-creator-review-simple-online-database-builder","status":"publish","type":"post","link":"https:\/\/www.softwareforenterprise.us\/hub\/zoho-creator-review-simple-online-database-builder\/","title":{"rendered":"ZOHO Creator &#8211; a simple online database builder"},"content":{"rendered":"<p><img decoding=\"async\" class=\"alignleft lazyload\" style=\"--smush-placeholder-width: 240px; --smush-placeholder-aspect-ratio: 240\/160;border: 0px initial initial;\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/HLIC\/9e919fee18fbda46da98cf5790888bd7.jpg\" alt=\"Proyecto 365, d\u00eda 28\" width=\"240\" height=\"160\" border=\"0\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" \/>A friend recently asked if I know of any freelancers who could help him create a simple MS Access database for his team to easily add, edit and delete rows of stock exchange related data on a daily basis.<\/p>\n<p>I asked him why he mentioned MS Access specifically\u00a0just to be able to store and capture data.<\/p>\n<p>He said that Access was what he learnt in school and it&#8217;s the only software he knows that can help him manage large number of records.<\/p>\n<p>For many, MS Access and Excel seem to be the only software that comes to their mind when there&#8217;s a need for data management and number crunching.<\/p>\n<p>Today with the emergence of software as a service (SaaS) and platform as a service (PaaS), many are beginning to move towards cloud computing which provides:<\/p>\n<ul>\n<li>More flexibility<\/li>\n<li>Easy access via the web<\/li>\n<li>Operating expenditure + lower in cost<\/li>\n<li>Free from software and infrastructure maintenance<\/li>\n<li>and more&#8230;<\/li>\n<\/ul>\n<p>I also found out that he needed the database to be accessible via the web by his team members who are at various client sites most of the time. Another problem is that half of his team members are on MACs and it looks like even the latest <a title=\"Microsoft Office for Mac\" href=\"https:\/\/www.microsoft.com\/mac\/\" target=\"_blank\">Microsoft Office for Mac<\/a> doesn&#8217;t have Access in it. Obviously MS Access may not be the right tool for his team just yet.<\/p>\n<p>Because of this, I recommended him to check out <a title=\"Zoho Creator\" href=\"https:\/\/www.zoho.com\/creator\/\" target=\"_blank\">ZOHO Creator<\/a> &#8211; a simple online database builder.<!--more--><\/p>\n<p><a title=\"Zoho Creator\" href=\"https:\/\/www.zoho.com\/creator\" target=\"_blank\"><img decoding=\"async\" class=\"alignnone size-full wp-image-5722 lazyload\" title=\"Zoho Creator Logo\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2011\/03\/Zoho-Creator-Logo.png\" alt=\"\" width=\"203\" height=\"61\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 203px; --smush-placeholder-aspect-ratio: 203\/61;\" \/><\/a><\/p>\n<p><a title=\"ZOHO\" href=\"https:\/\/www.zoho.com\" target=\"_blank\">Zoho<\/a> has been around for quite a number of years and Zoho Creator is one of their 22 online <a title=\"\" class=\"aalmanual\" target=\"_blank\"  rel=\"nofollow\"   style=\"color:#1e73be;\" href=\"https:\/\/partners.webydo.com\/6wdx17ttbarj\">applications<\/a> that ranges from CRM to Office Suite, Invoicing, <a title=\"Free task &#38; team collaboration tool\" class=\"aalmanual\" target=\"_blank\"  rel=\"nofollow\"   style=\"color:#1e73be;\"href=\"https:\/\/www.softwareforenterprise.us\/hub\/recommends\/zoho-projects\/\">Project Management<\/a> and more.<\/p>\n<p>While most of Zoho&#8217;s applications are already built based on certain key business functions such as CRM and Project Management, Zoho Creator allows <a title=\"\" class=\"aalmanual\" target=\"_blank\"  rel=\"nofollow\"   style=\"color:#1e73be;\" href=\"https:\/\/www.inflowinventory.com\/?plid=27260\">organizations<\/a> to create apps which aren&#8217;t already built.<\/p>\n<p>For example, an organization may have a policy which require guests to register their details at the front desk before the person can be allowed into the office area.<\/p>\n<p>Rather than asking the guest to write down the details on a piece of paper, a simple guest registration online form can be created using Zoho Creator.<\/p>\n<p>Zoho Creator is not just a plain database which helps you store data. It&#8217;s able to do a lot more such as:<\/p>\n<ul>\n<li>Reporting tools<\/li>\n<li>Alerts and notifications<\/li>\n<li>Customizable user interface<\/li>\n<li>API: Rest, XML, CSV, JSON<\/li>\n<li>Ability to apply business logic<\/li>\n<li>Drag and drop form table builder<\/li>\n<li>Ability to export data to spreadsheet, pdf, html and more<\/li>\n<li>Ability to collect data via html, email and even website embed<\/li>\n<\/ul>\n<p>I gave Zoho Creator a try and was impressed by it&#8217;s intuitive user interface as well as it&#8217;s fast loading time, which is very important because you&#8217;re actually doing development work on it.<\/p>\n<p>The experience needs to be able to match the speed as if you&#8217;re developing from a desktop application. Zoho Creator loads up fast enough.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-5723 lazyload\" title=\"Create an application\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2011\/03\/Create-an-application.png\" alt=\"\" width=\"500\" height=\"307\" data-srcset=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2011\/03\/Create-an-application.png 500w, https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2011\/03\/Create-an-application-300x184.png 300w\" data-sizes=\"(max-width: 500px) 100vw, 500px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 500px; --smush-placeholder-aspect-ratio: 500\/307;\" \/><\/p>\n<p>From the screenshot above, you can choose to create an application:<\/p>\n<ul>\n<li>From scratch<\/li>\n<li>By importing from MDB<\/li>\n<li>By importing from XLS, CSV<\/li>\n<li>Browse gallery (allows you to install pre built apps)<\/li>\n<\/ul>\n<p>There are also many form templates to chose from saving us even more time.<\/p>\n<p><img decoding=\"async\" class=\"alignnone size-full wp-image-5724 lazyload\" title=\"Drag and drop fields\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2011\/03\/Drag-and-drop-fields.png\" alt=\"\" width=\"475\" height=\"301\" data-srcset=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2011\/03\/Drag-and-drop-fields.png 475w, https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2011\/03\/Drag-and-drop-fields-300x190.png 300w\" data-sizes=\"(max-width: 475px) 100vw, 475px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 475px; --smush-placeholder-aspect-ratio: 475\/301;\" \/><\/p>\n<p>Adding fields into a form is simple. Just chose from any of the 21 types of fields and drag it into the form on the right.<\/p>\n<p>When you&#8217;re done designing the form, simply click on the &#8220;Access this application&#8221; tab and you&#8217;ll be directed to a page which shows you the actual form.<\/p>\n<p>Entering some data and clicking on the submit button will save the data into the database.<\/p>\n<p>Isn&#8217;t it simple? You don&#8217;t even need to spend time creating tables, specify field types and setting primary keys, etc. Drag and drop and you&#8217;re done.<\/p>\n<p>For those who need additional capabilities on their forms such as automatically summing up fields based on certain selections made can use the script builder to easily add business rules and streamline business processes.<\/p>\n<p><img decoding=\"async\" class=\"alignleft size-full wp-image-5729 lazyload\" title=\"Deluge Script\" data-src=\"https:\/\/www.softwareforenterprise.us\/hub\/wp-content\/uploads\/2011\/03\/Deluge-Script.png\" alt=\"\" width=\"270\" height=\"211\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 270px; --smush-placeholder-aspect-ratio: 270\/211;\" \/>The online scripting language which is integrated with Zoho Creator is known as Deluge or Data Enriched Language for the universal Grid Environment.<\/p>\n<p>Basically anyone with some programming skills can pick up Deluge pretty quickly.<\/p>\n<p>Overall I find Zoho Creator a stable, dependable and reliable platform as a service (PaaS).<\/p>\n<p>The thing that can make Zoho Creator even better is video based tutorials for beginners to learn step by step on how they can create their very first online application using the tool.<\/p>\n<p>Please note that there are so many more Zoho Creator features that I may have missed mentioning. For more details and info about this simple online database builder, do check out <a title=\"Zoho Creator\" href=\"https:\/\/www.zoho.com\/creator\" target=\"_blank\">Zoho Creator<\/a> today.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>A friend recently asked if I know of any freelancers who could help him create a simple MS Access database for his team to easily add, edit and delete rows of stock exchange related data on a daily basis. I asked him why he mentioned MS Access specifically\u00a0just to be able to store and capture [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":5722,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"slim_seo":{"title":"ZOHO Creator - a simple online database builder - Software for Enterprise","description":"A friend recently asked if I know of any freelancers who could help him create a simple MS Access database for his team to easily add, edit and delete rows of s"},"footnotes":""},"categories":[11],"tags":[],"class_list":["post-5609","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-databases"],"_links":{"self":[{"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/posts\/5609","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/comments?post=5609"}],"version-history":[{"count":0,"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/posts\/5609\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/media\/5722"}],"wp:attachment":[{"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/media?parent=5609"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/categories?post=5609"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.softwareforenterprise.us\/hub\/wp-json\/wp\/v2\/tags?post=5609"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}