Challenge New Features: Email Results To Candidates, Rich Text In Answer Options

Posted by Posted on by

Hello again from the Zoho Challenge team! As you might have known, we’ve constantly added new features to Zoho Challenge based on user feedback. Previously, we’ve added

bulk questions import


comprehension questions


embedded tests



. This holiday season, we’ve refreshed the application with a couple more features that we think you’ll find useful.

Automatically Email Test Results To Candidates
Previously, you were able to show your candidates the results of an assessment immediately, at a specific time or after test closure. From now on, your candidates will be able to receive an email with test results once they complete a test. All you need to do is enable the

‘Send results by email automatically’

option when you assign tests to your candidates.

The email that your test candidates will receive will contain the maximum and obtained marks, the test result (pass/fail) and a chart that shows correct vs. wrong answers. Students use email not just as a means of communication but also as a tool to archive important information. This new feature will be of great use to them and we encourage you to use it when delivering assessments.

Add Rich Text To Answer Options
Zoho Challenge’s powerful text editor that allows you to add rich, formatted and multimedia content to questions is now available for answer choices. You can leverage the same editor to add rich text to your answer options. We believe this small addition to the already existing power house of answer types and options will help you in providing improved and refined answer choices to your students.

We’re continuously improving Zoho Challenge based on what users have been telling us. If you’ve got anything to say, don’t forget to tell us. We’re always active in the



on Twitter


Zoho Invoice vs Zoho Books

Posted by Posted on by

Ever since we launched Zoho Books one question we hear over and over
again is “What is the difference between Zoho Invoice and Zoho Books?”.
Here’s a clarification for those of you who asked and for those who
have the same question.

Zoho Invoice is an online invoicing software
which helps you get your invoicing done. It has all the essential
functionalities related to invoicing like estimates, quotes,
multi-currency support, online payments, credit notes, customizable
invoice templates, an iPhone app for invoicing on the go, a web
app(beta version) for invoicing from android & other mobile devices
and multi-lingual support.

online invoicing software vs online accounting

Zoho Books on the other hand is a comprehensive online accounting software
that lets you get your accounting done online. With Zoho Books you can
keep up with the your income and expenses, manage your banking and
credit card transactions and work with your accountant online. Within
Zoho Books you will see a comprehensive invoicing module which includes
all the features of Zoho Invoice, except for the ones listed below:

  • API
    - The Zoho Books APIs are in the making. If you are planning to
    integrate with us you may need to hold on for a little while more.
  • Contextual
    Gadgets- We are integrated with Google Apps, the only missing piece is
    the contextual gadget, which will be included soon.
  • iPhone app- Again we are saving this for later. But this is certainly on our agenda.

Here are the answers to some popular questions on the same topic:

How do I choose between Zoho Invoice & Zoho Books?

If all you require to do is manage invoices and expenses online then go for Zoho Invoice. However, apart from plain invoicing if you want to track your purchases, reconcile your bank and credit accounts, view a complete snapshot of your business, generate performance reports like Profit & Loss and Balance Sheet then Zoho Books would be a better fit. 

The equation you’ll need to remember is Zoho Invoice = Accounts Receivable while Zoho Books = Accounts Receivable + Accounts Payable  + more…
Will Zoho be adding more features to Zoho Invoice?

with hundreds of thousands of users on board, we need to keep Zoho
Invoice updated and young as ever.  The possibilities of interesting
inclusions are endless. We will be adding features to both Zoho Invoice and Zoho Books. 

I am on an elite plan in ZI, a little
birdie tells me that the $24 subscription to Zoho Books gets me
unlimited invoices. Can I switch…

Why not? We’ll help you switch if you wish to. You can dial the Zoho Invoice support toll free and our support folks will switch you over in no time.

before signing off, we’d like to thank everyone for the overwhelming
response to Zoho Books. We couldn’t have asked for more. Thank you!

Follow Zoho Books on Twitter and Facebook. And Zoho Invoice on Twitter and Facebook.

Explore Zoho Reports Series: Part I – Formula Column

Posted by Posted on by

In this series of posts, you will get to know the little known, yet very powerful and useful features of Zoho Reports. In this first part, let’s explore the ‘Formula Column’ feature.

Formula Column
In addition to the base columns a table has, you can add a new column with a custom formula based on one or more of the table’s other columns. For example, say you have two columns for ‘Sales’ and ‘Cost’. You can define a custom formula ‘Sales’ – ‘Cost’ and add it as a formula column called ‘Profit’. That’s a simple example with the difference function. There are a lot more functions listed based on type – Date, Numeric, String, Aggregate, Statistical and General. Let’s see examples from each of these function sets.

Date: You can manipulate values of a given date column.

Example: Let’s say you have a column that has date values like 2011-01-01
12:30:48 (or say Jan 30, 2011). And you want to have a column that lists the corresponding day of the week. You can define the formula as weekday(“Date”).


Let’s see another scenario for a date specific formula column. Say you want the number of days between a lead coming in and the sale getting closed. Or say, the number of days it takes to close a support ticket. The formula to be used would be datediff(“Date1″, “Date2″).


Numeric: Numeric formulas ranging from absolute value to mod to log to exponential to trigonometric functions like sin-cos-tan are all handled here.

Example: Let’s say you have some test data values in three columns and you want to list the greatest value of each row. You can define the formula as greatest(“Column1″,”Column2″,”Column3″)


This type of formula functions deal with text values (known as ‘string’ in programmer lingo). Knowing the length of a given string, string concatenation (joining of two textual values), finding a sub-string, upper/lower case conversions etc are all dealt with here.

Example: Here’s a scenario. In one of the Date functions above, we saw weekday(date). What if you want only the first three characters of the weekday to be displayed? You can define the formula column like left(weekday(“Date”), 3)


Aggregate & Statistical : Functions like count, sum, average, variance, standard deviation, mean, median, mode etc

Example: Suppose you want to calculate the column’s average and find the difference for each row. You can have the formula as Column1 – Avg(“Column1″). Or say you want to calculate the percentage of a sale value to overall sales. The formula will be (“Sales”/Sum(“Sales”))*100


General: If and ifnull functions.

Example: There are instances where you won’t like to have a null value. In such a case you can have a formula defined something like ifnull(null, 0). All cells with null values will get replaced by zero. Consider another scenario. Say different product categories attract different taxes. We can calculate the tax with the formula if(“Product Category”=’Stationery’, “Sales”*0.05, “Sales*0.08). This calculates the sales tax for Stationery as 5% and for other product categories as 8%. We can even have nested if conditions. Like if(“Product Category”=’Stationery’, “Sales”*0.05, if(“Product Category”=’Furniture’,”Sales”*0.10,“Sales”*0.08))


Hope you now know how to put Formula Columns to best use in Zoho Reports! Do let us know how you use or intend to use formula columns and keep your feedback comments coming.

You can follow us on Twitter and Facebook.


Cricket World Cup Tracker

Posted by Posted on by
Do you follow Cricket?
If you do, you must certainly be excited about the ICC Cricket World Cup 2011 that is going on right now.

So to help you follow all the action, we’ve quickly tossed up a Zoho Sheet that gives you a full view of the tournament. You can see the schedule, teams, group standings, and of course, statistics.

For a hot spot on a particular day’s match and the Group Standings, you can embed the following snippets in your website/blog:

Today’s Match Snippet:

<iframe src=’′ frameborder=’0′ style=’height:102px;width:288px’ scrolling=’auto’ marginwidth=’0′ marginheight=’0′>&nbsp;</iframe>


Group Standings Snippet:

<iframe src=’’ frameborder=’0′ style=’height:511px;width:432px’ marginwidth=’0′ marginheight=’0′ scrolling=’auto’> </iframe>



Update: Google-Zoho Cr-48 Giveaways

Posted by Posted on by

We recently announced this joint promotion event with Google to give away Cr-48 Notebooks to Zoho users. The results are now out. A number of Zoho users were selected from this promotion program. UPS will be delivering Cr-48 Chrome Notebooks to select Zoho users soon. Go on, ‘Work. Online’ with the Cr-48 and let us know how it goes :)

ps: Watch the Google team give a demo of the Chrome Notebook and its features:

New Zoho CRM video tutorials, by our Customers & Partners

Posted by Posted on by

It always feels good to hear from our users about their Zoho CRM experiences. This time around it’s a collection of videos created by our Customers and Partners on how Zoho CRM helps to manage their businesses.

Here’s the list:

By T3 Direct

Videos by Ryan Brown

More videos by Ryan here.

By Cazoomi

And one more, by Market Moose

Thank you RyanT3 DirectCazoomi and Market Moose for these videos. We also invite all of you to share any Zoho CRM video tutorials that you may have created. Let us know, and we will feature them in our blogs.

As always, keep your comments and suggestions coming in. And you can connect with us on Facebook or Twitter.

Zoho@Zoho: Tracking revenue with a Zoho Creator application

Posted by Posted on by

We’ve been showcasing an application every week, that talks about the unique use-cases

Zoho Creator

is capable of catering to. Today, we are on the verge of completion of a hopefully successful series,

Zoho@Zoho. If this series has kindled the creator in you to create apps for unique uses, then we have succeeded.Revenue Tracker is this week’s application, and our CEO, Sridhar, intends to use it. We have not deployed it yet, which is why I say, “intends to use it”.
It all started when we happened to overhear Sridhar grumbling about
unclear data while reviewing numbers one day. His main concern was the
fact that data was accurate, but not clear enough to make future
projections from. Reports too, were not so satisfactory. It was all maintained on a spreadsheet. Well, several of them, to be precise. Each seller would create a spreadsheet with the statistics for his / her region. At the end of the month, all these spreadsheets would be consolidated. This bringing-together of  multiple spreadsheets had to be done manually, and it was a very monotonous job. The total revenue brought in by each product in all regions would be calculated, and the final report would be emailed to Sridhar. This was how they had been doing it. No wonder he grumbled.

This use-case was meant to be handled by Zoho Creator. There was a complexity, however. The data we were to handle was too valuable to play around with. So, before deploying the application, we decided that it would be better to import all the existing data first. We can always modify the application to suit real-time scenarios, and customization is child’s play with Zoho Creator.
The approval module and the business intelligence are yet to be incorporated into this application. This would enable the administrator to grant access to every reseller and sales representative, thus allowing them to enter the details directly into this application. As integration between Zoho Creator and

Zoho Invoice

strengthens, we can employ other means too, like a schedule that would automatically fetch all invoices created for the day from Zoho Invoice, into this application.

Try the application

. Never mind the data, because it is not what it looks like ;)With that, we wind up this series of Zoho Creator applications categorized under Zoho@Zoho. Thank you for all the suggestions and comments throughout the series.

Apps showcased till now:
Rebranding Management,Hall of Shame,Tweet StreamAd Tracker,Reseller Portal,Download TrackerIT Asset Management,Support Call Tracker,New Employee RecordTravel ManagementCourier ManagementCab Booking