Forum Discussion

AndreaJohannes's avatar
AndreaJohannes
Qrew Trainee
6 years ago

Adding a conditional item to a list of missing items

Howdy, I currently have a formula text field called "missing documents". It looks at various fields to see if there is a date in the field. If there isn't a date in the field, then it gets added to...
Formulas and functions
AustinK's avatar
AustinK
Qrew Commander
6 years ago
var text StudentDrivingRecord=If(([Student Driving] = "yes" and IsNull([Student Driving Record Received])),"Student Driving Record","");

If([Student Driving] = "yes" and ([Student Driving Record Received] = "no" or [Student Driving Record Received] = ""),"Student Driving Record","");


I think one of those are what you are looking for. I might have an extra pair of parenthesis in there but it should work as-is. The second one assumes [student driving record received] is a dropdown with yes, no, and blank.

Also, you have a typo in NewSTudentOrientation that does not match the rest of your formula.