Drop-down list automatically recieves a value when a value in another drop down list is selected (using a Sharepoint list as source) - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Drop-down list automatically recieves a value when a value in another drop down list is selected (using a Sharepoint list as source)

Last post 09-24-2009 08:42 PM by princevis. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 01-29-2009 05:07 AM

    Drop-down list automatically recieves a value when a value in another drop down list is selected (using a Sharepoint list as source)

    I am trying to populate two drop-down lists from one Sharepoint list, where the condition is that if in the first drop-down list a value is selected, the secont drop-down list should have the value of the same item(row) form the Sharepoint list. The idea is that if I have  a lists with a machines which are build in a factory, they are build with a number and a name(one row). I want in the first drop down to select the number, and in the second one automatically to ricieve its name.. or vice verca.. I don't understand where am I wrong, since when I am using the same technique(using the same data connection, the same filters  and so on), but with a one drop-down list and a text box, the box can be populated with the required value! I am very confused, and this requirement I have to fulfill. Can anyone help me!

  • 01-29-2009 05:31 AM In reply to

    • Anuma
    • Top 25 Contributor
      Female
    • Joined on 07-20-2005
    • India
    • Posts 525

    Re: Drop-down list automatically recieves a value when a value in another drop down list is selected (using a Sharepoint list as source)

    Hi,

     

    You want to display the same row name in the text box when user selects the number in the dropdown. Add following rule to the Dropdown box.

    1. Open dropdown box Properties.
    2. Select Rule and Click on “Add action” button.
    3. Select “Set a Field Value” from First dropdown.
    4. Select “Text box field” xpath in “Field” text box.
    5. Enter following function values text box.
     "@name[Dropdown = @number]" 

    name-à Name from the SharePoint list

    number à Number from the SharePoint list

     

    Dropdown à Your dropdown field xpath

     

    Anuma Chinthapalli /
    http://www.GGKTech.com
  • 02-17-2009 07:20 AM In reply to

    Re: Drop-down list automatically recieves a value when a value in another drop down list is selected (using a Sharepoint list as source)

    Hello,

    Thank you for your answer.. It helped me a lot.. But i didn't get the result in this way, but I created a Fflter when selecting the fields value. My aim is now to employ this method in a repeating table. It works proper, but an unexpeced bug occurred. For some of the selections in the dropdown list box the values in the text fields are correct, but when a value is selected (not all, specific ones) ,the following items inserted contain wrong data. Is it a bug from InfoPath or it an error of the rules ? I am confused, because when the rules are applied in a non repeating manner it works just perfect.

    Thank you in advance. 

  • 09-24-2009 04:25 PM In reply to

    Re: Drop-down list automatically recieves a value when a value in another drop down list is selected (using a Sharepoint list as source)

    Hello Svetoslav,

     My name is Gregory and I am attempting to create the same process.  Could you share the process you followed? 

     TIA!

  • 09-24-2009 08:42 PM In reply to

    Re: Drop-down list automatically recieves a value when a value in another drop down list is selected (using a Sharepoint list as source)

    Ur form is browser compatible,or just an infopath form...

    If it is browser compatible,it is possible only through code..

    Vishal Srivastava
    Senior Software Engineer
    SDG Software Pvt Ltd
Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.