Code

Re: How to select 2 fields to name form with code?

Hilary Stoupa — Thu, 24 Feb 2011 22:25:44 GMT

Glad you figured it out -- and I apologize for missing your post!

Re: How to select 2 fields to name form with code?

ashoke — Thu, 24 Feb 2011 20:14:35 GMT

Hi - I just have fixed the issue. It was my xpath problem. It should be "/dfs:myFields/dfs:queryFields/q:top/@PrgYear". It's now working perfect. Thanks, Ash

Re: How to select 2 fields to name form with code?

ashoke — Thu, 24 Feb 2011 17:40:28 GMT

Hi Hilary - Good morning! I have a similar yet simpler situation for a form connected to Access db. I need to get the filename from an input in a node named "PrgYear". Following code isn't working. Can you please have a look and help me figure out the problem? Thanks, Ash

string filename = this.MainDataSource.CreateNavigator().SelectSingleNode("dfs:queryFields/q:top/@PrgYear", this.NamespaceManager).Value;

this.CurrentView.Export(@"G:\02 Dept Folders\Clinical Registries\43130 CORR\43132 Transplants\07 Statistics\Transplant Quarterly Reports\ASH\input_form&db\" + filename + "_Table1A.xls", ExportFormat.Mht);

The error msg:

System.NullReferenceException
Object reference not set to an instance of an object.
   at Table_123_exp.FormCode.CTRL830_7_Clicked(Object sender, ClickedEventArgs e)
   at Microsoft.Office.InfoPath.Internal.ButtonEventHost.OnButtonClick(DocActionEvent pEvent)
   at Microsoft.Office.Interop.InfoPath.SemiTrust._ButtonEventSink_SinkHelper.OnClick(DocActionEvent pEvent)

Re: How to select 2 fields to name form with code?

natchos — Wed, 16 Feb 2011 16:25:50 GMT

Good morning, just a quick note to say thank you so much for your help!

And also, for your tips! Much appreciated! I shall do that in the future.

Thanks again and have a great day!

Natacha

Re: How to select 2 fields to name form with code?

Hilary Stoupa — Tue, 15 Feb 2011 01:33:57 GMT

Hi:

You can concatenate your two field values together.

So, like this:

string field10 = this.MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:field10", this.NamespaceManager).Value;
string field7 = this.MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:field7", this.NamespaceManager).Value;
string Filename = field7 + " - " + field10;

Of course, you could also add another field to your form that uses the concatenated values as a default, then just reference that field in your code.

Now, I would be remiss if I didn't mention to you that you really, really, really, if at all possible, should rename your fields. If your form is not currently in production, you can rename these without too much trouble, and then, in a few months, when you open this template to work on it again, you'll be so happy you did. If you give all your fields and groups meaningful names, future you will thank present you (as will any other designer who ever needs to work on your form).

If this form is already in production, things get more complicated, because you don't want to risk losing data, and writing a custom upgrade transform is probably a bit advanced. But for next time, be sure to name your fields right from the start.

How to select 2 fields to name form with code?

natchos — Mon, 14 Feb 2011 15:26:35 GMT

Hello everyone.

This site has been very handy for me. I found lots of great ideas for my forms, thank you!

I have a question that I cannot find an answer for, perhaps one of you can help me?

I want to be able to chose field7 and field10 on one of my forms to create the name of my file when using a custom button with code.

Here is the code I have, but it will only work for field7, I do not know if it is possible to chose 2 fields to name a file. If it is, could you please help me with the syntax please?

string Filename = this.MainDataSource.CreateNavigator().SelectSingleNode("/my:myFields/my:field7", this.NamespaceManager).Value;

this.Print();

this.CurrentView.Export(@"\\fps1\es\" + Filename + ".pdf", Microsoft.Office.InfoPath.ExportFormat.Pdf);

Thank you very much!