Numbering InfoPath 2010 - InfoPath Dev
in

InfoPath Dev

Numbering InfoPath 2010

Last post 04-25-2012 01:36 PM by darrinlewis441. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next

  • 04-24-2012 03:02 PM

    Numbering InfoPath 2010

    Reply Contact
    Hello Everyone!My name is Darrin and I am a supervisor for a call center.  I am trying to make a tracking form that I can deploy to my employees that do not have InfoPath installed.  My form has about 50 rows, two columns and each column has a check box, one for yes and one for no.  I need these to total at the bottom of how many are checked because each one will not be checked.   For an example, if I have 25 checked of the 50 I need to say 25 at the bottom. I need to know how many yes are checked and how many "no" boxes are checked....Is the possible?  Forgive me as I am a InfoPath Newbie.  Thanks in advance! Darrin

     

  • 04-25-2012 12:55 AM In reply to

    Re: Numbering InfoPath 2010

    Mark as Answer
    Reply Contact

    Assuming you've set up these rows all with separate fields rather than a repeating table and that they all have the same checked/unchecked values, the formula to count the number of checkboxes that are checked would be:

    count((firstField | secondField | thirdField | ... | lastField)[. = 'valueWhenChecked'])

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software

  • 04-25-2012 09:19 AM In reply to

    Re: Numbering InfoPath 2010

    Mark as Answer
    Reply Contact
    I have the formula however in the second "No" column, the design checker is red.  The error is "Control Binding is not supported" and if I take out the formula from No the error goes away.  I need them to total separate from yes and the no row.

  • 04-25-2012 10:50 AM In reply to

    Re: Numbering InfoPath 2010

    Mark as Answer
    Reply Contact

    Perhaps this blog post can help you with the Control Binding is not Supported error:

    http://www.infopathdev.com/blogs/hilary/archive/2012/01/19/ipfs-design-checker-errors-amp-print-preview.aspx

    The alternative would be to have two fields with default value formulas to count the number of Yeses and Nos, and display those in your form.

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software

  • 04-25-2012 01:36 PM In reply to

    Re: Numbering InfoPath 2010

    Mark as Answer
    Reply Contact

    I have one check box in every row. There is two columns and 30 rows.   I click a few check boxes in the yes row however the 0 of the formula is not updating when I click the check boxes. 

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