form shortlisted_candidates
{
    displayname = "Shortlisted Candidates"
    Candidate_Name
    (
        displayname = "Name of the candidate"
        type = picklist
        values = New_Applicant.Applicant_Name
    )  
    Hiring_Manager
    (
        displayname = "Hiring Manager"
        type = text
        width = 30
        maxchar = 30
    )
    Resume_Status
    (
        displayname = "Resume Status"
        type = picklist
        values = {Call for a Written Test,   Call for an Interview,   Completed Written Test,   
		Being considered for the Job,   Job offered,   Rejected}
        on update
        {
            candidate = New_Applicant[Applicant_Name == this.Candidate_Name];
            if(this.Resume_Status == "Call for a Written Test")
            {
                sendmail
                [
                    To       :  candidate.Email_ID
                    Subject  :  "Reg application for job posted at recruitment.zohocreator.com"
                    Message  :  "Hello " + this.Candidate_Name + ",<br><br>Please
appear for a written test to be conducted on " + this.Date_Field + "<br> <br>  
Best Regards,<br> Recruitment Manager"
                ]
            }
            else if(this.Resume_Status == "Call for an Interview")
            {
                sendmail
                [
                    To       :  candidate.Email_ID
                    Subject  :  "Reg application for job posted at recruitment.zohocreator.com"
                    Message  :   "Hello " + this.Candidate_Name + ", <br>
Congratulations. You have cleared the written test. Please appear for
an interview to be held on " + this.Date_Field + "<br> <br>  
Best Regards,<br> Recruitment Manager" 
                ]
            }
        }
    )
    Date_Field
    (
        type = date
    )
    Comments
    (
        type = textarea
    )
}