- 18 Mar 2024
- 4 minute read
- Print
- DarkLight
- PDF
Collecting The Correct Number of Recommendations By Program or Major
- Updated 18 Mar 2024
- 4 minute read
- Print
- DarkLight
- PDF
Recommendation letters submitted to Slate as PDFs can be managed using Materials. Recommendations submitted with imported applications like the Common App are usually PDFs, and they can be imported to a custom recommendation letter material.
Recommendations submitted directly to Slate using the recommendation widget on a Slate-hosted application can include a PDF type letter as an attachment; however, the recommendation itself is a form submission, not a material.
Assign a checklist item for a PDF type - recommendation letter material
Recommendation letter materials can be assigned as checklist items using a checklist type rule.
To create the checklist item:
From the main navigation, select Database. Then, from the Records section, select Checklists.
Click Insert.
Configure the following settings:
Status: Active
Scope: Person/Application
Group (optional): Enter an optional group name.
Section: Material
Subject: Enter a descriptive subject name (in this example, Letter of Recommendation #1)
Material Fulfillment: Letter of Recommendation
Material Fulfillment Rank: 1
Click Save.
To create the rule (the following is a sample):
From the main navigation, select Database. Then, from the Automations section, select Rules.
Click New Rule.
Configure the following settings:
Name: Give the rule a descriptive name. In this case, Assign Recommendation #1 By Major.
Base: Application
Type: Checklist
Trigger: Upon Update (Deferred)
Folder: Organize the rule in an existing folder, or select Other to create a new one.
Click Save.
Under Filters, create the necessary filter or filters necessary to identify the relevant records (see example). When assigning a checklist item for a PDF-material requirement (like a recommendation) to students with applications created by import, filter on the application ID (such as the Common App application ID or Royall application ID) to assign the Checklist item to the appropriate applications.
Under Action, configure the following settings:
Checklist: Select the item created in the previous section.
Action: Add New
Click Save.
Assigning Checklist Items For Multiple PDF Type - Recommendation Letter Materials
You will need to create an additional material checklist item for each additional letter of recommendation required beyond the first.
The subject of each additional letter of recommendation checklist item should match the material fulfillment rank on each. The material fulfillment rank ensures the first recommendation letter material collected will fulfill the first letter of recommendation checklist item, the second recommendation letter material will fulfill the second letter of recommendation checklist item, and so on...
These checklist items are not recommender specific and they look like this on the application record:
Recommendation Forms Submitted As Part Of A Slate Hosted Application
The Slate-hosted application allows the collection of recommender-specific checklist items, assigned automatically to the application record when recommender- or reference-scoped data is added to the Slate application. They are not assigned by a rule.
These items look like this on the application record:
Manage changes to auto-generated, recommender-specific checklist items
Say an applicant switches to a program or major that requires a different number of recommenders. The automatically generated, recommender-specific checklist items that no longer apply can be waived administratively on the application record checklist. This cannot be accomplished with a rule or a query.
If additional recommenders are required after the change of program or major, configure the applicant status page or portal to conditionally display a reference widget.
Configure the appropriate number of recommendation forms required on an application by a given program or major with submission requirements.
Awaiting Materials or Awaiting Decision? Determining application status by number of received recommendations
The number of recommendations required to read an application can be managed automatically by creating a program specific rule in the exclusivity group Application Status Rules.
If your application status rules are configured on the local base Applications, you can use the filter Checklist Status By Section—in conjunction with a program or major filter—to find records with less than the appropriate number of recommendations. The following is a sample rule that achieves this effect.
To create the rule:
Select Database from the main navigation, then select Rules Editor.
Click New Rule. A popup appears.
Enter the following configurations:
Name: Awaiting Materials - Recommendations
Base: Applications
Type: Application Status
Folder: Application Status
Exclusivity Group: Application Status
Non-deterministic: Rule is deterministic and has an exclusive priority
Click Save.
Within the rule, click Filter.
Enter "Checklist Status By Section" in the search bar and select it. Click Continue.
Enter the following configurations:
Section: Reference
Status: Use ctrl+click to highlight Received Official and Received Copy
Number: < 2
Click Save.
Add another Filter.
Enter "Application Major," or a similar program-specific filter, in the search bar and select it. Click Continue.
Select the appropriate major(s) or program(s) to include in the filter.
Click Save.
Under Action, set Status to Awaiting Materials.
Click Save.
This rule's action sets the application status of records with the application major biology with less than the appropriate number of recommendations to awaiting materials.
Count the number of submitted recommendations on the application record with a subquery filter
Using application status rules built on the Configurable Joins application base, create a rule with a subquery filter that counts the number of submitted recommendations (application references) on the application record.
To create the rule:
Select Database from the main navigation, then select Rules Editor.
Click New Rule. A popup appears.
Enter the following configurations:
Name: Number of Recommendations Required
Base: Applications
Type: Application Status
Exclusivity Group: Application Status
Non-deterministic: Rules within group and priority should be randomized
Click Save.
Under Filters, create a Subquery Filter. A popup appears.
In the popup, configure the following settings:
Name: Does Not Have 2 Submitted Recommendations
Aggregate: Count
Value: <= 1
Filters: Create a Subquery Filter. A popup appears.
In the popup, configure the following:
Name: Submitted Date Exists
Aggregate: Exists
Exports: Add an export, Application References Submitted Date. Join to Application References.
Click Save.
Click Save.
Under Status, select Awaiting Materials.
Click Save.