Jump to content

referencing a specific item in a repeating field for a calc


This topic is 5666 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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!

Link to comment
Share on other sites

Hmm.. what about this:

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

"Y" being the value of the checkbox when checked

Let me know if it works :

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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!

Link to comment
Share on other sites

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.

Link to comment
Share on other sites

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 by Guest
Link to comment
Share on other sites

This topic is 5666 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.