maggieball
asked on
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
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Sjef Bosman
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??
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
Will see what the asker says..
Steve
Hm, yes indeed, but one would assume one box to be sufficient... I'm assuming again, so let's wait.
ASKER
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
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
I understand :)