InfoPath Dev

ExecuteAction doesn't work very well.  It has a lot of bugs. I find it easier to just add the xml directly to the data source. Setup a DOM with the data from sampledata.xml to use as your pure source of xml like this: (you will need to modify the namespace line for your form) (in C#) SampleDOM = ...

Hi George, Sounds like you're talking about the often-requested "template" feature. If the forms are the same and you want to use one as "sample data", we call that request the "template" feature because you use the data from one as a template for others. Merging is definitely meant to do this and much ...

Calculate the ID but store it in your form and reuse it each time. Since you are using SharePoint you can also create a data connection to the library and search for the max number or find the file already and validate the name is the same. Probably the best thing is to not create the file name in the data connection but in your form and save it ...

Instead of using now() each time.  Set in Open Rules if the form is new (a required field is blank or whatever) to populate a field with Now() which essentially is creationdate. Then use this new creationdate field in your file name and do not modify if the form is opened again.  That way your file name remains the same through out the ...

I have a situation (fairly long explaination) where I need to pull many values from one form onto another. The first form (a) is sparsly populated, the second is fully populated. To save time having to retype entries from form B into form A I was hoping there would be an automated solution. I briefly looked into merging, turned it ...

Hi Clay, RE: Concat(Name, "-", Date, "-", ID) -- I have everything up to ID ... I'm struggling how to create a random number to populate the ID field only ONCE (when the form is initially created, not every time a user opens the form from SharePoint). Any thoughts? Thanks, Tom [quote user="Clay ...

[quote user="Ted Fitch"]Hi Jeff,  You can do this without code.  One way I have done this within InfoPath is to concenate a unique name by using: the user alias of the person submitting the form, data from one required field in the form, and then the now() function that returns the current date/time in ISO format.  This ...

Hi Steve, Check out the following link: http://blogs.msdn.com/infopath/archive/2006/08/29/730062.aspx. In general, our Database Accelerator Web Service will simplify your form significantly since it will abstract the XML to SQL DB mapping and allow you to define the mapping separately without having to worry about redesigning your form every time ...

Hi there and welcome to the forum. Are you creating the form from scratch as a database type? It should give you the stock template where you can add the query fields and data fields. With that you should be able to preview and do some simple testing of queries. It is possible that it is changing views or your query is of a really large table ...

Hi Peter. That is not too much to ask and it can be done. Do all of the managers have InfoPath? The trick is getting the data into SQL. If you would like a demonstration of a similar configuration I could show you one. You can click on my name and send me an email directly to schedule something.