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.