I have a People field which when a user selects a name auto populates other fields. Currently the fields are auto-populated using the current formula: userProfileLookup(ID,"FirstName") which works fine but I need another field called 'Line Manager' to auto-populate but the userProfile doesn't have that field.
So I tried to pull the information in from a list that I know contains that information called 'Starters'. If I use this formula: (lookup("Starters","Full Name",TestEmployeeName ,"Line Manager")) it works, HOWEVER TestEmployeeName is a Single Line Text box which is problematic because how do I validate it? It's very open to user error.
I tried: (lookup("Starters","Full Name",Another Name Test,"Line Manager") Another Name Test is a People control but at best it doesn't work, at worse it stops a preview being generated.
Any suggestions for a work round? Thanks in advance
Best answer by SimonMuntzView original