There has been requests from users like Ted Hughes for automatically filtering picklists based on selection in the previous picklist. This can be done very easily now.
Let us take a Bug Tracker application as an example. This simple application has just three forms.
1. It has a form to fill in the modules. e.g. In the case of Zoho Creator, it could be user interface design, deluge script etc. See a list view of all the modules added.
2. It has a form to fill in the team member details. It has the name of the team member and the module he works for. See a list view of all the team members (and the respective modules).
3. It has a form for filing issues. Each of the issues filed has to be assigned to the appropriate team member. Since we have already defined the person in charge for each of the modules, it will make more sense if the items in the ‘Assigned to’ picklist gets updated every time the module is changed, listing only the relevant entries.
If ‘Persistence’ is selected in the ‘Module’ picklist, only those members of the team, in charge of the ‘Persistence’ module should get listed in the ‘Assigned to’ picklist. In this example, Edward and John should get listed.
This can be done by writing an ‘on change’ event for the ‘Module’ picklist.
Deluge code snippet:
|must have Module
type = picklist
values = Add_Module.Module_Name
team = team_member [Module == input.Module];
for each t in team
The code snippet given below fetches all the members of the team, in charge of the selected module.
|team = team_member [Module == input.Module];
Since the variable team is an array, it has to be iterated to get the properties of each team member.
|for each t in team
The names of those team members in charge of the ‘Persistence’ module are added to the ‘Assigned to’ picklist.
I have taken a very simple use case to explain this feature. But I am sure our users will exploit its full potential and use it in a lot more interesting ways to enhance their applications.