Module Customization for Educational Sector

Objective: To customize modules in Zoho CRM to meet Zylker University's unique requirements.

  • Create a custom module called Students
  • Create multiple layouts within the Students module to manage different divisions like Engineering and Film Studies.
  • Set layout rules to create conditional layouts in the Students module for defining field dependency.
  • Add multiple line items in the layouts by including subforms.
  • Ensure data accuracy by setting up validating rules.
  • Custom Module
  • Page Layout and Conditional Layout
  • Subforms and Validation Rules
  •  

Create custom module and fields

Zylker University needs a CRM system to manage various activities of their institution. For instance, filling admission forms, sending periodic newsletters to students and professors and so on.

Though Zoho CRM's default sales setup does not meet their requirements, it can be customized extensively to suit their needs. Let's take a close look at Zylker University's requirements and see how Zoho CRM can meet them.

Requirement: Create Custom Modules and Fields

Zylker University has no use of modules such as leads, contacts, accounts and deals as they are into student management.

Solution:

Let us see how you can create a custom module in the steps below:

Zylker could create custom modules in Zoho CRM to fit their context. Example, Students, Professors and Lab Technicians.

  • 1. Go to the CRM Setup > Customization > Modules and Fields.
  • 2. Click Create New Module.
  • 3. In the ensuing Layout Editor page, enter the name of the module: Students
  • 4. From the New Fields tray on the left, drag and drop the required type of fields and sections into the layout.
    (Each field used in this tutorial and the field type are mentioned in the table below)Edit properties of a field if required.
  • 5. Set module permission and click Save.
    Select user profiles that can have access to the module. The other profiles that have been excluded will be restricted from accessing this module.

Details of the fields and sections in the Students module:

Section: Personal Information
Field NameField TypeSpecific Properties, if any

Student Name

Single Line

None

Preferred Name

Single Line

None

Date of Birth

Date

None

Email

Email

None

Permanent Address

Multi-line

None

Marital Status

Picklist

Options: Married, Unmarried

Social Security Number

Single Line

None

Created By

Single Line

None

Modified By

Single Line

None
Section: Payment Information
Field NameField TypeSpecific Properties, if any

Counselor-approved fee waiver?

Picklist

Options: Yes, No

Applying for financial aid?

Picklist

Options: Yes, No

If so, enter details on financial aid

Multi-Line

None
Section: Family Information
Field NameField TypeSpecific Properties, if any

Parent/Guardian Name

Single Line

None

College attended (if any)

Single Line

None

Your parents are

Picklist

Options: Married, Divorced

Professional Details

Multi-Line

None

Employer Details

Multi-Line

None

Communication address

Multi-Line

None
Section: Academic Information
Field NameField TypeSpecific Properties, if any

School

Single Line

None

Type of School

Picklist

Mark as Required

Options: Public, Private, Correspondence, Charter, Parochial, Home-School, Other/Education Provider

Start Date

Date

None

Counselor's Email

Email

None

Counselor's Phone

Phone

None

CEEB Code

Single Line

None

School address

Multi Line

None

Date of Graduation

Date

None

Did you receive a GED?

Checklist

None

If Yes, List Date

Date

None

Section: Previous Employment Information.
Section: Additional Information
Overview Page Layouts and Conditional Layouts

Add Multiple Layouts

Requirement: Create Page Layout and Conditional Layout

We've now created a module called Students for Zylker University - however, student management is done based on the branch of studies. For example, the course information required from students belonging to the Engineering division will be different from that of the Film Studies division.

For example, the student application form for Engineering students is largely different from that of the Film Studies students. Similarly, the admission process, student activities, the newsletters are all different for the two divisions. Having these diverse details in the same module causes a lot of confusion.

Besides, the activities revolving around the students, the emails automated to them, the reports obtained will all be different based on whether the students belong to Engineering or Film Studies. So how can the university manage these diverse divisions under the same module? The solution is to create multiple layouts under the Students module.

Solution:

Each module can be sub-divided into layouts. For instance the Students module can have the following layouts within it:

  • Engineering
  • Film Studies

Each new layout under the module may share common fields or have different fields specific to that layout.

For instance, the Course information fields will be different for the two layouts. If you look at the Engineering layout, it has options such as Civil Engineering, Thermal Engineering and so on.

When you switch the layout to Film Studies, the same field will have options such as Cinematography, Direction and Script Writing. The custom field you have consumed is only one - but it can have different options in different layouts.

Let us see how you can add multiple layouts in a module in the steps below:

  • 1. Go to the CRM Setup > Customization > Modules and Fields.
  • 2. From the List of Modules, select Students.
  • 3. Click Create New Layout.
    Note that the Standard Layout will be cloned and a you can make the required edits in the new layout.
  • 4. Create new fields that are suitable for the Engineering and Film Studies layout and save it. The fields that should be added are mentioned below.
Course Information section for Engineering layout
Field NameField TypeSpecific Properties, if any

Degree applied for

Picklist

Mark as Required. Options: M.S, M.E, M.Env, M.F.A. M.MUS, PhD, DMA, AuD

Program

Picklist

Options: Options: Civil Engineering, Computer Science, Aeronautic Engineering, Chemical Engineering, Materials Science Engineering, Thermal Engineering

Major

Single Line

None

Area of Emphasis

Single line

None

Research involves human subjects or animals?

Picklist

Options: Yes, No

If Yes, submitted to Institutional Review Board?

Picklist

Options: Yes, No

Assignment URL?

URL

None

Grade

Picklist

Options: A, A+, B, B+, Others
Course Information section for Film Studies layout
Field NameField TypeSpecific Properties, if any

Degree applied for

Picklist

Mark as Required. Options: B.Sc, M.Sc, PhD, MA

Program

Picklist

Options: Options: Cinematography, Direction, Editing and Sound Design, Script Writing

Major

Single Line

None

Area of Emphasis

Single line

None

Grade

Picklist

Options: A, A+, B, B+, Others

Now we have two layouts: Engineering and Film Studies. You can select the layout while creating a record and fill in the required details.

How to work with different layouts?

Once the student information has been classified into different layouts - Zylker can organize further activities and processes based on the layouts.

For instance, the emails automated to Engineering Students will be different from that of Film Studies students, though they all belong to the same module. You can accomplish this by defining layout as criteria in the workflow rules.

Similarly, below are few more CRM functions that can be achieved based on the layouts:

  • Layout assignment and permission.
  • Layout based workflows.
  • Layout based reports.
  • Layout based custom views.
  • Generate records in CRM from import, web-forms and APIs based on layouts.

Layout assignment to CRM users

You may have different people associated with each layout, in this case, Engineering and Film Studies layouts. Engineering layout owners need not view the details of the Film Studies division and vice versa. To manage this efficiently, you can assign each layout to specific user profiles in CRM. If you want to restrict a profile from accessing a layout, simply exclude that profile from the Layout Permission section.

Layout based workflow rules: Automate email alerts to students based on layout:

This workflow rule will automatically send different emails to best performers in the Engineering and Film Studies branches whenever the workflow rule is triggered.

Layout based reports

Reports created with "Layout" as part of the filters will create reports specific to Engineering or Film Studies students.

Layout based custom views

Custom views created with layout as criteria will display the records specific to Engineering or Film Studies students.

Create Conditional Layouts

Requirement: Define Field Dependency with Conditional Layouts

Now we have new modules, with multiple layouts under each of them. Further to this, Zylker has a third requirement. In the new Student form, there are many fields that are required based on a previous choice. For instance, a field called "Financial aid details" is required only if financial aid is sought by the student. Otherwise, the field is irrelevant.

In a similar manner the entire layout could be made dynamic by framing layout rules to show/hide fields and sections and make fields mandatory.

Solution

Conditional layouts offer a solution exactly to such a requirement. Using layout rules, a layout can be made dynamic - that is Zylker can control how the layout appears, based on the input value of a field. So, if someone selects "Yes" for "Financial Aid", another field asking for further details appears. Otherwise, the latter stays hidden.

Example - Financial aid description is required only when the student has applied for financial aid. Otherwise, the details field is not relevant.

Solution - Display financial aid details field only if "Applying for financial aid" is Yes.

Example - In the Academic Information section, if "Did you recieve a GED field" is checked, then displaying the "List Date" field makes sense. Otherwise it is redundant.

Solution - Display "List Date" only if "Did you recieve a GED field" is selected.

Let us see how you can define field dependency in the steps below:

  • 1. Go to the CRM Setup > Customization > Modules and Fields.
  • 2. Under Layout Rules, click New Layout Rule and configure the rules as shown in the images.
Overview Subforms and Validation Rules

Create Subforms

Requirement: Add multiple line items using Subforms

We created a custom module called "Students" for Zylker University, added different layouts to manage diverse divisions and also de-cluttered the layouts by allowing field and layout dependencies.

Further to this, assume that Zylker wants to collect additional information about the Academic Details and Employment History of the applicant.

  • The Academic Details section will have columns such as the previous year's grades, subjects opted for etc.
  • Employment History section may contain columns such as Employer Name, Job Title, Job Description etc.

In this case, each applicant may need to enter 3-4 entries under these sections. It's a hassle to manage this requirement with just custom fields, as it will cause a clutter.

Solution

Subforms gives you the solution to keep your primary form free from clutter by enabling you to add multiple line items inside a secondary form. Though these are important details about the student, they can easily be captured inside a subform named "Academic Details" or "Employment History". You can introduce the additional line items in a subform and store the relevant information. While the primary form will still be about the student, the subform will hold the additional details about academics and previous employments.

Let us see how you can add a subform to a layout in the steps below:

Section: Previous Employment Information
Field NameField TypeSpecific Properties, if any

Employer (Job 1)

Single Line

None

Job Description (Job 1)

Multi Line

None

Date of Employment (Job 1)

Date

None

Hours per week (Job 1)

Number

None

Employer (Job 2)

Single Line

None

Job Description (Job 2)

Multi Line

None

Date of Employment (Job 2)

Date

None

Hours per week (Job 2)

Number

None

Create Validation Rules

Requirement: Ensure Data Accuracy by Setting Up Validation Rules

We have now added many fields to the Engineering and Film Studies Layouts. There can be chances that the student information entered does not comply with the terms of Zylker University.

For example, to apply for Aeronautical Engineering the GPA score of the candidate must be above 5. If the score is less than 5, the system should recognize that it is invalid and throw an error.

Solution

Creating validation rules will help you arrest invalid data while it is being entered in Zoho CRM. In this case, creating a validation rule for the Engineering Layout will let you define the required GPA score of an applicant for the Aeronautical engineering course. If the applicant enters a GPA less than 5, the system will throw alert "Sorry, the GPA score must be greater than 5 to apply for this course".

Example - Applicants who apply for the Aeronautical Engineering course must have attained an overall GPA score above 5.

Solution - Define a validation rule that says, if the GPA is 5, alert the applicant saying "Sorry, the GPA score must be greater than 5 for this course".

Let us see how you can set up validation rules for fields in the steps below:

  • 1. Go to the CRM Setup > Customization > Modules and Fields.
  • 2. Select the module for which you want to create the validation rules.
  • 3. In the [Module] page, click the Validation Rules tab.
  • 4. Click + Create Validation Rule.
  • 5. In the Create Validation Rule Popup window, perform the following actions:.
    • Choose the Engineering layout that the field you wish to validate, belongs to.
    • Choose the GPA score field and define the primary condition to initiate the rule. For instance, if you want to validate the GPA field to keep out scores less than 5, your primary condition will be, "GPA Score 5".

You have successfully customized your CRM account for the education sector.