General

Re: Set a field based on boxes checked in a repeating table

Jimmy — Sat, 15 Sep 2012 13:35:02 GMT

Where have you placed your rules? I'd suggest placing them on the CheckedFields tally field instead of the checkbox field.

Re: Set a field based on boxes checked in a repeating table

kizzie37 — Fri, 14 Sep 2012 17:11:37 GMT

Thanks sophie,

I came up with something similar, but two boxes

1 that counts the number of rows,
1 that counts the number of rows checked

If number of rows is greater than 0 , but less that the total rows then set as "Partial Approval"

If number of rows is equal to number of rows checked, then set to "Rejected"

But I cant seem to get both rules to work in harmony, one seems to dominate the other, its driving me crazy!

Re: Set a field based on boxes checked in a repeating table

sophieryder — Fri, 14 Sep 2012 14:15:26 GMT

Hi Kizzie,

The way I would do it would be to add a hidden field in the repeating table called number with rules on the checkbox to make the number 1 if checkbox is checked and 0 if it gets unchecked.

Then I would have 2 more hidden fields outside the repeating table one called count and one called total with the default values of each count([checkbox field name here]) and sum([number field name here])

Then I would put some rules on the submit button where the conditions would be if count = 0 then set status to Pending,

if count is greater than 0 and count is less than total then set status to Partial Approved,

if count is equal to total then set status to Approved

There may be an easier way but this is what I could come up with.

Hope this helps,

Sophie

Set a field based on boxes checked in a repeating table

kizzie37 — Thu, 13 Sep 2012 19:17:49 GMT

Is it possible to st an approval field based on lines checked in a repeating table.

My example, I have a status field with four choices:

Pending (Default)
Approved
Partial Approved
Rejected

I have a repeating table, with lines and a checkbox at the end, if just one line in the selection is checked, then the field should change to Parital Approval

If all liines are checked then the field should change to Rejected.

Can anyone help please?