General

Re: Count of checked boxes in a Multiselect

seraphim_72 — Mon, 06 Mar 2023 19:42:49 GMT

Thank you Hilary - you are the best!

Re: Count of checked boxes in a Multiselect

Hilary Stoupa — Fri, 03 Mar 2023 00:47:08 GMT

That's right - I've seen the same issue with multiselects. Usually if I need a count I add it to the Submit button or something - but in terms of showing the user that info, you are sort of out of luck. So you know, there is generally a default blank instance of the repeating node in InfoPath - that's why you are seeing the weird behavior of getting a count of 4 when 3 are selected. I usually add an XPath filter to exclude blanks. I loathe multi-selects, they behave differently than everything else!!

Re: Count of checked boxes in a Multiselect

seraphim_72 — Thu, 02 Mar 2023 15:34:46 GMT

Ah, I think I see part of my problem. InfoPath does not see unchecking a box as a change. Only boxes getting checked are a change.

Count of checked boxes in a Multiselect

seraphim_72 — Thu, 02 Mar 2023 15:02:52 GMT

So here is what I am running into. Create a list add a multi-select with three choices. Then make an InfoPath form out of it. Add a text box and try to get that text box to reliably tell you how many boxes have been checked both on creation of a list item, and on edit of an item. It should be a simple count(value) of the multi-select, which doesn't work. Now I have the 'Some Total' with the Default set to count(value) [Really xpath--- count(../my:SomeChoice/Value)]and a rule on 'Some Choice' to set 'Some Total' to count(value) [ Really xpath--- (count(/dfs:myFields/dfs:dataFields/my:SharePointListItem_RW/my:SomeChoice/Value)]. At creation for some reason the index starts at one so that if you check all three boxes the count is four.

Easy you say - just make it count(value) -1 ! And that works, on creation, but not on edit of an existing one.

Anyone got a clue?