I have a form with a Choice column that has multiple checkbox enabled. I want to ensure all the checkboxes are selected before the form can be submitted. I have been unable to find any articles on setting up the validation
isNullOrEmpty({Self}) only requires one of the checkboxes be selected to pay the validation. I need all the checkboxes to be select before the form can be submitted.
Following validation formula might have worked for you
(assumed 5 options in choice control)
If(Array.isArray(ChoiceNamedControl),length(ChoiceNamedControl),If(length(ChoiceNamedControl)>0,1,0)) < 5
this will not work if you only tick single checkbox - in that case it returns length of string not length of array...
hm, that's interesting...
what version have tested it on?
could you add two more calc value controls on the form, one with formula just 'Currency' and second one 'length(Currency)'
and if you select just one checkbox?
thanks for example, Lakshmi Narayana C
functionality seems to be changed between 2.7.0.0 and 2.10.0.0, with former one it returns plain string instead of array of strings if single checkbox is ticked
This works to display the message but when all the boxes are checked, the message is still displayed.
We are on version 2.5.0.0
have you noticed my formula at the top?
it should work on older form version as well.
I missed that formula. I added it and the checkboxes are working correctly. Thanks for the assistance.
great!
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.