if field 1 is populated, use field 1
If Field 1 is blank, use field 2
if field 1 and field 2 is blank use field 3
if field 1, field 2, field 3 are all blank use blank value

**Description; assigning a person to a managers role (these are all text fields)
1. if field 1 is not blank, use field 1
2. if field 1 is blank, use name on field 2
3. if field 1 and field 2 are blank, use name on field 3
4. if field 1, field 2, field 3 are all blank, leave manager's role field blank