General

Re: InfoPath 2010 browser form Rules

nemo385 — Wed, 03 Oct 2012 21:16:45 GMT

Thanks Gennady Vanin. I figured out to check design to see how Ernesto implemented his logic for calculation. Thanks for providing pictorial explanation. Appreciate your time and effort. :)

Re: InfoPath 2010 browser form Rules

nemo385 — Wed, 03 Oct 2012 21:15:06 GMT

Thanks a lot Ernesto. With your logic, I could implement the same for my drop down options. It was a lot easier than I expected. Thanks again. You guys rock! :)

Re: InfoPath 2010 browser form Rules

Gennady Vanin (Геннадий Ванин, Новосибирск) — Thu, 27 Sep 2012 16:11:46 GMT

nemo385:
Thanks Ernesto for your response. I got the form and could see the o/p as well. Could you please explain how you configured rules for those radio buttons? I will aprreciate your time and effort. TIA.

That attached template simply does not contain any rules

The option buttons are configured to return digital Value when selected: (like 0.08 with 0 for not selected) which you can check by choosing them and pressing Alt+ENTER and Calculated Value control has its XPath set to:

1 + field1 + field2 + field3 + field4

It is not difficult to create rules having that template as hint/starting point

Re: InfoPath 2010 browser form Rules

ErnestoM — Thu, 27 Sep 2012 10:06:32 GMT

Hi, glad it helped. You can right click on the form and open it in Design mode. This will allow you to check out the form logic, and them mimic them on your form.

Re: InfoPath 2010 browser form Rules

nemo385 — Thu, 27 Sep 2012 02:54:18 GMT

Thanks Ernesto for your response. I got the form and could see the o/p as well. Could you please explain how you configured rules for those radio buttons? I will aprreciate your time and effort. TIA.

Re: InfoPath 2010 browser form Rules

ErnestoM — Tue, 25 Sep 2012 12:57:20 GMT

Hi,

You can just assign numeric values to each selection. I've done it with option buttons in the sample attached but using dropdowns would work similarly.

Good luck!

InfoPath 2010 browser form Rules

nemo385 — Tue, 25 Sep 2012 01:08:58 GMT

Hi,

I have a web browser based 2010 infopath form. Let's say there are a couple of dropdown list box:

1.) Color

2.)SeedType

Based on what value a user selects for Color and SeedType, the Price textbox will display the price for that combination.

I have a SQL table with a list of price. Here's a small sample

Color SeedType Price

Yellow Dwarf 20

Brown Garden 30

Red Garden 35

In my form, there are other drop down list boxes with values YES or NO. For e.g., right next to the Price textbox, there are following dropdown list boxes

•Polenless (YES/NO): If YES, raise the price by 10%

•Height (> 13"): If YES, raise the price by 8%

•Organic (YES/NO): If Yes, raise the price by 15%

•Lifecycle (Annual- YES/NO): If Yes, raise the price by 12%

For e.g., if Yellow Dwarf is polenless, with height > 13”, Organic YES and having an annual life cycle then the new price has to be computed as 10% + 8%+15%+12% = 45% = 1+ 0.45= 1.45

Then new price is: 1.45 * Original Price= 1.45*20 = 29

For each selection made in the drop down list, the new price should be calculated applying appropriate % values.

Is there a way to do this in InfoPath form using rules? For each color and Seed Type choosen, it will display the price. However that price changes with the values picked from each drop down for the above mentioned criterias.

For each record, there's a possibility of 16 combinations. How is it handled in InfoPath 2010 form? Please kindly let me know. Thanks.