ABC is a leading Insurance company in India. The company uses Zoho CRM for managing their customer relationships, and all the details of their customers are saved in the Zoho CRM. The insurance agent saves details about the policyholders into their CRM account. To add data validations, to add custom error messages, to do complex calculations, and to do data correction the company has come up with a list of requirements.

The policyholder information is saved in a custom module named Policyholder. Date of Birth, Age, Category, first name, and last name are the custom fields in this module.

• When the Date of Birth of the policyholder is entered, then auto-populate the field Age.
• If the calculated age is more than 60, then auto-populate the field Category as Senior Citizen otherwise populate as Citizen.
• If the calculated age is more than 80, then display error message "The policyholder should not be aged more than 80".
• The first name and last name entered should be in the upper case irrespective of the case used while entering the details.

• The module for which the Client Script should run.
• Events that trigger the Client Script.
• The page where the Client Script should get executed(Create/Edit/Detail/Clone).
• Actions that the Client Script should perform.

• Client Script with onChange field event for Date of Birth.
• Client Script with onChange field event for First Name.
• Client Script with onChange field event for Last Name.

1. Client Script with field event for Date of Birth

This script is to calculate and populate the field Age based on the value entered in the field Date of birth, populate the field Category based on the calculated age and to display custom error message when the age is above 80. Create a new script by specifying the below values for name, description, event, page, and module. Refer to Creating a Client Script for more details.

​

Copy
 function  getAge(dateString) 
{
    var today = new &nbspDate();
    var birthDate = new&nbsp Date(dateString);
    var age = today.getFullYear() - birthDate.getFullYear();
    var m = today.getMonth() - birthDate.getMonth();
    if (m < 0 || (m === 0 && today.getDate() < birthDate.getDate())) 
    {
        age--;
    }
    return age;
}
let age = getAge(value);

var age_field = ZDK.Page.getField("Age");
var category_field = await ZDK.Page.getField("Category");
age_field.setValue(age);
if (age > 80) {
    age_field.showError("The policyholder age is more than 80");
} else  if (age > 60) {
    category_field.setValue("Senior Citizen");
} else {
    category_field.setValue("Citizen");
}

Here is how the Client Script works.

2. Client Script with field event for First Name

This script is to convert the value entered in the First Name field to upper case. Create a new script by specifying the below values for name, description, event, page, and module. Refer to Creating a Client Script for more details.

Script:

Copy
 var first_name = ZDK.Page.getField("Name");
first_name.setValue(value.toUpperCase());

Here is how the Client Script works.

3. Client Script with field event for Last Name

This script is to convert the value entered in the Last Name field to upper case. Create a new script by specifying the below values for name, description, event, page, and module. Refer to Creating a Client Script for more details.

​

Script:

Copy
 var last_name = ZDK.Page.getField("Last_Name");
last_name.setValue(value.toUpperCase());

Here is how the Client Script works.