I have a sharepoint list with ManagerName, Department and AdvisorEmail columns and the form can only be submitted by managers. I have set up the data connection in infopath to connect to this list but in the text box that needs to store the AdvisorsEmail (from sharepoint list) got do i find out who the current person is and find the AdvisorEmail depending on this email?
for example: if i submitted a form i have a text box that will automatically display my name as Luke Bowles and this is read only - in the sharepoint list my AdvisorEmail will could be [email protected] how do i say in the text box that i want [email protected] to be displayed?
Thanks
Luke