Isolating Degree Date
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).
Building the Custom Property
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; }