InfoPath Dev

the formula I am using to try and get just the email string is this: substring-after(Manager,"i:0#.f|membership|")

how would i do what you are recommending here?

please reference newly uploaded file. When you publish or run it you see that the manager field is two substrings. One the email and the other the federation string. I tried using substring after but it did not work. Is their a document on how to get the manager s name of the user that is queried with the userprofile services. I dont even mind the ...

this works fine, but it brings across an email for the manager instead of the manager name. On top of that it has a i:0#.f|membership| in front of it. I have used the sub-string after function but to know avail i cannot parse out the email

If you notice from the above form library screenshot...the manager for Colin is Donald. But when I open the form now after the change you recommended his manager says my manager. Meaning i must not have the DC to getcommonmanager or the value for that manager field set up properly...any thoughts?

Thank you that seems to have worked for opening the form and keeping the same user data.

second attachment

second attachment I referenced

Here you go Hilary. Also you can see I have a two stage approval process. The problem is i cant configure those properly to hide the first submit box and second approval tier when emailed to the manager of the submitter. I deally i would like Tier I approval to come up and then when they approve or reject it gets emailed to me for approval so I ...

I still have not received a good answer for this. Here is the scenario: I have crated a data connection to the userprofileservices that way i can auto populate all my forms with AD profile information for whomever opens the form. Once submitted they have a form in the doc library with their profile information. The problem is when I or a manager ...