jquery - Counting and storing the number of checkboxes in a sharepoint list -
i have sharepoint list that's purpose measure competency of team. have highly regulated financial environment , there on 790 "core competencies" maintain on 200 colleagues.
i've decided use sp 2013 solution. list contains fields "credit cards" "multi choice check box fields" inside credit cards - there more 30 checkboxes (eg. opening credit card , closing credit card, refunding fee, etc)
essentially, when users select boxes (basically saying "i know how this") , i'd number of checkboxes in field counted , placed in sp field. example, checkbox field called "credit cards" there field called creditcardscore counts number of boxes ticked in credit card score , total number , displays %. (we can split multiple fields, needs update every time form opened)
so if user ticked 15 out of 30 boxes, i'd know they're 50% competent @ job. (so can focus on getting them trained up)
i'd use jquery i've seen numerous examples of counting boxes, i'm not sure storing in field part. appreciated , sorry if wrong forum
you can create workflow starts each time item created or modified. set variable number of checkboxes check , set 0, check each checkbox, if it's checked, add 1 variable. after checking checkboxes, set creditcardscore value of variable (or variable/30*100 percentage). make field read-only. hope help!
Comments
Post a Comment