Newbie Questions

Re: Delivery of value between form A to form B

BuildPro Guru — Fri, 12 Sep 2008 19:42:13 GMT

Hello Greg. I am desparately searching to find a way to pass values from form A to form B (form B is created via rules on a button on form A). I have read just about every post here (and elsewhere) and I just can't get it working. You have a link in this post to some sample forms that you created, but the link does not work. Would you happen to still have those forms somewhere or could you provide other assistance?

I am not entirely new to IP, but I can only plagiarize and tweak code to get it to work (my coding language is google ++) so please be liberal with the explainations. I am on an XP Pro box with IP07.

Thanks in advance.

Re: Delivery of value between form A to form B

Greg Collins — Tue, 13 Mar 2007 18:07:33 GMT

Thanks for your kind words!

Re: Delivery of value between form A to form B

Smeets — Tue, 13 Mar 2007 12:34:52 GMT

Hello Greg,

thanks a lot.
That's no problem that it took a little longer.

I'm interessted in this Programm and also SharePoint.
The forms are built in a SharePoint portal.
If one has still no notion of it, this forum is particularly for InfoPath very useful and helpful.

Thanks again.

Re: Delivery of value between form A to form B

Greg Collins — Mon, 12 Mar 2007 16:10:55 GMT

Matthias,

I am glad to have been able to help you. Working across forms can be very frustrating if you've never done it before -- and even when you have done it before. I'm sorry it took us so long to get it working for you, but I'm glad that you have it working now!

Keep up the good work--it gets easier the more you work with it!

Re: Delivery of value between form A to form B

Smeets — Mon, 12 Mar 2007 11:34:06 GMT

Hello

thank you for the example forms. This helped me very much.
It has in principle everything been correct, only with the namspaces I had instead of one ":", a "-" set, therefore the form did not open any longer.

Now everything works perfectly.
I imagined already that it can be only one little thing.

I find it great, how much time you invested for me.
Now I can successfully lock my project.

Thank you for your support. I become you further-recommend.

Greeting Matthias

Re: Delivery of value between form A to form B

Greg Collins — Fri, 09 Mar 2007 17:50:19 GMT

You will not need to set XDocument.DOM.setProperty("...") because this is done at the top of the script file. It only needs to be done one time.

I have created a simple 2 Form sample that you can download here. It has Form A and Form B. Form A has a text box and a button. Type anything into the text box and click the button to open Form B and populate the text box in Form B with the value you typed into the text box in Form A.

When you get the .zip file, extract both .xsn files to C:\ because this is where they are expected to be.

Let me know if this helps.

Re: Delivery of value between form A to form B

Smeets — Fri, 09 Mar 2007 09:32:13 GMT

Thanks.

Opening Fomrular B works perfectly.

However the onclick event not as planned.
The form leaves itself to open, but as soon as I merge the following two lines, in the preview I get the error: "the selected form cannot be opened by InfoPath"

var sFormAFieldValue = XDocument.DOM.selectSingleNode("/my:meineFelder/my:id_form").text;
xdFormB.DOM.selectSingleNode("/my:meineFelder/my:id_form).text = sFormAFieldValue;

I think because of the XDocument.
First I have the namespace xdFormB.DOM.setProperty("...") integratet, how you had meant it.
Then I have additionally still inserted the namespace XDocument.DOM.setProperty("..."), but the error emerged again.
What could it still be that it does not recognize these two code lines, and how I know to take the value (in the meantime no more bezeichnungderveranstaltung) from the text field id_form from form A and insert it into the text field id_form (no more schulung) in form B?

I think we stand briefly before the solution of the problem.
I find it also great that you support me so intensively.

Re: Delivery of value between form A to form B

Greg Collins — Thu, 08 Mar 2007 17:22:26 GMT

Hi. Hopefully we're coming to a final solution for you...

First thing is you cannot place a function (openFormB) inside another function (CTRL242_6::OnClick)... that will have to be moved outside the other function...

Also, I'm not sure that in your case you need to use NewFromSolution**WITHDATA***... you probably only need NewFromSolution(). Please refer to the InfoPath internal help or the MSDN web site for help with these functions.

Please note that I haven't tested any of the changes I'm making to the code you provided above... I'm just making changes here inline...

function CTRL242_6::OnClick(eventObj) //button-onclick-event
{
var xdFormB = openFormB();

// Set namespaces here.
xdFormB.DOM.setProperty("SelectionNamespaces", '... xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-14T14:04:34" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003"');

var sFormAFieldValue = XDocument.DOM.selectSingleNode("/my:meineFelder/my:id_form").text;
xdFormB.DOM.selectSingleNode("/my:meineFelder/my:id_form).text = sFormAFieldValue;
}

function openFormB() //your MY_CODE_THAT_OPENS_FORM_B()-function
{
var sSharePointTemplate = "http://sharepoint.company.com/name/Forms/template.xsn";
var oXDoc = Application.XDocuments.NewFromSolution(sSharePointTemplate);
return oXDoc;
}

Maybe this will help.

Re: Delivery of value between form A to form B

Smeets — Thu, 08 Mar 2007 08:25:22 GMT

Thanks for this Information.
It could be also because of my English, which I had sometimes misleadingly expressed myself.
It soundsto very simple to do your tip, but my prgamming knowledge ist not very good, anyhow in JScript.

If I understood you correctly, I have to implement your example in form A, where I open form B with die MY_CODE_THAT_OPENS_FORM_B()-Function.
In every other forms I use rules to open forms, to close forms and fill the fields in this forms.

I searched in books and the internet if there is a help how to open a new form with an button-click. But haven't found realy good informations.
For example I looked at the following page:
http://www.infopathdev.com/howto/bugs/default.aspx?i=9fc31c95201f44a1938ba8d9cf47d5e5
But I don't know how to use this code.

Form B is saved as template.xsn on a server. (like http://sharepoint.company.com/name/Forms/template.xsn)
I don't know to combine this code-lines. I have no fixed *.xml-file an the form whitch should be opened should not be in a "xdCanOpenInReadOnlyMode".

The Code that I have know is the following:
function CTRL242_6::OnClick(eventObj) //button-onclick-event
{

function openFormB() //your MY_CODE_THAT_OPENS_FORM_B()-function
{
var sSharePointTemplate = "http://sharepoint.company.com/name/Forms/template.xsn";
var oXDoc = Application.XDocuments.NewFromSolutionWithData(XDocument.DOM.documentElement, sSharePointTemplate, 1);
thisApplication.XDocuments.Open(sForm, (int)XdDocumentVersionMode.xdCanOpenInReadOnlyMode);
}

var xdFormB = openFormB();
// Set namespaces here.
XDocument.DOM.setProperty("SelectionNamespaces", '... xmlns:dfs="http://schemas.microsoft.com/office/infopath/2003/dataFormSolution" xmlns:my="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-02-14T14:04:34" xmlns:xd="http://schemas.microsoft.com/office/infopath/2003"');

var sFormAFieldValue = XDocument.DOM.selectSingleNode("/my:meineFelder/my:id_form").text;
xdFormB.DOM.selectSingleNode("/my:meineFelder/my:id_form).text = sFormAFieldValue;
}
Sorry, about the german words (like meineFelder), but I use the german IP-version.

I cannot test the code at the moment, since I do not point, like I can/should open form B.

I hope you can help me to finish this.
For now thanks a lot for your time, that you spend at my problem.

Greetings
Matthias

Re: Delivery of value between form A to form B

Greg Collins — Wed, 07 Mar 2007 18:24:46 GMT

I just ran some tests and it looks like I gave some misleading information earlier. XDocuments(0) is NOT always the current document, but rather the first document open. In your case though, since Form A was open first, that would indeed be XDocuments(0). However, for Form B, you don't want to use XDocuments(1) as this will point you back to Form B.

So Form A is already open. This is XDocuments(0).
Button on Form A opens Form B. Form A is still XDocuments(0) in BOTH forms, and Form B is XDocuments(1) in BOTH forms.

Sorry for the misinformation. Maybe this will help. Remember though, Form B *CANNOT* use the OnLoad function to get the value of Form A.

Another option, since you said that Form B is opened by clicking a button on Form A, if you are using code (and not rules) to open Form B, then that function has a return value which is the XDocument to Form B. You can use this XDocument return value to set the field value in Form B. For example:

var xdFormB = MY_CODE_THAT_OPENS_FORM_B();
// Set namespaces here.
var sFormAFieldValue = XDocument.DOM.selectSingleNode("/my:myFields/my:FormAField").text;
xdFormB.DOM.selectSingleNode("/my:myFields/my:FormBField).text = sFormAFieldValue;

Re: Delivery of value between form A to form B

Smeets — Tue, 06 Mar 2007 20:01:04 GMT

The Code is not in the OnLoad-Function, because I have commentated the OnLoad-Function.

Whit the button I save form A and with an other butten I open a new Form. In this case form B. Everything functions without any code because I use rules in the forms.
So die only code I need is in Form B the onload-function to get the value of form A.

Re: Delivery of value between form A to form B

Greg Collins — Tue, 06 Mar 2007 19:45:54 GMT

Sorry, I have to ask this... but did you make sure that the code is NOT in the onload event handler? The new XDocument is not added to the XDocuments collection until after onload has finished. Since you are only getting 1 for the count, InfoPath has not recognized the second form being open yet. That is why the XDocuments(1) fails. The count should be 2.

Re: Delivery of value between form A to form B

Smeets — Tue, 06 Mar 2007 08:03:52 GMT

I implemented the code with the alert box.

I open form A, put in my values, go by button-click to form B (where your code is implemented) an form A is already open, I get in the first alert box the "1" as output.
In the secound alert box I get the infos of the xml-file:
e.g. <my:bezeichnungderverantsaltung>SchulungTest 5</my:bezeichnungderveranstaltung>
an all the other fields which I put an value into will be shown in this alert box.

After that I get an error in the secound part of your code:
x = Application.XDocuments(1).DOM;
>> index value lies outside of the valid range

Re: Delivery of value between form A to form B

Greg Collins — Mon, 05 Mar 2007 17:49:10 GMT

Sorry - I had told you earlier in this thread that you can use this in OnLoad, but I've just verified that it does not work in OnLoad... it has to be done elsewhere--which might take some figuring out on your part as to where it should occur (if you were trying to do it in OnLoad). An OnClick event is just fine, or perhaps an OnAfterChange event.

Re: Delivery of value between form A to form B

Greg Collins — Mon, 05 Mar 2007 17:46:18 GMT

Yes, OM stands for Object Model. If you were able to successfully save your form to work with IP03, open it in IP03 and still run it, then yes, you were using the IP03 OM.

As I look back in the thread, I noticed that I should have seen that you were using the IP03 OM, but you are using JScript and not C#. Sorry--my mistake. I should have seen that.

So-- you are using InfoPath 2003, with JScript. This means that you Application.XDocuments is the right collection to be working with.

What I want you to do is to add the following lines of code and report back what it provides in the alert box:

XDocument.UI.Alert(Application.XDocuments.Count);

var x = Application.XDocuments(0).DOM;
XDocument.UI.Alert(x.xml);

x = Application.XDocuments(1).DOM;
XDocument.UI.Alert(x.xml);
NOTE: This code CANNOT be in the OnLoad event handler or it will not work correctly. The XDocument in not added to the collection until AFTER the onload has completed.