InfoPath 2010

Re: Get Diplay Name from repeating table instead of ID

wintert — Wed, 25 Jul 2012 08:10:26 GMT

Hey Ernesto,

You mean lookup over a lookup? :)

I will try and test it.

Thanks

Re: Get Diplay Name from repeating table instead of ID

ErnestoM — Fri, 13 Jul 2012 14:55:02 GMT

Hi,

The link you have posted is the same idea I had explained above, but in a step by step fashion.

The set up should not be any different for browser vs client vs preview. That is, the form should behave the same if everything is set up correctly.

Re: Get Diplay Name from repeating table instead of ID

Ramanjulu Naidu N — Fri, 13 Jul 2012 05:35:33 GMT

Hi Ernesto,

Sorry to interfere in this conversation. I have a same requirement but little difference. i want to display name(Emp Name) in a list instead of "ID". I see only the "number" instead of name in place of Emp Name. I have followed the link as well. in preview this works fine. but when it comes to site(list) level, it displays only number.

the link: http://sharepointsolutions.com/sharepoint-help/blog/2011/11/get-infopath-to-display-lookup-column-value-not-id.

Please........... be elaborate. so that i can understand or else give me any link which gives me a walkthrough.

Thanks,

Re: Get Diplay Name from repeating table instead of ID

ErnestoM — Mon, 09 Jul 2012 12:19:34 GMT

When this happens to me, I add another node to my schema.

So for example: under the repeating node, I would have a field for the ID, and a field for the DisplayName. Obviously the dropdown stores the ID and displays the displayName, but storing these separately means that I can use them later in other places in my form.

Add a rule to the dropdown such that it executes when it is not blank. With the ID stored in the dropdown, you can use a filter within Set a field's value to then extract the DisplayName from your secondary data source and save it in the second field.

Good luck!

Get Diplay Name from repeating table instead of ID

wintert — Sun, 08 Jul 2012 08:01:31 GMT

Hello,

I have a repeating table where one of the columns (Name) is a Drop Down list control that is populated from SharePoint list.

I set "TItle" as the Display Name and "ID" as the value so when I press on the Drop Down I can see the Title from SharePoint but have the ID as value for later use.

I have another drop down where I choose the repeating table as the source and query with a condition.

The Value is set to some other column and the Display Name is set to the "Name" field.

The problem is that when I press on this Drop Down, I see the ID instead of the Display Name.

What can I do?

Thank you.