-
Hi there -- double check the name of your submit data connection and verify that it is called 'NNGSubmit", including using the same case.
-
So up until the last section is filled out, the form info doesn't go to the DB. Yet you need a unique ID that the form can use in its name for the entire life of the form.... But since the form isn't submitted to SQL until the end of its activity, querying the SQL table that you store them in could surely lead to duplicate IDs. After all, ...
-
Where all does your form submit? Do you submit via rules? You could submit just to the DB, get the ID back, set the form's name and sumbit to SharePoint, for example. Just a thought.
-
Well, you will greatly reduce the chance of a multiple IDs if the query is run on submit, yes... Or, you know... Are you submitting to a DB? Can you add an auto-id column to the table you submit to? Then you don't have to try to grab a max and add one or anything like that.... the form would get its ID on submit....
-
Just to clarify -- the create statements for the sprocs in my blog post *do* work in SQL Server Management Studio.... but TOAD doesn't seem to like them. When you say 'I have no idea how to modify the query's results' -- couldn't you just use the field in a formula? Say, in the default value for the form field that will hold ...
-
Oh dear. I hadn't realized that was new option for InfoPath 2007. I'm afraid then that your only option would be to write code for this so that the form information was in the body of the email. This post has more info.
-
Hello, and welcome:
You should be able to modify this in the data connection for the email submit. Go to Tools / Data Connections and select the data connection for your email submit. Click the Modify button. On about the second screen of the wizard, you have the option to send only the active view of the form rather than including it as an ...
-
We've updated the instructions for this download -- hopefully it will be easier for you to try now: http://www.infopathdev.com/files/folders/examples/entry29401.aspx
-
Do keep in mind the different object models for InfoPath. InfoPath 2003 OM (C#) uses thisXDocument. You can change your form to use C# (InfoPath 2003 Compatible) under Tools / Form Options / Programming. The 2007 OM (C#) uses this. You can also make this change in a Visual Studio InfoPath project, you just have to click Remove Code first.
You ...
-
Hi:
I've attached a simple sample form -- easier than trying to explain it! Right click on the link in the heading of the post and select save as. Then open the form in design mode and preview. Basically, what I've done is on the filter for the drop down list, I've used the double eval trick described here to create a ...