General

Re: Changing values on repeating section

Carlos — Mon, 01 May 2006 01:19:25 GMT

Thanks Agni. I will try to convert this logic to VBScript.

Cheers,

Re: Changing values on repeating section

Agni Jonnalagadda — Fri, 28 Apr 2006 09:14:39 GMT

Hi Carlos,
Here is the code for selectnodes, this is in JScript

var OC = XDocument.DOM.selectNodes("/dfs:myFields/dfs:dataFields/d:tbl_Project/d:tbl_Outcome");
for(i=0 ; i < OC.length; i++)
{
if (OC.selectSingleNode("@Outcome_Changed").text = "Y")
{
OC.selectSingleNode("@Outcome_Changed").text = "N";
OC.selectSingleNode("@Outcome_Changed_Note").text = "";
}
}

Changing values on repeating section

Carlos — Fri, 28 Apr 2006 06:07:45 GMT
Sorry if this has already been discussed. I did a search and found info, but didnt help me. This should be easy for the pros tho :)

I have a field in a repeating section (a checkbox) in which I used an onload to try and change the value of 2 fields. Code below:

Sub XDocument_OnLoad(eventObj)
XDocument.Query

Set OC = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/d:tbl_Project/d:tbl_Outcome/@Outcome_Changed")
Set OCN = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/d:tbl_Project/d:tbl_Outcome/@Outcome_Changed_Note")
If OC.Text = "Y" Then
OC.Text = "N"
OCN.Text = ""
End If
End Sub

Now this works a treat only for the first value, ignoring subsuquent ones. I tried to get my head around selectNodes but cant seem to get it to work. Can someone please show me what changes I need to make.

Sorry for the lame post.

Cheers,