Set Field based on Valid Checkboxes

you have list of checkboxes.

some of them are disabled.

what about rest of checkboxes (not disabled ones), are they in your meaning "required checkboxes" or "valid checkboxes"?

Yep! 

So there are 3 sections of checkboxes:

• Core (required for all users) - about 10
• Applications (1 - 6 may be selected, or none.)
• Custom (required for some users) - about 7

The requirement of each is dependent on different factors. 

Applications -- did the manager request an application, and, has it been approved. So, two things there.

Custom - ie, did they ask for a phone? What kind of phone was it?

Does that account require to be copied? Was it copied?

So it's all different criteria. There is a submit button, and a save button, and they do essentially the same thing at this point in the form. What I want is to say "if the form is at X stage, and checkboxes X, Y, and Z (though it might be a billion different combinations), then hide submit. if they are all checked, show submit."

Mind you, I've been thinking about this in the mean time. What do you think of this ...

I suppose I can say "if (requirements for checkbox to be valid) are valid, and checkbox is checked, then 1... otherwise, 0" - then have a calculated field that says "if value is greater than 0, hide submit button. if equal to, show submit button."

So for example that'll be something like...   equals(App1Req == "Yes" && App1Approved == "Yes" && App1Check == "Yes", 0, 1)

I guess what I was hoping for was a way to select a group of checkboxes and say " equals(GroupOfCheckboxes == Enabled, 1, 0)

(Enabled in this case means "not disabled by rules")

so the checkboxes are single yes/no controls, right?

not sure why I though of choice(s).

either way, moreless the same approach could be used for both.

here is how could it be done for checkboxes.

use runtime functions that can work on arrays, eg. length(array) gives you number of elements in array, sum(array) adds up elements in array (for checkboxes - true/flase = 1/0 it adds up number of checked checkboxes).

to determine number of disabled checkboxes a little bit more complex formula might be needed, but it's still achievable with single calculated value control.

see examples

if you combine these formulas with formulas that identify which/how many checkboxes should be checked at most/least (per section or overall), I think you should manage to get what you need.

‌ ‌ ‌ ‌ ‌ ‌ number of‌

I have meant it as one validation per group of checkboxes (section).

eg for core section (all CBs required) it could look like (if nothing is disabled):  length([list of core CBs]) != sum([list of core CBs]) => do not pass validation

(no IFs or conversions to 0/1 are needed)

but that assumes you are able to build one general validation check per section out of all those application and custom requirements, eg. sum([list of app CBs]) < NumberOfAppsRequested => do not pass validation

if those requirements are too granular or too complex I afraid there is no other way then create a validation per single checkbox.