referencing a specific item in a repeating field for a calc

[manatee]

I am trying to esentially do a status calc where if in Field A, repitition 4 check box is enabled, then provide a result in another field. I can get the calc to show the right content in the destination field, but checking and unchecking the checkbox of the repitition does not change the result.

Here is where I am at currently:

If (status = GetRepetition ( status ; 4 ); individualname ; "" )

Thank you!

[mz123]

Hmm.. what about this:

If( Status[4] = "Y"; individualname ; "")

"Y" being the value of the checkbox when checked

Let me know if it works :

[manatee]

I appreciate the prompt reply, but I am sorry to report that it does give the result in the calc. I didn't think this would be so hard. Is there a way that one must reference checkboxes? I am reaching now!

[mz123]

Here is what I was explaining:

(instead of "individual name" i just have the field showing "YES" if the checkbox is marked Y.

Test.fp7.zip

[John Mark Osborne]

Case(GetRepetition(Status; 4) = "Y"; "YES")

[manatee]

I greatly appreciate the prompt reply and example. The example works like a charm, but mine still does not cut it. Here is what I have now:

If(status[3] = "Staff"; "Yes" ; "")

I will keep digging as it must be something simple.

Thanks!

[mz123]

On your layout, you might want to duplicate your repeating field and change it from a Checkbox to a edit box and see what text isactually in the field.

[manatee]

OK...I think I see the issue, but not the solution. I am only showing one repetition, not 4 as thought. Basically the value list is:

Member

Staff

Volunteer

None

They are check boxes and can have more then one selection in the single repitition. As long as I only have one checked the calculation works. Is there a way to determine if the text contains "Staff" as I am trying to find all staff in the calc. This makes sense?

Thank you again!

Edited May 26, 2006 by Guest

[mz123]

You can do:

If( ValueCount(FilterValues( FieldA[4]; "Staff" )) > 0; IndividualName; "")

I think that should work...