Multiple selection choice field logic
AnsweredI am using multiple choice fields with the checkbox option in SharePoint to allow users to multi select from a list. I need to add logic that checks the value or values that are selected to hide or show additional fields in the form based upon the options that are selected by the user. The standard Assignment method of Field=="Value" of course does not work with this type of field. Is there a special method for formatting logic when a field is multi select choice field?
-
Good afternoon
Dear Tracy Vymola,
By standard functionality it's not possible to do this, we advise you to use jQuery to do what you wish, write script using jQuery.
If you are using Rich Forms then, you can try use functionality from Rich Forms to write script using different Expressions on Behavior Tab (Enabled/Visible for example) of Rich Forms.I hope that I have helped in some way
Regards
Rosario Matos
0 -
Thanks for your reply Rosario. I was thinking that the Behavior Tab Visible field would be the place to put the logic. However I'm not sure how to frame the expression. I would expect a multi select field to force me to use a CONTAINS statement but haven't quite figured it out yet.
0 -
Your welcome Tracy.
Regarding your question, you can use indexOf() function in expression for fields. For Example: [[TestMultiChoiceFiled]].indexOf("FirstCheckBox") == -1 ||
[[TestMultiChoiceFiled]].indexOf("SecondCheckBox") == -1
You can also use javascript function in Expression builder.
We wish you a nice day.
Best Regards
Rosario Matos
0 -
Rosario, thank you! This expression is working perfectly. I am very grateful for your help with this solution. Have a fantastic day.
0 -
Thank you Tracy for your nice comment.
Best Regards
Rosario Matos
0
Please sign in to leave a comment.
Comments
5 comments