InfoPath Dev

That did it! I have done this several times and needed another pair of eyes. You rock. Thanks again!

When the Employee is selected from the drop down that sets the two values. Condition: EmployeeName != "". Set EmployeeID: xdXDocument:GetDOM("Employee Records")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:EmployeeID[../d:Title = xdXDocument:get-DOM()/my:myFields/my:Time/my:Employee], Set ...

For testing I only have two values in the SharePoint list. Everything after the first row is set to the value of the first row. Employee, EmployeeID, Class John Doe, 12345, 1 Jane Doe, 54321, 5 The form: [Row 1] John Doe --> Rule Sets EmployeeID:12345 and Class:1 [Row 2] Jane Doe --> Rule Sets EmployeeID:12345 and ...

The first row is set correctly but the subsequent rows are set incorrectly. I am using a filter but it still is incorrect. I am also displaying the data connection so I can verify that everything is ok and it looks good.

This is my setup. I have a SharePoint list called Employee Data. My form has a repeating table for entering time entry type data. The first column in the repeating table is a drop down that is being fed from the employee data list. Up select of an employee I have a rule that is setting the EmployeeID and Class (Columns in Employee Data list). This ...

I am familiar with qRules and have a license but I am interested as my current solution runs in O365 and cannot be admin-approved.

Is there mechanism that is preventing the form from submitting duplicate items? Are you getting an ID back to tie the row to?