Skip to main content

Zoho Creator Vs Round one

Zoho creator is an online database system which allows users to create application by dragging and dropping things into place. It also supports importing databases like Ms. Access, Excel etc. It also supports variety of export types as XLS, CSV, TSV, HTML, PDF, JSON, RSS. All this is Googled, yes it is, but I am really looking for here is can Zoho be used to replace application? Why?

A person is always lookout for a cheaper alternative for a custom solution, a penny saved is a penny earned. The two systems were tested for the Model- View- Controller pattern and score accordingly.

The things tested in the two system with respect to data model where,

  1. Does it support real-world relationships?
  2. Can we set up validation rules

Like Zoho Creator can create fields and forms using drag and drop functionality. One of the good thing about this is we can add validation rules using drag and drop. Lookup functionality also exists for relationship between two objects. We can quickly add a many-to-many bidirectional relationship. Creation of Database is really sophisticated and powerful in Zoho creator.

Zoho Scores full 10/10 in Model is still 8/10

The things tested where

  1. 1. How easy it is to write a code
  2. 2. How is If- Else block implemented.
Zoho supports more like scripting code and not object oriented. It took a while to figure out the code that was to be implemented. Zoho creators offers template like IF ELSE block, but for a native user it is very difficult to use the scripting language.

In we have multiple options like the very basic formulas of validation rules and the powerful object oriented Apex triggers. While Zoho does provide database level triggers, the script statement makes it very hard to understand.

Zoho Scores 6/10 8/10

View is the most important part of any enterprise level system. Right from corporate branding to creating colorful visual and attractive pages this is one place where Zoho has a lot of room for improvement.

Zoho Creator does not allow the user to change the interface vastly, in fact Zoho Creator is probably the worst application for changing the interface so it meets a certain persons/company’s needs. It offers very less option to customize its interface, like with Visualforce and Sites we can completely change the interface but with Zoho Creator this seriously lacks.

Zoho Scores: 3/10 8/10

Zoho creator has its own strength as far as creating small, excel based application. I created and deployed a survey tool for a group of friends. Zoho Creator is not comparable to the level of customization provides in terms of visual changes and controller. It is good to create small Excel and Access based applications that can be used internally. Not good to create an enterprise level software yet. 

But team Zoho has not disappointed me, so far, and I hope they will come up with a challenging tool soon.

Disclaimer: This post is done by an individual developer and is for your information only, before taking an executive decision please review the system thoroughly before jumping to conclusion.


  1. Great post., Zoho creator and Caspio are just 3 of the few online database providers that provides Performance Transparency. Check this article to know more:


Post a Comment

Popular posts from this blog

Video: Top ten tips on how not to ruin Salesforce implementation

Another presentation for the London Salesforce Developer Group using mobile app. 
When it comes to Salesforce development, we all know what it takes to deliver stuff. Having a certified professional helps you gain a knowledgeable partner but what about the things such as common sense?  We all know how to deliver things on client requirements but what about things that are not mentioned by the client. We will be discussing in details things that will enhance the user experience, focus on tips to read your customers mind and have a bit of perspective on the user experience.

Cache me if you can: What you should know before daring to set URL parameter on visualforce

If someone gave me a pence for every time there was an SOQL query in an APEX Class without using Limit or a condition during a code review, I could afford a Lamborgini this month. Sigh. If only. We make it a habit of going digging for data, at the very moment we need it. The crux of this problem happens when you have chain classes which are independent of each other. Each class needs the reference from a single record and we have to query for that record every single time.

While we don't see it, every SOQL query has a cost to it, and it does not go in my Lamborghini fund, however, it should. In a recent project, we had to construct an Account 360 page that could fetch information from different integration points. The page was also called using a live telephony integration, which could pass the phone number for the account. This required an ability to keep in context the Account that was on call.

Passing the Account id in URL parameter was a valid option, however, any manipulatio…

Four secrets to improve the usability of your visualforce/Lightning pages on Salesforce

In the immortal words of a certain machine returning back in time, I am back. For now. After procrastinating for over a year and drafting a lot of rants- I am back with a very important coding lesson for you. For now.

When we are designing a Visualforce page or an app or a lightning component (added that only to trick google) or any web page for that matter, we often tend to wrap up things quickly. Ask anyone on the team, how to design a good User Experience? and the person will immediately throw buzz words like Bootstrap, angular and other useless libraries (did someone squint?)

Ok, Bootstrap, Angular-Js, and all the libraries are really cool and are useful in designing a fabulous UI. They are helpful in creating responsive pages that will work on all the devices but this post is not about those. Nope. For the purpose of this post, all the external libraries and buzzwords you use to decorate your resume are useless. (Adding Angular JS in your resume for a Salesforce consultant posit…