Controls

Re: Amending value depending on value selected in dropdown box

Mark B — Mon, 15 Jun 2015 17:31:11 GMT

Thanks, I'll give that a go

OK I now feel really stupid, could not get that to work! Do I apply the rule to the name field or the price field?

Re: Amending value depending on value selected in dropdown box

Patrick Halstead — Mon, 15 Jun 2015 05:29:53 GMT

Hi Mark,

As long as the XML file has the values as follows:

<price-list>
<product>
<name>Apple</name>
<price> 1.29</price>
</product>
<product>
<name>Banana</name>
<price> 2.37</price>
</product>
</price-list>

You can use an action rule with a set value action to set the price based on the value selected. Simply use a filter to set the value equal to the secondary data source price field with a filter which has the secondary data source value name on the left and the main data source field used for the dropdown on the right.

Good luck!

Amending value depending on value selected in dropdown box

Mark B — Sun, 14 Jun 2015 14:45:27 GMT

Having returned to InfoPath after a long break, I was wondering if what I want to do is possible.

I have a dropdown box of products which is feed from an .xml file, what I would like to happen is once the user has selected the product the correct price appears in a separate box. (Price is also included on the .xml file). At the moment the user selects the product from the dropdown and then has to manually enter the price.

Currently using InfoPath 2010

Thanks in advance for any help provided.

Regards

Mark