General

Re: Passing Values Between Forms

ssaral — Wed, 21 Mar 2007 15:26:41 GMT

Thanks I'll see what I can do...

Re: Passing Values Between Forms

Greg Collins — Tue, 20 Mar 2007 16:58:47 GMT

That's the code I wrote earlier where it uses the "[]" filter. You make this selection into your other form's DOM (as per the example you already downloaded).

Re: Passing Values Between Forms

ssaral — Tue, 20 Mar 2007 14:32:52 GMT

So I'm counting the rows now, how do I get the buttons to transmit the value of each row to the other form? This is really painful for me, thanks for your help....

Re: Passing Values Between Forms

Greg Collins — Mon, 19 Mar 2007 21:33:05 GMT

No, no. Preceding-sibling doesn't work the way you are trying to use it. It needs to start from your current selection (i.e. eventObj.Source). You're trying to make it go all the way back to the root node, which has NO preceding siblings. And you need to also use it on a Repeating Node (i.e. the table row itself), not an Attribute.

So it would be more like this:

var rowNumber = eventObj.Source.selectNodes("preceding-sibling::d:ProductLinesValue").length + 1

It selects rows ONLY to get the count. That's how you can figure out which row # you were on when you clicked the button. Notice the ".length + 1" This says to get the count of all the rows before the one you clicked the button on, PLUS count in the current row. That gives the accurate row number that you will need for selecting the same row number in the other form.

Re: Passing Values Between Forms

ssaral — Mon, 19 Mar 2007 19:24:11 GMT

Yes this is very helpful, so I would use it like this then:

var rowNumber = eventObj.Source.selectNodes("preceding-sibling::dfs:myFields/dfs:dataFields/d:ProductLinesValue/@ProductLineValue").length + 1

but I don't know how many rows it will end-up selecting...is there a way you can tell it to count through all the rows...?

Thanks

Re: Passing Values Between Forms

Greg Collins — Mon, 19 Mar 2007 18:51:11 GMT

Ah, okay. So what you need to do is to get the current row of your current table, so that you know which row to update in your second form.

You can do this using the preceding-sibling:: axis. This would be something like:

var rowNumber = eventObj.Source.selectNodes("preceding-sibling::my:RowNodeName").length + 1

Then use rowNumber to set the proper row in the other form using the xpath filter "[]"

selectSingleNode("/Table/Row[" + rowNumber + "]/Field").text = Value

Hope this helps.

- - - - -

P.S. I would also highly recommend updating to SP2. There were numerous bug fixes in SP2 and it has been proven stable.

Re: Passing Values Between Forms

ssaral — Mon, 19 Mar 2007 18:14:47 GMT

I#%92m not trying to change the Label of a button; the label will stay static.

I would like to use a button to open another form (which is easy to do with rules) but at the same time I would also like to pass some values from a specific row of the repeating table where you clicked the button to open that second form.

I have it sort of working based on your previously downloaded samples, but the button is only passing the first row item from the repeating table. I would like each button to pass its equivalent row value...thanks

Re: Passing Values Between Forms

Greg Collins — Fri, 16 Mar 2007 16:30:26 GMT

So if you have a single repeating table and want to set the value of another field within the same row, you can use rules for this... Rules work such that when a value changes on a field, the rules for that field get run. This lets you change the value of another field on that same row very easily.

HOWEVER... you talk about buttons and setting values on buttons. I am not sure exactly what you mean by that. IF you mean that you want to change the button's label (i.e. the visible text on the button) then you will not be able to do this. InfoPath 2003 does not support dynamic button labels, while InfoPath 2007 does. This is why I asked you about which version you are using. If you have some other thing you want to do with the buttons and the values, please explain further.

Re: Passing Values Between Forms

ssaral — Fri, 16 Mar 2007 12:39:36 GMT

Yes, I mean a button control and I'm using InfoPath 2003 SP1. I believe I don't want to copy values from one table to another.

The concept I'm trying to implement is as follows:

ProductLinesValue is a column in a table with lots of stuff in it. I wanted to display each row value in that column, which can easily be done using a repeating table. Next I want to place a button control next to each row item inside the repeating table (in another column) that is set to the value of that row. I will later use this button to open another form that lets you edit that selected row value and submit it back to the db it came from......thanks

So the end result for example would look like this on the form:

Red Edit
Blue Edit
Green Edit
Black Edit
Yellow Edit

Re: Passing Values Between Forms

Greg Collins — Thu, 15 Mar 2007 21:10:38 GMT

values is a collection of all @ProductLineValue attributes (the actual attributes, not just their values).

value gets set to each item in the values collection, one-by-one, not "every value in values" -- just one value at a time.

When you say assign to button, what do you mean? Are you talking about a Button Control?

Also are you using InfoPath 2003 or 2007?

So are you copying values within the same table, or from one table to another?

Re: Passing Values Between Forms

ssaral — Thu, 15 Mar 2007 20:21:39 GMT

Thanks for the response, but I'm really bad with writing scripts...what would that something be?

I'm trying to assign those node values to a button in each row of a repeating table.

So the 'var value' would equal to every value in 'var values', but I'm not sure how to write the code for that.........thanks

Re: Passing Values Between Forms

Greg Collins — Thu, 15 Mar 2007 16:50:09 GMT

selectNodes() will return a list of nodes... then you must step through them one by one.

var value;
var values = XDocument.DOM.selectNodes("/dfs:myFields/dfs:dataFields/d:ProductLinesValu
e/@ProductLineValue");

while(value = values.nextNode())
{
// do something with value node here...
}

Re: Passing Values Between Forms

ssaral — Thu, 15 Mar 2007 14:51:31 GMT

getting closer...the thing is I'm using a repeating table to display my values and when I use:

var value = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/d:ProductLinesValu
e/@ProductLineValue");

it populates all my Edit buttons with the first value of from the repeating table, so I tried using:

var value = XDocument.DOM.selectNodes("/dfs:myFields/dfs:dataFields/d:ProductLinesValu
e/@ProductLineValue");

which doesn't return any values, is there a different property I need to use for XDocument to get each row item read into it's own button....can I put current() in there somewhere, what is the syntax for that...thanks

Re: Passing Values Between Forms

ssaral — Thu, 15 Mar 2007 12:51:55 GMT

Thanks I'll give this method a try

Re: Passing Values Between Forms

Greg Collins — Wed, 14 Mar 2007 20:55:17 GMT

Sorry - forgot to add the link. Here it is:

http://www.infopathdev.com/forums/topic.asp?TOPIC_ID=4451