Newbie Questions

Re: Getting the displayname of the selectedvalue of a dropdown

BigMo — Thu, 16 Oct 2008 14:37:55 GMT

Or is there any other better approach to do the same?

Re: Getting the displayname of the selectedvalue of a dropdown

BigMo — Thu, 16 Oct 2008 14:37:17 GMT

Thanks Anuma & Swathip. That worked. When the user don't see the item which they are looking for, i have to give them the ability to add new items which create records in the DB & open up this same form with the newly added items. I am thinking to have a button to add new items next to the dropdown and in the managed code of the button call a new IP form which adds the records to the DB, closes and refreshes this main form. Any help on how to do that?

Re: Getting the displayname of the selectedvalue of a dropdown

swathip — Thu, 16 Oct 2008 05:37:15 GMT

Hi BigMo,Read the following link.http://www.infopathdev.com/blogs/matt/archive/2006/04/18/Automatically-Populate-Fields-from-a-Drop_2D00_Down-Selection.aspxIn the above link, they used the clients.xml as a secondary data source. You can use your data base secondary source.Hope this will help you.

Re: Getting the displayname of the selectedvalue of a dropdown

Anuma — Thu, 16 Oct 2008 05:32:51 GMT

Hi,

Enter following formula as text box (Another field) default value. Double click on the text box and enter below formula in the default value field.

“Name[@id = field1]”

Name – Display name from Secondary xml.

ID – ID from Secondary Xml.

Field1 – Dropdown.

Re: Getting the displayname of the selectedvalue of a dropdown

BigMo — Thu, 16 Oct 2008 02:22:35 GMT

Can you please give me some more detail. I am little confused. Thanks.

Re: Getting the displayname of the selectedvalue of a dropdown

Hilary Stoupa — Wed, 15 Oct 2008 20:55:22 GMT

Hello & welcome!

I would set the other field to the Name field from your secondary data source and then filter based on the ID being equal to the field in you Main DOM connected to the dropdown that is populated from that secondary data source. Does that make sense? Let me know if you need more detail...

Getting the displayname of the selectedvalue of a dropdown

BigMo — Wed, 15 Oct 2008 20:22:37 GMT

I have a dropdown in a infopath form. The items are comin from the DB via webservices. The dropdown is populated with a ID as a value and a NAME as the display name - no problem with that. Now i want to set another field with the displayname of the selected value. How can we achieve that? If we use the xpathnavigator of the main data source / add rule to 'Set a field's value' with the selected value, it would set the ID (which is the value of the dropdown); not the display name. Any help would be appreciated.