Input Validation on editable checkbox

Hi, I want to include a simple verification on a checkbox, where you can't save the form unless all of the checkboxes are ticked.  If I use the normal verification on the field, eg, @If(tickbox = ""; @Failure("The Tickbox must be completely filled in"); @Success), it only needs one box ticked.  Is there a way (formula language ideally), to make the user have to tick *all* the boxes before they can save?  Thanks very much!  Maggie
maggieballAsked:
Who is Participating?
 
Steve KnightConnect With a Mentor IT ConsultancyCommented:
@If(@Elements(checkboxfield)=n;@Success;@Failure(......))

and change n to be the no. of options in the checkbox.

Steve
0
 
Sjef BosmanGroupware ConsultantCommented:
Not meaning to criticize the application, just interesting and wondering what could be the reason for such a field: if all options have to be ticked before the user an save the document, then a) why not help him/her and tick them programmatically, and b) why not skip the field and assume them all ticked??
0
 
Steve KnightIT ConsultancyCommented:
I assumed something like options for I agree to x,y, and z by ticking these boxes or something...

Will see what the asker says..

Steve
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
Sjef BosmanGroupware ConsultantCommented:
Hm, yes indeed, but one would assume one box to be sufficient... I'm assuming again, so let's wait.
0
 
maggieballAuthor Commented:
First, let me say that Steve's solution worked perfectly, so thank you!   The field is a kind of 'agree to' box.  It's for a R&D report workflow database and the questions are:
Has spelling and grammar been checked?
Has document been proofread?
Has review list been fully considered?
Has distribution list been fully considered?

It's really a reminder to the author that they need to ensure all these things have been dealt with, and by checking each box, they are effectively certifying that they have.  I might have been able to do a single box that combined the questions, but from a user's point of view, it's a good process check to have them consider each point separately.  Thanks again for your superb help!  Maggie
0
 
Sjef BosmanGroupware ConsultantCommented:
I understand  :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.