General

Re: Name of User - For Display - Form Creation

draghuna — Fri, 12 Sep 2014 21:34:41 GMT

Appreciate the quick response and it solved the problem I was facing.

Re: Name of User - For Display - Form Creation

Hilary Stoupa — Fri, 12 Sep 2014 01:00:59 GMT

Sorry, should have read through that more closely - I didn't intend to suggest a code solution. I thought in IP 2007 / ShP 2007 we could create a data connection to the UserProfile service and just use that for user info - not sure why that blog suggests using code to get the values.

Looks like someone covers that in the comments on that post tho-

Let's take it one step further and make it a no-code solution! How? Throw out steps 3 and 4. Instead:

3) Create a new data connection to retrieve information from the specified web service (http://<yourServerName>/_vti_bin/UserProfileService.asmx?WSDL), and select the "GetUserProfileByName" web method.

4) Use an XPath query on your secondary data source to populate the fields you want. For instance, use a formula to set the default value for an "email address" field. You'll be selecting the "dataFields/.../Value" field. The trick is to ensure you select the correct PropertyData node, as it is a repeating field - you'll have to edit the XPath to do so. Assuming your secondary data source is called "GetUserProfileByName", the XPath query required to get the current user's email address looks as follows:

xdXDocument:GetDOM("GetUserProfileByName")/dfs:myFields/dfs:dataFields/s0:GetUserProfileByNameResponse/s0:GetUserProfileByNameResult/s0:PropertyData[s0:Name = "WorkEmail"]/s0:Values/s0:ValueData/s0:Value

Works beautifully, and without needing to bust out any code!

Re: Name of User - For Display - Form Creation

draghuna — Thu, 11 Sep 2014 23:41:48 GMT

I am stuck with step 4. It looks like you reference material is related with C# programming language. I dont have C#/VB on my machine. I am using JS for programmatic coding. Dont see the option to add a web reference in Script Editor. However, I was previously able to add the UserProfileService web service directly from the InfoPath form.

Re: Name of User - For Display - Form Creation

Hilary Stoupa — Thu, 11 Sep 2014 22:34:53 GMT

First, generally instead of using a default value for something like this, I use a form load rule - and rule would be - if the field is blank, set it to the value (so it only gets set in a new form). I think you can use the SharePoint User Profile service for what you need - more here: http://blogs.msdn.com/b/infopath/archive/2007/03/07/get-the-user-profile-through-moss-web-services.aspx

Name of User - For Display - Form Creation

draghuna — Thu, 11 Sep 2014 22:21:25 GMT

Infopath Form 2007 - I have a text field (read only) where I want to display the person who created the form. I was able to capture the accountId using username() function but it does not show the actual name of the person. I want to show something like "John Smith". - I used a hidden variable to capture the username and unchecked "Update this value when the result of the formula is recalculated". I wanted to make sure this value is the same throughout the life cycle of the form even if someone else is editing the form subsequently. Thanks