InfoPath Dev

I figured it out by combining Ernosto's and Hillary solution. Below is what I did. I created a new SharePoint list called Teams and associated each user to a teamI added the list Teams as a seconary data source to the formI added a new field called myTeam to the main datasource that with a default value from the Teams datasource with a filter ...

Back to my original question. Is possible to filter information in a repeating table for a person based on their association to a team and if so any suggestions on how to accomplish this? I would prefer that the relationship between the user and the team stored in SharePoint.

I am doing that already for the user. Sorry I am getting my terminology mixed up. What do I set the default value of /dfs:myFields/dfs:queryFields/q:SharePointListItem_RW/q:Team to? I know how to set the value I just can't seem to figure out how to get the team for the user opening the form to use as the value for the filter.

That is what I was doing when filtering the repeating table for one user because I get get the current username of the person opening the form and use it as the filter. How can I assign the default value of the user's team to use that as the filter? I guess what I'm trying to figure out is what do I set the default value of set the value ...

The data in the repeating table is coming from a secondary data source (which is a SharePoint List). The form is an InfoPath form and the current filter is being applied to the data connection itself when the form loads. I’ve attached a copy of the form for you to look at.

I was able to create a filter on a repeating table which only shows items when they are assigned to the current user of the form by setting a filter using the username() function. On another form I have a requirement to allow multiple people to view and update the items in a repeating table that are assigned to a team of people rather than just ...

 Thanks. I was originally going to try and do the calculation through VB and came across the qRules command. Didn't realize that the code was still part of the form. Thanks for the help

I'm trying to use the qRules GetDayOfYear command but when I execute it on a button no results are returned. I've attached the file can someone please look at it and and tell me what I am missing?  

 I downloaded qRules and have been able to figure out the basics of how to use it. What I am trying to figure out though is if it possible to use qRules to update the items in a repeating table using a SharePoint list as a secondary data source? I've gone through different posts ...

I followed Ernosto's tip followed the blog rather than the training video and I got it to work. Thank you for your help.