First of all I would like to thank this forum for providing me some guidance to develop solutions using InfoPath.
This issue is in regard to http://www.infopathdev.com/forums/p/23959/83208.aspx#83208
I have a repeating table with some drop downs(Color, Seed Type) depending upon which the price textbox gets auto populated. I have YES/NO as display values for features such as Polenless, height>13', Organic, LifeCycle>1 yr.
I have Value property set as 0.1 for YES to Polenless, 0 for NO to Polenless and like wise for other features listed below.
•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%
In the repeating table below,the Color, Seed Type dropdown boxes are receiving values from my custom web services. I set rules to display Price (which is also a value obtained from a custom web service based on the value of Color and Seed Type chosen).
The way Raise textbox is set up is Raise = Polenless + Height + Organic + LifeCylce and I checked Refresh value when formula is recalculated.
The way my PriceAfterRaise is set up is round((1 + Raise) * Price) and I checked Refresh value when formula is recalculated.
In repeating table, if i add a new item, then The Price for the first item gets disappeared and PriceAfterRaise is 0. For the second item inserted, it shows the correct Price and Raise calculation is fine dependingupon the YES/NO values. The PriceAfterRaise is also fine. But when I add thirs item, the same thing happens, Price and PriceAfterRaise gets disappeared.
I want to know how do I preserve the values for each line item in a repeating table? If I don't check Refresh value when formula is recalculated, then it doesn't populate Price field at all. Please advise. Thanks.
Color Seed Type Price Polenless Height Organic LifeCycle Raise PriceAfterRaise
yellow Dwarf 20 Yes Yes No No 0.18 21.6