General

Re: Count Filtered Repeating Table Row Based on Value

Hilary Stoupa — Wed, 27 Apr 2016 16:46:10 GMT

Fantastic, glad you have it working!

Re: Count Filtered Repeating Table Row Based on Value

wilkies0106aw — Wed, 27 Apr 2016 09:49:30 GMT

Hilary,

Thank you so much, The original expression formula seems to work, I've had to change my form slightly.

I added a rule to my Start Date field so that it set the end date to be the same value when the start date changed.

Then I added a second rule to my End Date field which was to set field 2 to the value of your expression.

Re: Count Filtered Repeating Table Row Based on Value

Hilary Stoupa — Tue, 26 Apr 2016 17:03:05 GMT

Do you not want the event to = 1? Sorry, thought that was part of your original description of what you wanted. What does "seems to go into a loop" mean? Here is a version w/out the Event = 1 in the field2 count formula.

Re: Count Filtered Repeating Table Row Based on Value

wilkies0106aw — Tue, 26 Apr 2016 16:05:45 GMT

Thanks, the count works if I add 1 to the event column in the repeating table.

Yet, as soon as I change the End Date picker, it seems to go into a loop. It doesn't like the 1 in the event column in the repeating table.

Re: Count Filtered Repeating Table Row Based on Value

Hilary Stoupa — Tue, 26 Apr 2016 14:42:25 GMT

Give this one a try - I changed your formula in field2 to count (hopefully!) all rows where Event = 1 and the date range is in the selected start / end date....

Re: Count Filtered Repeating Table Row Based on Value

wilkies0106aw — Tue, 26 Apr 2016 09:20:32 GMT

Thanks, XPath is something I've not got into.

FYI - the form loads the current user name using get user profile service.

My SharePoint List is as follows: Title, Date, Event

There are a few others columns, yet. the are dummies, trying to figure a few things out.

Re: Count Filtered Repeating Table Row Based on Value

Hilary Stoupa — Mon, 25 Apr 2016 16:36:09 GMT

I think you'll just have to add the date filtering to the formula you are using for your count - you'll need to manually edit the XPath to do that, I think - but you may be able to copy the expressions you are using to hide rows and re-use those. Feel free to attach your template under the Options tab in a reply if you'd like a hand, or paste all your XPaths into a reply & we'll see if I can guess what it should be. :)

Count Filtered Repeating Table Row Based on Value

wilkies0106aw — Mon, 25 Apr 2016 12:33:04 GMT

All,

Monday Madness,

I'm filtering a SP list based on a date range as described here. I've added a column to my list (Event) with the value of 1 for certain dates.

How can I count the number of rows in the filtered table if an event = 1?

Basic filtering is counting all events which = 1, not those based on my date range

Thanks