[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 235
  • Last Modified:

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
0
maggieball
Asked:
maggieball
  • 3
  • 2
1 Solution
 
Steve KnightIT 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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
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

Featured Post

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now