After applications are associated with Graduate Program dataset records, you can use that relationship in dashboards, queries, and checklist rules. Use embedded dataset row queries to show related people and applications on a dataset record, and use program requirement prompts to drive checklist automation.
⭐ Get Inspired
This article was adapted from a post by Technolutions staff in the Slate Community Forums' Get Inspired space. Have a great idea for a Get Inspired post? Let us know!
Showing related records on the dataset record
Create a query that returns the people or application records associated with each graduate program, then connect that query to the Graduate Program dataset with a dataset row query field. The query can appear on each dataset record dashboard, so staff can review the applicants tied to that program from the program record.
📖 Embedded Dataset Row Queries
Using program requirements in checklist rules
Fields and prompts on the Graduate Program dataset can also drive checklist assignment and fulfillment. This pattern is useful when different programs have different requirements and a single global checklist fulfillment option is too broad.
Example: Fulfilling an English proficiency item
For example, one program might accept TOEFL and IELTS scores but not Duolingo. Instead of creating separate rules for each program and exam, create a checklist rule with a subquery comparison filter. The filter compares the English proficiency exam prompt values on the application program record with the test name on the person record.
If the prompt values include short values, set the export value to Extended Value so the comparison uses the same value that appears as the test name on the person record.
📝 Note
The comparison values must match. If the prompt short value is different from the test name, return the extended value or adjust the prompt value before testing the rule.
Testing the checklist rule
When one of the accepted English proficiency exams on the Graduate Program dataset record matches the person record test name, the rule fulfills the checklist item.
Open an application connected to a Graduate Program record with accepted English proficiency exam prompt values.
Add or verify a matching person test record.
Run or refresh the checklist evaluation and confirm that the English proficiency item is fulfilled.