I showed some of my colleagues the sample story-tracking app I put together on Creator, and response was highly favorable. I can think of many real-world uses for Creator, from detailed story tracking in our newsroom to keeping the list of who's slated to buy Friday morning donuts (making it simple to see who hasn't bought their share and even set up automated e-mail notifications when the list is changed). If you're a fan of structured data on the Web, both available to the public at large and shared with a select list of friends or colleagues, Zoho Creator is definitely worth a look.
Be aware that if you're a true database geek, Zoho Creator isn't a replacement for coding your own database app with something like PHP, Python or Ruby, and MySQL or PostgreSQL. Page layouts are limited (there are two, with no style customizations), and you can't do everything with variables, conditional scripting or sophisticated table joins that you can when coding from scratch. (I was told, for example, that I couldn't use a variable value as part of the name of my view.)
You can embed Zoho Creator applications in your own Web pages, although if you decide to use the apps at Zoho.com, you can't do things such as redirect users to a specific view after they've filled out a form. (They just get a message saying data was successfully submitted, followed by a new blank form.)
I find it occasionally frustrating that Zoho Creator uses its own scripting language, Deluge, requiring yet another new syntax to learn if I want to build functionality that goes beyond drag-and-drop offerings. For example, while it's easy to set up autogenerated mail to a specific hard-coded e-mail address, it took me several hours of poking around and document reading to figure out how to do so based on varying conditions. There's some documentation on Deluge at zoho.com but not too many other places to turn. (Note: Power users might want to check out a blog started recently by several Zoho Creator users, Land of ZC.)
And while most of the application is intuitive, some things are not, such as how to store a "collection" of records and even how to edit existing records (a puzzle shared by several of my colleagues, although easy to use once we found it -- a barely noticeable pencil icon next to records in a view).
Fortunately, though, the Zoho staff is quite responsive about answering questions, even from customers with free accounts. Some of the written responses can be a bit difficult to understand, but they're generally useful. In one case, someone even built me a sample application to demonstrate how to conditionally pull data from one table into another.
Zoho.com has a slew of other offerings, including word processing, spreadsheets, wikis, project management, "notebooks" and Web conferencing, although so far I've stuck with Creator. Many of the other apps, including the Google Docs competitors Zoho Writer and Zoho Sheet, are quite feature-packed, but too much at the expense of elegant UI for my tastes.
Earlier this month, Zoho announced a private beta of Zoho Business, a pay service that will include a companywide administrative console, telephone support and "co-branding." For now, most of the services are free, and the plan is to keep them so for individual use. I expect I'll be building some real apps on the site soon.
Honorable mention
Basecamp
37signals Basecamp project management tool is a slick application. We haven't yet used it here at the Computerworld.com newsroom to track a real project, although we're expecting to try it out later this year. But a colleague at one of our sister Web sites reports that his team of editors regularly uses a commercial Basecamp account to track major feature stories as they wind their way through the assignment, writing, editing and design phases.
Basecamp combines collaboration with project-tracking tools such as to-do lists, milestones and writeboards (private wikis with comments). It definitely keeps to the Rails philosophy that favors elegance over feature bloat -- Basecamp does a few things, not a massive number. Although it has a limited amount of features, Basecamp comes with a sleek, easy-to-figure-out user interface designed for companies trying to entice external clients to use the system.