Code

Re: Pass Parameter to an unopened form

Svetoslav — Wed, 11 Mar 2009 15:00:55 GMT

Hello all,

The method works just perfect. I have achieved my purpose. It was a stupid mistake that I havent updated my second(the new) form, and so the Xpath was not correct. Sorry for bothering you!

I am very grateful for this site, that it provides perfect solutions to not so advanced users.

P.S. I hope I will become :)

Regards,

Svetoslav

Re: Pass Parameter to an unopened form

Svetoslav — Wed, 11 Mar 2009 14:38:30 GMT

Hello nukkumatti,

I was reading this topic, because I have a similar problem. As a matter of fact I tried your code ( the 1st solution that you proposed) and it worked perfectly ( with my variables). After that I used this method in my IP form, but it kept showing me an error message "". I am posting now my code:

function CTRL90_5::OnClick(eventObj)

{

var secondFile = Application.XDocuments.NewFromSolution("Template location"); //the new template location on SharePoint

var crNumber = XDocument.DOM.selectSingleNode("/my:myCR/my:crForm/my:crNumberInit").text; //the value on the 1st form,that I have to pass to the new o

var aiID = secondFile.DOM.selectSingleNode("/my:myAI/my:aiNumber"); //the place in the new form where i place the above value

aiID.text=crNumber;

}

It seems that now it cannot select the field in the new form. It opens the new form, as well as select the the crNumber variable. But the last line gives me the error: " null " is null or not an object. From my point of view the error is that the variable aiID is not located by the XPath. It is very strange for me because the same method but with different variable name and Xpath worked perfect (for the Xpath in this case I am sure that it correct). I am lost ... I need some help.

Best regards,

Svetoslav

Re: Pass Parameter to an unopened form

troy0118 — Sat, 21 Apr 2007 02:27:25 GMT

Thanks for reply.

Two forms are required. The screenshots you see are not for real. It's just my sample database.

Re: Pass Parameter to an unopened form

Clay Fox — Fri, 20 Apr 2007 17:52:47 GMT

Just catching up on this thread but I thought I would throw out an idea that might simplify this solution. From what I see in the screen shots, you are making it more complicated than it may need to be by having two forms.

It appears you have two tables of data, one for Name and ID and the other for ID and Salary. Are these in a database? If so you could just use the table relationships and put it all in one form. You can have one table as your main and then add an additional table with the ID as the key relationship. This allows you to update either table, query, etc.

Otherwise, I am not sure which list you are modifying, if at all but if the lists are not large you could load both and use filtering to view the appropriate records.

Just thought I would throw that out, maybe you have other requirements that is justifying having two forms instead of one with multiple views, etc.

Re: Pass Parameter to an unopened form

troy0118 — Fri, 20 Apr 2007 15:55:12 GMT

Thanks, nukkumatti.

I did the same thing you did before. I copied the namespace from Salary form, but it generated error by saying duplicate definition.

I must have done something wrong. Could you please tell me when I deal with namespace, what should I focus on to avoid such mistakes?

Again, thank you very much.

Troy

Re: Pass Parameter to an unopened form

nukkumatti — Fri, 20 Apr 2007 08:10:22 GMT

BTW - You can get the namespace definition form the script editor of your second form or use a method calles something like getNamespace, not sure though. Have fun with further development and keep on posting your questions.

Re: Pass Parameter to an unopened form

nukkumatti — Fri, 20 Apr 2007 07:26:55 GMT

Hi Troy,

I received your eMail. Don't get me wrong now but please stop sending me eMails. I help people in this forum voluntarily and post questions and answers only when I have time for it as I also have a regular job. The mail address is mainly used to get in contact with Patrick or his team. This forum is just great and in my oppinion the best reference you can have regarding some infopath issues, better than any book. You cannot expect that other people do the work for you, usually you had to pay money for that extensive help. There is a bunch of information arround and with a little more investigation you could may be have figured out your problem alone.

Anyway I had a look on your forms and now it was obvious what was wrong. You need to make your current form aware of the namespace prefixes which are coming form your second form otherwise your active form cannot interpret the ":dfs" for example.

So here is the code you need:

var toPass = XDocument.DOM.selectSingleNode("dfs:myFields/dfs:dataFields/d:Name/@id").text;
var salary = Application.XDocuments.NewFromSolution("C:\\Temp\\Salary.xsn");
salary.DOM.setProperty("SelectionNamespaces", 'xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:q="http://schemas.microsoft.com/office/infopath/2003/ado/queryFields" xmlns:d="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields" xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-04-18T13:37:36" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003"');

salary.DOM.selectSingleNode("dfs:myFields/dfs:queryFields/q:Salary/@id").text = toPass;

Re: Pass Parameter to an unopened form

troy0118 — Thu, 19 Apr 2007 14:50:33 GMT

I sent an email to you. I think you probably didn't notice it. If you can give me your email address, I can send you the sample I am working on. I think it's better.

This is the data structure. It's kind of simple because this is just a sample database.

Re: Pass Parameter to an unopened form

nukkumatti — Thu, 19 Apr 2007 07:47:53 GMT

Hey Troy,

please post the structure for your second forms datasource so that we may find out the xPath together. Sorry that my posts have always a big delay but we are in two completey different time zones.

Re: Pass Parameter to an unopened form

troy0118 — Wed, 18 Apr 2007 20:10:03 GMT

Hi,

It doesn't work.

var Topass = XDocument.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/d:Name/@id").text;
var Salary = Application.XDocuments.NewFromSolution("C:\\Temp\\Salary.xsn");
Salary.DOM.selectSingleNode("/my:myFields/my:id").text = Topass; <= Still got error message from this line.
" Reference to undeclared namespace prefix: 'my'. "

The following is my sample database.

Name
id	name
1	Jack
2	Jason
3	John

Salary
id	Salary
1	$500.00
2	$600.00
3	$700.00

What should I do? I am gonna go crazy.

Re: Pass Parameter to an unopened form

nukkumatti — Wed, 18 Apr 2007 16:42:48 GMT

Salary is the reference to your second form so you need to specify the xPath of the field of your second form in which you want to write the value of your first form. sorry but i can´t tell you your xPathes, my be it´s just ("my:myFields/my:Id") ?

Re: Pass Parameter to an unopened form

troy0118 — Wed, 18 Apr 2007 14:50:13 GMT

Hi nukkumatti,

Thanks again.

var Getid = XDocument.DOM.selectSingleNode("dfs:myFields/dfs:dataFields/d:Name/@id").text;
var Salary = Application.XDocuments.NewFromSolution("C:\\Temp\\Salary.xsn");
Salary.DOM.selectSingleNode("dfs:myFields/dfs:queryFields/q:Salary/@id").text = Getid;
^^^ <= error message "Reference to undeclared namespace prefix: 'dfs'"

Namespace defined in the form:
XDocument.DOM.setProperty("SelectionNamespaces", xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:q="http://schemas.microsoft.com/office/infopath/2003/ado/queryFields"
xmlns:d="http://schemas.microsoft.com/office/infopath/2003/ado/dataFields"
xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution"');

I got the xPath from expression box. The first one works, but not the second one.
Why is that? I don't get it.
I am almost there. Please help me out.

Re: Pass Parameter to an unopened form

nukkumatti — Tue, 17 Apr 2007 06:14:13 GMT

I think you mix things up there.

Okay again,

first you have a paramter from your active form which you want to pass to your second solution for example: var parameterTopass = XDocument.DOM.selectSingleNode("my:myFields/my:ID").text; the xPath should point to the drop down list from your picture (on the left side) where the ID is in. If I see this correct this is what you want to pass to the second solution.

now you need a reference to your second solution you want to pass your parameter to: var SalarySolution = Application.XDocuments.NewFromSolution("C.\\Temp\\Salary.xsn");

now pass the paramter of your current solution to your second: SalarySolution.DOM.selectSingleNode("dfs:myFields/dfs:dataFields/d:personal/@id").text = parameterTopass; and again please verify that your xPath is correct there.

Re: Pass Parameter to an unopened form

troy0118 — Mon, 16 Apr 2007 15:58:12 GMT

Hi nukkumatti,

This is what I have now:
1. var SalarySolution = Application.XDocuments.NewFromSolution("C:\\Temp\\Salary.xsn");
2. var getid = SalarySolution.DOM.selectSingleNode("dfs:dataFields/d:personal/@id").text;
(However, I still got the error message "Reference to undeclared namespace prefix: 'dfs'")
3. getid.text = "id";
(Is this the way to pass the value to the id field on Form2?)

if we write var getid = xxxxxx.text (line2), then shouldn't we have getid = "id" (line3)?

Re: Pass Parameter to an unopened form

nukkumatti — Mon, 16 Apr 2007 11:48:12 GMT

Hi you are on the right track.

First thing to try is replace ("\C:\\Temp\\Salary.xsn") with ("C:\\Temp\\Salary.xsn"). I am not sure if your path is incorrect but for me it works without the firs "\".

var getid = SalarySolution.DOM.selectSingleNode("/dfs:myFields/dfs:dataFields/d:personal/@id").text;

Yes this line is meant to get the value of the id field but I guess that just the xPath you are using is wrong. A nice way to get the correct xPath is using expression boxes. Drop an exBox to your form and point it to the datasource of your ID drop down list control and then check the "Advanced edit xPath" box to get the correct xPath. This you can then use your selectSingleNode function and i guess everything should work. Also try there to leave the first "/".

Let me know if it helped.