Counting the total number of unchecked checkboxes - InfoPath Dev
in

InfoPath Dev

Counting the total number of unchecked checkboxes

Last post 09-28-2015 01:04 AM by abiigdog. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next
  • 06-18-2015 06:39 PM

    Counting the total number of unchecked checkboxes

    Hi, I have developed a form with a lot of checkbox fields in infopath 2013 and I'm trying to calculate total number of unchecked boxes in any column of the table (or say the entire form). Is there a way to do that? Thanks.
    Filed under:
  • 09-28-2015 01:04 AM In reply to

    Re: Counting the total number of unchecked checkboxes

     Create another textbox for each checkmark field call it CheckCalc1, checkCalc2 etc etc. Use a rule  on every checkbox that if the checkbox is checked change a fields value for the new checkbox to 1.

    You know how many total number of checkbox fields you have I will assume 20 fields.

    Have another textbox field, call it SumCheckCalc that is the sum of all the textbox fields in step 1, i.e. CheckCalc1+CheckCalc2+Checkcalc3 so on so forth.

    Take that value and minus it from the total number of fields you have (20), so SumCheckCalc - 20 . That should be the number of unchecked checkboxes. 

Page 1 of 1 (2 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.