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.

Customer Success Story: How Rivet Solutions Re-Established ThinkLABS’ Sales and Marketing Division with Zoho CRM

Posted by Posted on by

logo1Rivet Solutions is a consulting company that provides dynamic IT and business solutions in a variety of divisions to clients around the world. About eight months ago, Ameya Nisal, a consultant for Rivet Solutions, and his team were called in to find a solution to the inefficient marketing process currently in place at ThinkLABS.

thinklabs+logoThinkLABS is India’s largest hands-on science and technology education provider. Since its inception in 2006, ThinkLABS has partnered with roughly 300 primary and secondary schools as well as 23 colleges across 23 Indian states.

“It is the brainchild of Gagan Goel (an Indian Institute of Technology alumnus). He has spearheaded their entire mission,” Nisal said. “ThinkLABS establishes robotics labs in schools to motivate young people through hands-on learning in the arenas of science and technology. They also provide further training to university students—preparing college students for careers in innovative technological fields, like robotics.”

However, ThinkLABS’ growth was being hampered by a very slow sales cycle…

Read more

5 Reasons why businesses should use ACH transfer

Posted by Posted on by

Next to cash, credit cards and debit cards have become the most popular form of payment. According to the 2013 Federal Reserve Payment Study, the number of transactions for debit cards and credit cards is 47bn and 23.8bn, respectively; both will continue to grow at a compounded annual growth rate (CAGR) of over 6.5 percent.

If debit cards and credits cards are so popular, then why are businesses exploring other mediums for making and receiving payments?

The answer lies in the high processing cost associated with each transaction when carried out with a debit card or credit card. This is where an Automated Clearing House (ACH) transfer comes in.

Advantages of ACH for businesses

Here are the 5 reasons that makes ACH, a smarter choice for businesses.

Read more

Shift base from Intuit QuickBase: Free Migration to Zoho Creator quicker than ever!

Posted by Posted on by

Any service that your business depends upon has got to be reliable. Be it your email service or CRM tools or even your database software, there cannot be any compromise. But what would you do, when you find yourself in a situation where, one of your service providers drops a bombshell that they are ceasing operations and handing over the baton to a different company to provide you the product support and services.

Two weeks ago, Intuit announced that they are planning to divest three of their well regarded softwares: Quicken, QuickBase and Demandforce. According to Intuit, QuickBase does not support the current ecosystem of QuickBooks online and it mostly serves customers that are up-market from their core small business customers.

Quickbase Alternative

Intuit had mentioned in its company statement that it has decided to focus and sell products, “to strengthen its ecosystem and align with two strategic goals: to be the operating system behind small business success and to the nations’ taxes in the U.S and Canada.” (Source: Business Wire)

As Intuit seeks to divest its products, this decision leaves QuickBase customers stranded. Need I say more? This is a warning for you to be worried about your business data. QuickBase has no clue who is going to buy them, nor do you have a clue about who is going to handle your data or your product support. We’ve seen it happen with DabbleDB and we’ve seen it happen with Coghead too. We would like to reassure all you QuickBase customers: You need not worry about a place to go!

Zoho Creator is your best-in class alternative to QuickBase. We’ve carried out successful migrations in the past with DabbleDB and Coghead. The best part being, it is effortless. We have loyal and happy customers till date. So rest assured, we have your back!

Testimonials from happy customers

Migration is just the start:

QuickBase users can enjoy free migration and most of all it’s very easy. We also offer 24/7 technical expertise to assist through this migration process. In addition, Zoho Creator integrates with a broad suite of Zoho applications and other external third-party applications allowing you to communicate with data in different systems.

If you’re a current QuickBase customer, we welcome you into the Zoho family. It’s not just migration, you will soon discover all the additional benefits that Zoho Creator brings over QuickBase. See some of our inspiring customer stories to know what Zoho Creator can do for you.

So why wait, learn how to migrate your data into Zoho Creator or reach out to us and we’ll assist you in the process. It’s smooth sailing all the way!

Turn your crashes into solutions— Zoho Projects integrates with Crashlytics

Posted by Posted on by

If you are a business owner, you more than likely have an app or are planning to launch one in the future. You create a project to bring your team together and brainstorm ideas. Your developers don their coding caps and get to work. Your designers create designs to see what works best. Your testers subject the app to several rounds of testing. Your app goes through stages of refinement before finally taking shape and being ready to use. Time to pack and go on a vacation! Until your app crashes. 

projects_crashlytics_blog Read more