Re: InfoPath repeating table question

nemo385 — Thu, 18 Oct 2012 21:50:57 GMT

Hi Hilary,

Thanks for your response. My apologies as I couldn't reply you on time. I found a solution to my problem and already fixed it. Instead of sending multiple post back to the SQL Server to do filter on the data, I downloaded all the data from my table in InfoPath using a web service and set filters locally. That way, I didn't loose data that I inserted earlier. Thanks again for your response.

Re: InfoPath repeating table question

Hilary Stoupa — Fri, 12 Oct 2012 21:31:26 GMT

Can you attach a screenshot of your data source? Under the Options tab.

Is Price also in the repeating group?

InfoPath repeating table question

nemo385 — Tue, 09 Oct 2012 21:23:21 GMT

Hi,

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

General

Re: InfoPath repeating table question

Re: InfoPath repeating table question

InfoPath repeating table question