Skip to main content

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‍‍

Hi

Use validation rule length(Currency) < 8 (Currency is named control)

203781_pastedImage_2.png

 

Thanks,

Lakshmi Narayana C 


this will not work if you only tick single checkbox - in that case it returns length of string not length of array...


203782_pastedImage_1.png


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)'


203788_pastedImage_3.png

203789_pastedImage_4.png


and if you select just one checkbox?


203790_pastedImage_1.png


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