What can Zoho Creator do for you?

May 3rd, 2008 by Lockworld Herald

I’m constantly amazed at the wide variety of uses I can come up with for Zoho Creator. When I first stumbled across the application, I thought it might be of passing use to collect some basic information from visitors to my Web site. Over the last few months, however, I’ve experimented with a wide variety of less-than-typical uses for an online database tool.

For small business and personal Web site owners without access to a lot of IT support, Zoho Creator can easily serve as the functional back-end of your entire site, allowing you to develop some sophisticated and interactive applications for your Web site. Thanks to Zoho Creator, even a relatively novice user can add some powerful functionality to an otherwise dull Web site. As users become more familiar with Zoho Creator, there is almost no limit to the number of powerful applications that can be developed for any site.

Here are some examples of what I’ve built into my site using Zoho Creator

  • E-commerce product catalog
    This is my personal favorite…using Zoho Creator, I was able to develop an easy-to-update catalog of products for sale on my site. The catalog is completely integrated with PayPal’s functionality to allow me to sell directly from my Web site. At any time, I can change a price, image, or details about my products, or add new products to the catalog. The changes automatically get loaded into the PayPal script on the page, so when the user clicks “Buy now” or “Add to cart” I can be sure they are always paying the current price for my products. By using Zoho Creator to hold the price, product image, and description, I know that I only have to make my changes one time to ensure that all of the information is accurate in my catalog, RSS feed, and product detail pages.
     
  • Add comments to your Web site
    Although I haven’t done this for my site, it is fairly simple to use Zoho Creator to add a “comments” page or section to your Web site. All you need is to create a basic form with a field for a name and a multi-line field for the comment. Then, you use the Zoho-provided scripts to embed the blank form and a display of the form data onto a given page on your Web site, and viola, instant comments for your site.
     
  • Redirect links to shorten URL
    I use Zoho Creator in the back end of my Web site to offer URL shortcuts to pages within my Web site. For example, http://lockworldherald.com?opencd takes the user to http://lockworldherald.com/documents/productdetails.aspx?product=1. This can be a very useful way to create shortened or personalized links to any content on the Web, not only to pages that can be found on your site. But instead of using an external service, you can brand all of the links to have your own domain in them. I’ll be detailing the steps involved in this process soon on The Web for You.
     
  • Site navigation
    I use Zoho Creator to add navigation functionality to some of my pages. For example, http://lockworldherald.com/documents/articles.aspx contains a list of articles available on my site. This list is maintained in Zoho Creator. The nice thing about this is that I can customize which types of links are included. Compare the link above with http://lockworldherald.com/documents/articles.aspx?test=simplificationactionism. On the first page, I simply list a table of contents showing what’s available on my site (and not including items that fall into certain categories, such as DRAFT or TEST). On the second page (after the example article), I have listed “related links” to other articles that fall in the same category (“Test” in this example). You will notice, on closer inspection, that the same page is loading in both of the above examples, but that I’ve used URL variables to tell the page whether to load the default content or a specific article…so I created/coded one page, and can re-use it for a variety of contents. In this example, I’ve used Texty to create my own unique content, and then pasted the appropriate information into a Zoho Creator database that allows me to load the content or the table of contents onto my page, depending on the parameters passed in the URL. That’s particularly nice if you don’t have access to make changes on the fly to your Web site, and don’t want to spend a lot of time uploading new pages every time you make a change. It takes some advanced javascript to get everything set up correctly, but when it’s done, it sure saves a lot of time.
     
  • Content management
    I use Zoho Creator as a content management tool for many pages on my site. From articles to resources to projects to products, many pages on my site get their content directly from Zoho Creator. I typically use Zoho’s JSON feeds to display the contents from a given Zoho Creator application on my Web pages, which gives me the freedom to code each page once on my Web site, and make changes on the fly at any time from Zoho Creator. Also, this gives me the ability to allow user contributions to some of my lists (Such as my recommended resources), while denying user contributions in others.
     
  • RSS Feeds
    Although it’s not a perfect solution, Zoho’s built-in support for RSS feeds can be a very useful tool for keeping your visitors informed about what’s happening on your site. The only problem with this is that all of the RSS feed links point to the record’s display page in your Zoho Creator application, and not to a link that you specify within the database. Still, it’s a useful way to get the news out to the people who need it without investing a lot of time and energy in creating and maintaining a separate feed.
     
  • Newsletter mailing list
    I am currently working on a project to create and deliver an e-newsletter using Zoho Creator’s built-in SendMail feature. In this particular application, I have one publicly-available sign-up form that people can use to subscribe to the newsletter, as well as several private forms that I can use to customize both the template and the contents of the newsletter. I’ve been successful in creating a working system, and I’ll provide the detailed steps for making your own (it involves some pretty heavy Deluge scripting, if you do it the way I’ve done it) in an upcoming post on The Web for You.
     
  • Unlimited business applications
    If you have a small business, there’s no limit to what you can use Zoho Creator for on your site. You can use it to allow people to request a quote for your products/services (and have the results of the quote automatically e-mailed to them after they’ve filled out a form), display (and manage) your list of products available, solicit feedback about your products/services, send out e-newsletters, or do just about anything you need to do. At some point, I’d like to explore how Zoho Creator can be used to create a members-only section of your Web site. In principal, it would be a simple use of Zoho’s JSON feeds and some javascript on your site. The javascript would load both the members list and the page contents on your site and ask the user for an identification. Once confirmed, the page could then load the appropriate content on the page.

What I originally took to be a “fun toy” to play with for the rare times I needed to collect some information from users has turned into an indispensable tool for building a dynamic Web site. I’ve never encountered such a powerful application that was available absolutely free of charge!

So, whether you just want to gather some quick information from your users, create a “comments” section for your Web site, or develop advanced enterprise-grade applications for your personal or small business Web site, there’s no better application to use than Zoho Creator.

That’s all for today…

Blogged with the Flock Browser

 



 

Adding a more advanced RSS feed to your site

March 31st, 2008 by Lockworld Herald

In my last post, I explained how you could use del.icio.us to add a simple RSS feed to your site. The benefits of this method mainly lie in your ability to quickly and easily add any Web page to your feed, particularly if you make use of the browser buttons available from del.icio.us. Just navigate to the page you want to include in your feed, click the button, and enter a title, description, and tags. This method also allows you to easily create many feeds, and add items to as many of the feeds as you need all at the same time.

While this method should work well for the average Web site owner looking to create an RSS feed, it might not be suitable for every purpose. The two primary limitations to using del.icio.us to create and publish your RSS feed are the lack of rich text editing, and the 255 character limit to the description field. Many users may want to include more information in their RSS feed, or include graphics, links, and other information. For these users, del.icio.us may not be the best solution.

However, before you start creating a detailed RSS feed with lots of custom information in the feed itself, you need to understand the wide variety of standards for feed readers. Most importantly, it is important to understand that many feed readers are unable to capture both the Web page and the feed details together. Most online feed readers will only capture the description you enter into your RSS feed’s description section, and will give the users a link they can click on to view the page that you’ve referenced in the feed’s URL section. Locally installed feed readers, on the other hand, may have any number of different ways to display this information. For example, the feed reader I use at home is the built-in RSS aggregator available in Mozilla Thunderbird. This feed reader allows me to choose whether I want to view the feed details for all of my feeds, or just view the Web page (which is not available when I’m offline). I don’t have the option to customize this for individual feeds, and I don’t have the luxury of viewing both automatically. This presents a problem for me, since I read most of the RSS feeds I’ve collected while I’m offline. If I set my preferences to automatically show the Web page, I get a blank screen when I’m offline. However, if I set my preferences to view the feed details only, I typically get only a short paragraph or two, and have to wait until I’m online to read more. There are other applications, however, that do a better job of handling the problem of how to deliver a Web page and an RSS feed together. My favorite is the Microsoft Outlook plug-in, IntraVnews. This handy plug-in is free for personal use, and manages to download the RSS feed details as well as a copy of the referenced Web page. This is particularly handy for news feeds, as the articles may not be available on the Web for a long time. But since they’ve been physically downloaded and embedded into an Outlook message post, you can read them whenever you want.

Understanding the different ways your viewers will see and interact with your feed is very important. For example, if you are creating a feed that often refers people to external Web sites, you need to understand that many of them may never see your RSS feed description, which explains why the link was chosen for your feed. In these cases, it might be useful to use the Awesome Highlighter recently featured on Lifehacker. This service allows you to send people to a unique URL that will display the page you want them to see, with the text you want them to see highlighted for them. It might not be as good as providing a brief description of the page, but it’s certainly better than nothing. Incidentally, the service is also good for providing a shortened URL to the page your referencing.

All of this is very important to understand if you’re serious about publishing an RSS feed, but it’s a bit beside the point for today. Since del.icio.us may not be the best solution for everyone’s RSS needs, I wanted to point out a way that you can create a free RSS feed that can contain more details, formatting, images, and other links (but try to remember that some people may never see all of the “extra” details you provide). If you need to provide a more detailed RSS feed, simply start a blog using one of the many free blogging tools available, such as Blogger.com, TypePad.com, WordPress.com, or the like. Once you’ve created your blog, you can easily add new posts with full rich-text capabilities. If you want to point the RSS feed to a location other than your blog, simply enter the appropriate URL into the “Link” field under your post title (at least, that’s where it is in Blogger…other services may vary, but should give you the option to specify a URL for your post). Your resulting RSS feed will simply refer to the Web sites you’ve entered, and no one will ever have to know that the feed originated with a blog, especially if you’re using FeedBurner to track your feed traffic.

Between del.icio.us and Blogger, anyone can quickly and easily create an RSS feed in minutes. And, if you follow the instructions in my last post, you can track how many people are subscribed to your feed, allow e-mail subscriptions, and enable visitors to your Web site to automatically “find” the RSS feed(s) you’ve made available.

If you’re still not sure about starting an RSS feed, here’s a quick tip….go ahead and start one using either of the two methods I’ve described (or both). Your feeds will never be noticed until/unless you start promoting them by telling people how to find them. So, if you need to practice a little bit before you’re ready to commit to creating a formal RSS feed for your site, you can!

Once you’re confident that your RSS feed will be a valuable tool for your site visitors, just embed the links to it on your site and let people start subscribing. One word of caution, though…don’t get too hung up on checking your feed’s stats on FeedBurner. If you have a personal or small business Web site, you’re not likely to get thousands of subscribers to your feed right away, if ever. The stats FeedBurner provides are simply interesting information, but unless you have some serious goals for your Web site, trying to keep too close a tab on your stats will just be a waste of time, and likely a huge disappointment. As I’ve said before, the average personal or small business Web site is never going to directly compete with the “big dogs,” so don’t go in believing that just because you have a Web site you’ll have thousands of people visiting your site every day.

That’s all for today. I hope you’re ready to create your RSS feed to start delivering your updates directly to the people who need to or want to know, rather than waiting for them to check in with your site.

 



 

Adding an RSS feed to your site

March 23rd, 2008 by Lockworld Herald

A few months ago, I thought I was “back” to blogging, but it turns out I still had some unresolved issues. I’ve had a lot of trouble lately getting online to post to this blog and continue my explorations of all things Web-related. Fortunately, however, I think I’m finally ready to get back online on a regular basis to keep all of the tips and tricks coming here on The Web for You. I’m not making any promises at this point, but I’ll do my best.

In my last post, I told you I’d be describing how to add an RSS feed to your Web site. When I first conceived of this project several months ago, I wasn’t sure how to proceed. For one thing, Microsoft Office Small Business Live (MOSBL – formerly Microsoft Office Live) had several restrictions in place that made it difficult to add an RSS feed to your site. While several of these restrictions may still be in place if you’re using the default Web page editor, the good news is that even the free (Basic) version of MOSBL now allows you to use “third-party” design tools to build your site. That means that you’re no longer restricted to using only the existing design tool, and you can write your own HTML codes, including the META tags needed to add an RSS feed to your site (more on this later in this post).

Aside from the design issues with MOSBL, I was still at a loss with how to proceed. I came up with several ideas to use Web-based RSS-creation tools (such as the now-defunct FeedCraft as well as my favorite app, Zoho Creator). Unfortunately, both had serious drawbacks. FeedCraft, when it was available, only permitted users to create a single RSS feed. This was workable, but not ideal. Zoho Creator worked well, but unfortunately the links would only take you to the Zoho Creator record view, and not directly to the page referenced in the feed. Due to these drawbacks, I started experimenting with several offline feed creation tools, such as ListGarden (A very handy, free, and portable application that allows you to easily create both an RSS feed and an HTML version of the feed to display on your site). While these worked adequately, they all shared one common flaw…I had to manually upload the RSS feed to my Web site every time I modified it.

At long last, I realized that I was wasting my time. The simplest (and most efficient) tool for creating an RSS feed was right under my nose from the very beginning…Del.icio.us. I imagine most of you are familiar with del.icio.us, but in case you aren’t, it’s one of the first and most successful social bookmarking sites around. Del.icio.us allows you to quickly and easily bookmark any Web page and tag it with any tag you want. The piece that I was forgetting about was that del.icio.us allows you to turn any tag (or your entire set of bookmarks) into an RSS feed automatically. After spending long hours with other solutions, I finally realized that I had the perfect tool to build an RSS feed for my Web site with my old friend, del.icio.us.

Getting started is simple…if you don’t already have a del.icio.us account, sign up for one at http://del.icio.us/ (free). To make things easier for you, del.icio.us offers you “browser buttons” – links you can add to your bookmarks that allow you to add new items to your del.icio.us favorites with just one click. Alternatively, you can manually add a favorite by clicking on the “new post” link. There are a few fields you need to fill in (filled in automatically if you use the browser buttons): The link URL, a name for the link, a description, and your tag(s). The first two are self-explanatory, but the description is the field where you can enter the text you want your readers to see when they click on or subscribe to your feed (sadly, there is a limit to the number of characters available, and it only supports plain text). The tags are where things get really useful. Create a tag that matches the name or title of your RSS feed, and that’s easy to remember (I might use LWHRSS for “Lockworld Herald RSS feed”). Once you have at least one item bookmarked, you can get the RSS feed link by going to del.icio.us/{username}/{tagname} and looking for the “RSS” link near the bottom of the page.

TIP: If you want to offer multiple RSS feed options, just create different tags to signify the different feeds. The nice thing is that you can add a new item simultaneously to as many of your feeds as you want just by adding the tag for each of your feeds to the same item.

Once you have the link, you’re ready to get going. But I’d recommend adding at least one extra step before you publicize your feed…connect it to FeedBurner to track your subscribers and allow people to subscribe in any reader or via e-mail. That way, you can keep an eye on how many people are subscribed to your RSS feed at any point in time.

Setting up FeedBurner is as easy as creating a del.icio.us account. Simply log in or create a new account, then enter the URL of your RSS feed (the one you copied from your del.icio.us page) into the “Burn a feed right this instant” section. You will have to enter a feed title, so pick something short for your feed title (For example, this feed’s title is the easy-to-remember TheWebForYou. This will form the basis of your feed’s new URL (for example, http://feeds.feedburner.com/TheWebForYou). Once you’ve added this feed to FeedBurner, you will be able to generate a new, unique URL for your feed. This FeedBurner-based URL is the one you want to distribute to people, as it allows FeedBurner to track how many subscribers you have.

Once you have your new feed’s URL, you’re ready to add it to your Web site. The simplest way to do this is to just add a link to it on one of your Web pages. However, many modern browsers offer the ability to “auto-find” RSS feeds on a site. This is based on a META tag added to the HEAD section of the page’s HTML contents. For example, I’ve added the following META tag to each of my pages:

<link rel=”alternate” type=”application/rss+xml” title=”The Web for You (Blog)” href=”http://feeds.feedburner.com/TheWebForYou”>

The “rel” and “type” arguments should not be changed, but the “title” and “href” arguments should be customized to your new feed’s title and URL, respectively.

I’ve used one of my content management systems (ajaxincludes) to add this code (along with similar codes for each of my RSS feeds) to every page of my site automatically. First, I created all of the codes in a separate file, called inc-meta.inc (you can name it anything you want). Then, I used the AjaxIncludes script to dynamically add this to every page in my site using:

<script src=”/documents/script-ajaxinclude.txt”></script>
<script>
ajaxincludes=”inc-meta.inc”
</script>

In this example, I have the main AjaxIncludes script stored in a separate file on my site at http://lockworldherald.com/documents/script-ajaxinclude.txt (Note: I use the .txt extension because of a javascript-caching restriction with MOSBL that prevents changes in javascript codes from showing up on the site immediately. You can use either the standard .js extension or the .txt extension).

By adding these few lines of script to every page of my site, I’ve enabled most browsers to auto-discover the RSS feeds I currently have to offer. And if I need to add or delete a feed, I only have to edit one file: inc-meta.inc.

By creating your RSS feed using del.icio.us, redirected through FeedBurner, and auto-detected on your site, you enable your visitors to quickly and easily subscribe to your feed using almost any browser, RSS reader, or even e-mail. The whole point of RSS is making it easy for your users to find and subscribe to your feed, and this serves the purpose quite well.

By using del.icio.us to add feed items, you have a quick and easy way to turn links to any Web page (or file, such as a PDF) into a custom RSS feed for your site.

TIP: Want to add an item to your RSS feed, but aren’t quite ready to make it visible to the whole world? You can either create a separate tag called “RSSDrafts” (or something similar that works for you), or just check the “make private” link when you add the bookmark. This will allow you to add the bookmark whenever you want, but wait to publish it until the time is right.

That’s all for today. See you next time (hopefully soon) here on The Web for You.