I am designing a custom filtering for a calendar list using browser based infopath 2010 list form. I have following columns:
Event: Text field. Displays the name of the event.
Start Time: Date and time value
End Time: Date and time value
Year: Calculated field (it is extracting year from Start time and End Time fields above)
Weekday: Calculated field (it is extracting weekday from Start time and End Time fields above)
Weeknumber: Calculated field (it is extracting weeknumber from Start time and End Time fields above)
Location: drop down list control. Displays various store locations
Category: drop down list control. Displays categories of events such as weather, power outage, road closure etc.,
I have to create an interface in Infopath 2010. There are 2 columns: Previous Year (dropdownlist) and Current Year (2014). Each column will have 7 week days displayed. The goal is to display events that happened on certain day of the week in both the columns.
When the form loads, both the column displays nothing. When a user picks: year and weeknumber, the columns displays results events based upon the year and weeknumber selections. I would like to extend this by adding filtering based upon Category and location. This part does not work.
I believe I am missing a rule or something
I hope I can explain this better
Thanks
Snehal H.Rana