InfoPath Dev

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

W 

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. :)

 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.

W 

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....

 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.

W 

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.

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. 

 

Fantastic, glad you have it working!