Hey all,
I need to build an expression in my form that will allow me to filter more than the 5 criterion that the GUI lets you do by default. So here's the situation: I have a Form in another library for Projects and I assign Resource to that project, and I can assign up to 5 names (currently) to that form. I then have another form that is a Status Report form that is used by those people while assigned to the Project. Currently I can only assign 2 resources to the project because of the InfoPath GUI limitations because I have to filter on Projects that are not Closed and then a Resource name. So in my Status Report form I end up with:
Project Not Equal to Closed AND
ResourceAssigned EqualTo ResourceName OR
Project Not Equal to Closed AND
Resouce2Assigned EqualTo ResourceName
(Where Project, ResourceAssigned and Resource2Assigned is pulled from the Project List). And then I run out of the ability to add more filter criteria. Therefore I assume I could use an Expression and encapsulate both criteria into a single filter then using OR's I could have 5 resources assigned, right? however, I don't really understand how you build those expressions.
So I apologize if there is a place where I should have already read this, but I haven't been able to find it as of yet. If I need to RTFM I will gladly do so if you point me to TFM, or if you have an idea on how to build them, ALL help is greatly appreciated.