Work Effortlessly: Spreadsheet View in Zoho Creator

Posted by Posted on by

Every business transaction generates data. In fact, the integral aspect of a company’s profitability is not only capturing the data, but also analyzing it to discern patterns and record it for future action. No matter how much data your business has, converting it into useful information is easy using a spreadsheet. Unfortunately, spreadsheets come with a set of problems: no role-based access permissions, error-prone data entry, different versions and inability to collaborate with coworkers in real time. Bottomline, spreadsheets were not built to manage your database.

Let’s assume Mark is the owner of ‘TastemyWine’ — a winery with a medium-sized inventory of red and white wines. His stock manager, Paul takes care of winery operations and constantly updates their wine database using a spreadsheet. He collaborates with stock managers across different locations by sending spreadsheets back and forth. This results in different versions  and many errors costing TastemyWine winery millions of dollars.

Zoho Creator’s spreadsheet view eliminates these problems by combining the strengths of regular spreadsheets with database management. So let’s take a look at how Zoho Creator’s simple alterations with the spreadsheet view changes Paul’s data management from tedious to effortless.

Import and Export Data:

When Paul initially sets up his database in Zoho Creator, he imports the spreadsheet and changes the view type to a spreadsheet. The user experience of this view in Zoho Creator is no different from his original spreadsheet. With the help of this view Paul could see his data in rows and columns and make necessary edits, just like he did in his original spreadsheet.

Auto-adjust field size:

Paul expects his data to be in one place and in a format that helps him view everything he needs. Using the auto-adjust field size, he views every piece of information without missing a single detail. This feature gives him the flexibility to store and display more information in a single field than he could on a standard spreadsheet.


We all know data is vital to a business, but data entry? Entering and re-entering numbers all day long can be exhausting to say the least. With Zoho Creator, Paul now has a few options to speed up his data entry process. The Cut, Copy, and Paste feature lets Paul update data faster than he could with a standard spreadsheet. As a bonus, he types faster because he uses the keyboard shortcuts.

Zoho Creator Copy- Paste.gif

Additionally, the auto-fill feature gives Paul the convenience of entering the same value for adjacent records and if he makes a mistake, he can simply use the ‘Undo’ or ‘Redo’ feature to delete or repeat the previous action.

Zoho Creator autofill.gif

Zoho Creator undo-redo.gif

With the flexibility of the spreadsheet view in Zoho Creator, Paul’s workday got much easier. If you too would like to make your workday easier, explore the spreadsheet view in Zoho Creator for your database, and share your experience with us.

Prototyping with Zoho Creator: A Unique Use-case!

Posted by Posted on by

Zoho was a platinum sponsor at this year’s CRM Evolution Conference, held in New York on August 10. The event brought together many CRM users and vendors, and although CRM was the focus of most discussions, we were looking forward to hearing about Zoho apps too.

And so, we were happy to hear from Charlie Isaacs, a Zoho Creator enthusiast. In addition to working with Alcatel-Lucent, Charlie also works as a social media strategist for Genesys Lab.

When asked about how Zoho Creator simplified his requirement, Charlie had something unique to tell us: he prototypes using Zoho Creator.

Listen to Charlie explain how he does it:

Whenever Charlie gets a new idea for a project, he prefers to use a prototype to propose his plan. He says, and we agree, that a prototype is almost always more compelling than a 20-page document. Charlie takes advantage of Zoho Creator as he builds form-based solutions. The advantage Zoho Creator has over MySQL, he says, is that MySQL doesn’t allow the association of a form on the front-end.

There is always Oracle and MySQL, but to get something up and running, Zoho Creator is there for me.

In addition to prototyping, Charlie also spoke about an interesting mobile application that he uses to read QR codes, which are looked up in a Zoho Creator database. Based on the information returned, like UPC codes, Charlie then dynamically constructs the menu on the handheld application.

Thank you, Charlie, for sharing with us two very new use-cases of Zoho Creator. We’re glad to hear that it only takes an hour with Zoho Creator to complete the prototypes, versus 8 to 10 hours without it.

Dabble DB Customers: Migrate to Zoho Creator Seamlessly!

Posted by Posted on by

Dabble DB has announced it’s end-of-life. And we happen to have a migration tool ready! We also offer free migration and app-building assistance to all migrants from Dabble DB. With our migration tool, you can reconstruct your Dabble DB application on Zoho Creator, in three simple steps. It is a do-it-yourself tool, give it a try. Or, if you want us to help, we will be glad to build your applications for free.

If you are new to Zoho Creator, watch this video for an overview.

You are not the only ones who are stranded. We’ve already helped a bunch of other customers from Dabble DB, and they are happy with what they got. Meet the others who have already made the move (Indiana Military Organization being one of them), and what they have got to say about us.

We’ll be happy to address any concerns you might have. Tweet out to us @zohocreator.

Welcome Aboard!