using conditions on fields in tables

[Guest]

Hi,
How can I add conditions to check/set values in a repeating table.
I am using InfoPath on web.

thx.

 

[Rajitha]

Hi,

What are the conditions do you want to add?
I think you can do this as same as you do in normal InfoPath Forms.

 

[Guest]

Hi,
I will give you a small example.
I have a repeating table with 2 columns: Yes/No and Amount
I have another field at the end of the repeating table that should add all
the amounts with the "Yes" columns.

Example:
Table 1 (Yes/No, Amount)
Yes, 200
No, 300
Yes, 700


The field at the end of the table should contain 900.

This is one example, another one could be that I need to fill another
repeating table that contains only the Yes rows. The new table will be as
follows:

(Yes/No, Amount)
Yes, 200
Yes, 700


thx.

 

[Rajitha]

Hi,

If i am not wrong for this application we need to filter data.
But, as filters are not supported by web forms you need to write Code I think.

 

[Anuma(GGK Tech)]

Hi,
1. Double click on the field which is in the end of the table.
2. Properties window, click on fx button.
3. Paste the following formula.

sum(field2[field1 = "yes"])

Field1 --> Yes/No field in the repeating table
Field2 --> Amount field in repeating field

I hope this will help you.