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

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