Checkbox conditional selection in repeated sections

S

Somen

Hi All,

I have a checkbox that resides in a repeating section. My need is that even
if the user has repeated the section ‘n’ number of times, he should be able
to select the checkbox from only one of the repeated sections. I’ve set a
data validation for this but it does not work in all scenarios. For eg, if
the section is repeated 3 times, and I’ve already checked the checkbox in the
second section, the validation disallows me from checking the checkbox in the
3rd section; which is correct. But this functionality does not work if I have
the section repeated only twice. Please advice what approach I must be
following to accomplish this.

Thanks in advance,
somen
 
N

nojyttap

There might be an easier way but here is what I have done.

Create a repeating section. Inside the repeating section insert a check box
(field1). Outside of the repeating section place a text box (field2). In the
rules for field1 set the condition to 'if field1 = TRUE' and the action to
'set field2's value to 1'. Then in the conditional formatting for field1 set
the condition to 'if field2 = 1' and the action to 'disable this control'

Field2 has to be outside the repeating section to affect all instances of
field1.

To hide field2 set the conditional formatting to 'if field2 is present' and
the action to 'hide this control'

Hope this helps.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top