Thursday, September 15, 2011

Lesson: Intelligent look-up fields

Lookup fields are a great part of Zoho Creator. They ensure that common data is only entered once, avoiding spelling mistakes. Crucially a look-up also relates data from one form to data in another.

Often though you will want to have the contents of one look-up field be determined by the value of another field, even another look-up field. This is where those new to Zoho often get stuck. It is one of the commonest questions asked on the Zoho forums.

So lets have a look at a scenario. In my App called 'Blog App' I have a few forms and corresponding views. Departments, Employees and the important one, Job Detail.


The Departments form simply provides a way to add new dapartments and provide a description if you want. See Fig 1.

Fig. 1 - Department Form


Monday, September 12, 2011

Welcome to "Zoho To Go"

Welcome!

My hope for this blog is to explain some of the concepts of Zoho Creator in the easiest possible ways. I will aim to use simple, plain English ( I am uni-lingual) and plenty of images.

I will try and generate a simple set of icons to represent simple processes and functions like count(), If, ELSE IF, and Lists/Maps etc.

I hope to be able to explain in an easy to understand way the sorts of tasks used to develop simple applications using the brilliant Zoho Creator platform.

In time I will look to bring in a few guest bloggers to add their wisdom and explain some new techniques for saving time or performing a function.

Thanks
Mark