cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
patrickw724
Nintex Newbie

Find the number of blank fields in an item

I built an internal audit form for my team with 46 questions (columns). 1=Yes 0=No    blank=N/A.  There are 46 possible points if every question is applicable.  I need a way to calculate possible points for an item that has N/A fields.  Is this possible with a workflow or calculated form value?

0 Kudos
Reply
1 Reply
chaddavis
Nintex Newbie

Re: Find the number of blank fields in an item

Can you give more details around the type of columns? Are these drop downs, text fields, radio buttons, other?

Here's an example I threw together using text fields: https://jsfiddle.net/e9rbmht7/

I wrote it based off this post: https://stackoverflow.com/a/6732402/4013327

Now, in my Fiddle, I tried both code options and they both work. However, when I tried both in a Nintex form, the jQuery attribute option didn't work so, I used the filter option, and it worked great.

I should point out that the code is in no way ready to copy and paste into a Nintex form. It's simply a jumping off point to get you started.

Reply