Data Connections

Re: Adding fields in the introduction section of email data connection

Sam — Mon, 19 Nov 2007 11:39:05 GMT

Hi,

I have a rule called close form. I would like to add close form at the code itself because the code doesnt work if the close form rule is set.

Thanks

Re: Adding fields in the introduction section of email data connection

Sam — Mon, 19 Nov 2007 11:17:55 GMT

Thanks.. it works

Re: Adding fields in the introduction section of email data connection

Patrick Halstead — Sun, 18 Nov 2007 21:55:00 GMT

If you navigate to Tools->Form Options->Advanced, you will see a section for Programming Language which states: "The programming language can only be set when no code exists in the form." To remove the code, you will have to extract the form files from the XSN (File->Extract Form Files). Close the Designer. Now, open the manifest.xsf in notepad.

If you previously had your programming language set as jscript, you'll need to remove the following 3 blocks:

    <xsf:file name="script.js">
    <xsf:fileProperties>
     <xsf:property name="scriptType" type="string" value="userEvents"></xsf:property>
    </xsf:fileProperties>
   </xsf:file>

<xsf:applicationParameters application="InfoPath Design Mode">
<xsf:solutionProperties scriptLanguage="jscript" fullyEditableNamespace="http://schemas.microsoft.com/office/infopath/2003/myXSD/2007-11-18T21:45:53" lastOpenView="view1.xsl"></xsf:solutionProperties>
</xsf:applicationParameters>

<xsf:scripts language="jscript">
<xsf:script src="script.js"></xsf:script>
</xsf:scripts>

Save the manifest.xsf with the sections removed. Now open it up again in the Designer and the language dropdown under Tools->Form Options->Advanced will be enabled.

Hope this helps,

Re: Adding fields in the introduction section of email data connection

Sam — Sun, 18 Nov 2007 11:27:34 GMT

Hi, This is what i would like to do but in 2003.

http://office.microsoft.com/en-us/infopath/HA102034701033.aspx

I dont have options for the buttons in 2003.

Re: Adding fields in the introduction section of email data connection

Sam — Sun, 18 Nov 2007 09:42:08 GMT

Thanks alot for your help...

All the below works exactly the way i wanted. My Infopath forms are live and published on Sharepoint. When I try to change the code from VBscript to JScript - it doesnt allow me to do so... The field is greyed out.

Where can i get the same code in vb script..??

Re: Adding fields in the introduction section of email data connection

nukkumatti — Thu, 15 Nov 2007 13:57:34 GMT

To your second questions it must of course be mail.Intro = "This is my body text" + comments; Sorry for that. Coming to you first question I guess why you are sending two eMails is because you forgot to delete one Action on your rules which says Submit Dataconnection which is actually your Mail Submit. Delete this Action/Rule from your button (not the Dataconnection itself) and you should send only one mail now. I also think that Rules are fired before your code in the OnClick event of your button (e.g. you fileupload to SharePoint or what ever). If not then just call everything from code as you upload is nothing else but another DataConnection just use the same functionality than for the mail event. Hope this helps.

Re: Adding fields in the introduction section of email data connection

Sam — Thu, 15 Nov 2007 13:41:16 GMT

Now i can see either the field from the form or text not both -

mail.Intro = ("This is my body text", comments);

Its either This is my body text OR comments

Re: Adding fields in the introduction section of email data connection

Sam — Thu, 15 Nov 2007 13:30:27 GMT

Hi.. Just one more thing...

On one button i have got 6-7 rules.. Since you asked me to use my email data connection - every time now when i press a button i have to send 2 emails.. one from the data connection and 2nd from the code..

I want the email to go to the user only after it is submitted in the doc library and gone through couple of rules. How will i be able to number the code as which rule??

Re: Adding fields in the introduction section of email data connection

Sam — Thu, 15 Nov 2007 13:09:36 GMT

Thanks alot.... It works perfect...

Re: Adding fields in the introduction section of email data connection

nukkumatti — Thu, 15 Nov 2007 12:18:49 GMT

When writing code you should always have the API open because there you can find everything you need (In Script Editor press F1 to open the Help). Please search there for concat to see how to use it correclt. In managed code I would use a StringBuilder object to build my text which i want to add to the intro but for you something like var comments = XDocument.DOM.selectSingleNode(XPath to your control(something like "my:myFields/my:commets")).text; mail.Intro = ("This is my body text", comments) should work.

Re: Adding fields in the introduction section of email data connection

Sam — Thu, 15 Nov 2007 11:47:26 GMT

I know the below code is wrong... can you please tell me where is the problem

mail.Intro = concat("This is my body text", comments);

Re: Adding fields in the introduction section of email data connection

Sam — Thu, 15 Nov 2007 11:23:15 GMT

Hi, Thanks alot .. that code works... hurray!!

But i couldnt concatenate fields in mail.intro.. I dont think i am using the right command.

I have a field called "comments" and everytime a user presses the decline button - the text in the "comments" field should be mentioned in the introduction area of the mail.

hetal

Re: Adding fields in the introduction section of email data connection

Clay Fox — Tue, 13 Nov 2007 16:04:08 GMT

Just to add you can concatenate some text and some fields into the mail.intro to get what you are looking for.

Re: Adding fields in the introduction section of email data connection

nukkumatti — Tue, 13 Nov 2007 12:46:35 GMT

Here is what you need: Add a new Data Connection to your template (or use the one you have set up already). In the OnClick event of you button with which you want to send the mail you can use the below snippet: var mail = XDocument.DataAdapters("Name Of Your DataConnection"); mail.To = homer@simpson.uk; mail.Intro = "This is my body text"; mail.Subject = "bla bla bla" mail.Submit(); Hope this helps. code is in jscript, managed code looks similar but is still different just do a search on the forum.

Re: Adding fields in the introduction section of email data connection

Sam — Tue, 13 Nov 2007 05:19:29 GMT

Hi,

Thanks for your reply.

I have added fields in the subject line using concatenation. I need to add 2 more fields which has to be mentioned with the introduction text.

Can you please tell me where i can find a code for the introduction section and how do i go about it.

Hetal