InfoPath Dev

Hello All!

Wondering if anyone would be able to help me.

I've a simple form with a repeating table inside, there are only 4 columns.

The last column is a checkbox where if the box is checked, it'll send an email of the data on that row to someone when the button is clicked.

What it's happening right now is that, it only send the 1st row of data when I've about 4 out of 10 rows checked.

Any idea what I'm doing wrong?

Thank you very much in advance!

Hi:

Does the button have code on it to do this? Can you post your code?

Hello Hilary!

Thank you for your quick respond!

Here is the code:

using Microsoft.Office.InfoPath;

using System;

using System.Windows.Forms;

using System.Xml;

using System.Xml.XPath;

using mshtml;

public partial class FormCode

// Member variables are not supported in browser-enabled forms.

// Instead, write and read these values from the FormState

// dictionary using code such as the following:

//

// private object _memberVariable

// {

// get

// {

// return FormState["_memberVariable"];

// }

// set

// {

// FormState["_memberVariable"] = value;

// }

// }

// NOTE: The following procedure is required by Microsoft Office InfoPath.

// It can be modified using Microsoft Office InfoPath.

// Write your code here.

string valueField2 = null;

string body = null;

EmailSubmitConnection esc;

string valueField4 = xn.Value;

valueField2 += mds.SelectSingleNode("/my:myFields/my:myGroup/my:Field2", NamespaceManager).Value + "\n";

You are selecting the first row when you use:

mds.SelectSingleNode("/my:myFields/my:myGroup/my:Field1", NamespaceManager).Value

for example. Instead, you could use:

xn.SelectSingleNode("../my:Field1", NamespaceManager).Value

to get the value of Field1 for the same Group instance as the Field4 that is 'True'.

Sorry Hilary,

 Would this be what you mean?

// Write your code here.

string valueField2 = null;

string subject = null;

XPathNavigator mds = MainDataSource.CreateNavigator();

XPathNodeIterator xi = mds.Select("/my:myFields/my:myGroup/my:Field4", NamespaceManager);

valueField1 += xn.SelectSingleNode("/my:myFields/my:myGroup/my:Field1", NamespaceManager).Value + "\n";

//subject = valueField1 + " " + valueField2;

Well, not quite. You see, you are still using the full xpath, which takes you back to the first item. So instead of this:

valueField1 += xn.SelectSingleNode("/my:myFields/my:myGroup/my:Field1", NamespaceManager).Value + "\n";

You'd want this:

valueField1 += xn.SelectSingleNode("../my:Field1", NamespaceManager).Value + "\n";

Hello again Hilary,

Thank you very much that works!

However, I've decided to make some changes.  Instead of just email to the one that's being checked.

I've added another checkbox whish will email to another person, & now it's not working on both.

Here is my code

// Write your code here.

string valueField2 = null;

string valueField4 = null;

//string subject = null;

XPathNavigator mds = MainDataSource.CreateNavigator();

XPathNodeIterator xi4 = mds.Select("/my:myFields/my:myGroup/my:Field4", NamespaceManager);

valueField2 = xn4.SelectSingleNode("../my:Field2", NamespaceManager).Value;

valueField2 = xn5.SelectSingleNode("../my:Field2", NamespaceManager).Value;

Hello Hilary,

Once again, thank you for all the helps.

I don't know if this is the best way, but it seems to work for me. Please feel free let me know if you have any better advice.

Here is my code:

// Write your code here.

string valueField2 = null;

string valueField4 = null;

//string subject = null;

string bodyFalse = null;

EmailSubmitConnection escTrue = null;

XPathNodeIterator xi4 = mds.Select("/my:myFields/my:myGroup/my:Field4", NamespaceManager);

valueField1 = xn4.SelectSingleNode("../my:Field1", NamespaceManager).Value;

valueField3 = xn4.SelectSingleNode("../my:Field3", NamespaceManager).Value;

valueField1 = xn4.SelectSingleNode("../my:Field1", NamespaceManager).Value;

valueField3 = xn4.SelectSingleNode("../my:Field3", NamespaceManager).Value;