Code

Re: Identifying specific repeated fields

Jimmy — Mon, 09 Sep 2013 03:54:15 GMT

Please try this:

count(myField01[. = ''] | myField02[../myField01 = 'Yes' and . = ''])

or even this:

count((myField01 | myField02[../myField01 = 'Yes'])[. = ''])

Re: Identifying specific repeated fields

tomrehor — Tue, 03 Sep 2013 14:07:40 GMT

I don't think that's the correct logic. What I need is this:

if myField01 is blank, then count equal 1

--OR--

if myField01 is "Yes" and myField02 is blank, then count equals 1

How do I code for OR rather than UNION?

Re: Identifying specific repeated fields

Patrick Halstead — Sun, 01 Sep 2013 20:55:19 GMT

Did you try: count(myField01[.=''] | myField02[.='Yes']) ?

Re: Identifying specific repeated fields

tomrehor — Fri, 30 Aug 2013 14:27:11 GMT

This works. Thank you. However, I don't know how to count a special case.

myField01 is a radio button that must be checked. In this case, count(myField01[.='']) works.

However, if myField01 is "Yes", then myField02 cannot be blank.

In structured code I would write: IF ((myField01=='') OR (myField01=='Yes' AND myField02='')) then cntr = cntr + 1

Can you please tell my how to do this using count?

Thank you for your help.

Re: Identifying specific repeated fields

Jimmy — Thu, 29 Aug 2013 16:45:20 GMT

Instead of the approach you are using, you can do this:

count((myField01 | myField02 | myField03)[. = ''])

This should also work for repeating fields.

Identifying specific repeated fields

tomrehor — Wed, 28 Aug 2013 20:56:55 GMT

I am counting the number of unanswered questions on a form in InfoPath 2010. I have a text box (Integer) with a value of (myField01 = "") * 1). I can repeat the equation for each field, sum them, and get the number of unanswered question. For example, (myField01 = "") * 1) + (myField02 = "") * 1) + (myField03 = "") * 1). Simple.

However, this does not work with repeated fields. If myField01 is in a repeating table, the equation does not know to look at all the repeats.

How do I identify the repeated fields in my equation?

Thank you.