Browser Forms

Re: Repeating Employee Table

kameron.berget — Thu, 24 Oct 2013 16:25:29 GMT

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

Re: Repeating Employee Table

Hilary Stoupa — Thu, 24 Oct 2013 16:19:26 GMT

Your problem is here:

xdXDocument:get-DOM()/my:myFields/my:Time/my:Employee

That will always return the first Employee.

Since this rule is on Employee, you should be able to use current() in place of that.

xdXDocument:GetDOM("Employee Records")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:EmployeeID[../d:Title = current()]

Re: Repeating Employee Table

kameron.berget — Thu, 24 Oct 2013 16:10:08 GMT

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 Class:xdXDocument:GetDOM("Employee Records")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:LaborClass[../d:Title = xdXDocument:get-DOM()/my:myFields/my:Time/my:Employee] The Employee table uses the Title field for the name.

Re: Repeating Employee Table

Hilary Stoupa — Thu, 24 Oct 2013 16:06:01 GMT

Okay - if things are getting set to the value of the first row, something is off with your filter. Can you paste in the full XPath of the expression you are using?

Re: Repeating Employee Table

kameron.berget — Thu, 24 Oct 2013 15:58:35 GMT

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 Class:1 Subsequent rows take the values from the first row.

Re: Repeating Employee Table

Hilary Stoupa — Thu, 24 Oct 2013 15:46:18 GMT

When you say "set incorrectly" could you please tell me what "incorrectly" means here? Is the value being set to anything? To the wrong value? The first value? Some random value? :)

Re: Repeating Employee Table

kameron.berget — Thu, 24 Oct 2013 15:41:23 GMT

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.

Re: Repeating Employee Table

Hilary Stoupa — Thu, 24 Oct 2013 15:36:10 GMT

Hi - when you say don't set the values correctly, what do you mean? Are the values not getting set at all? Are they getting set to something unexpected?

Repeating Employee Table

kameron.berget — Thu, 24 Oct 2013 13:16:27 GMT

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 rule works for the first row but subsequent rows don't set the values correctly. What is the trick to getting this to work? My rule goes something like: EmployeeID[Title = Employee] LaborClass[Title = Employee] I have done this before but something seems off about this. I hate to set the post back for each row since I will possibly have 100's of rows.