Okay, went back and tried again. Maybe it's my syntax (which would NOT be a shock to ANYONE!)
I have a drop-down box where the user can pick the Objective. When chosen, I query for that record and set the fields. I tried to add the formula where I set fields, but I keep getting errors, and I don't know how to fix it. ='( This formula doesn't get errors when I put it as a rule in multi-selection box. However, it also doesn't fill the fields. Here's the formula:
ObjICPNum = ICPNum[count(current()/preceding-sibling::ObjICPNum) + 1]/Value
XPath - xdXDocument:GetDOM("Site Objectives-By Objective")/dfs:myFields/dfs:dataFields/d:SharePointListItem_RW/d:ICPNum[count(current()/preceding-sibling::my:ObjICPNum) + 1]/Value
When I try to set the field's value (ObjICPNum) in my "SetObjectiveFields" rules, I get this error:
"preceding-sibling::my:ObjICPNum" does not point to a valid location path of a field or group.
That's where I get stuck. =( I can't figure out how to make it valid... ARGH!!!
Oh, and if you need the XPath for ObjICPNum, it is: /my:myFields/my:Objectives/my:ObjectiveDetail/my:ObjICPNums/my:ObjICPNum