If your process includes confirming your applicants degree dates, you may find it valuable to create a custom property that isolates these dates from the appropriate schools (e.g., medical schools attended).
Add a calculated field as a custom property. The calculation below returns the date the applicant received their degree from their primary medical school. To isolate a degree date from other schools, replace the forms?.medicalSchoolsAttended?.medicalSchoolsAttended?.rows variable with the appropriate key to identify the correct school and degree.
{
/* This calculation returns the date the applicant received their degree from their primary medical school. */
/// First, validate that at least one row exists in the med school table.
let u = forms?.medicalSchoolsAttended?.medicalSchoolsAttended?.rows;
if ((u === undefined)||(u.length == 0)){return null};
///Filter down to just the primary med school attended, return the year.
let a = u.filter(f => f.isPrimarySchool == "Yes");
return a[0].degreeEarnedYear;
}
Once you've added this property, it becomes available to use in other areas of the software, including exports and merge fields.
By default, you can review the Custom Property on individual applications by navigating to the application, clicking the More Options (three dots) icon, and selecting Application Properties.
To make this field easier to find, you may choose to add it to the Application Summary or Sidebar.