I am designing an Infopath 2010 web form to be published to a SharePoint 2010 server. The form will display the projects owned by a logged-in user using a repeating section with controls. The controls are bound to a SharePoint list connection called
Projects. I did this by setting a conditional formatting rule on the repeating section.
Now for each of the project, I need to calculate a TotalHour based on an attribute of the project (attr1) and another SharePoint List connection called Policy. Using the value of TotalHour, I will populate another field called CalculatedHour
using a formula. Both the TotalHour and CalculatedHour fields are on the Main form.
Should I set TotalHour and CalculatedHour fields to repeating fields? Can I add the TotalHour and CalculatedHour controls inside the repeating section? When setting the default value how can I specify to use the attr1 value of the corresponding project?