InfoPath Dev

I finished creating a form template using InfoPath 2007and used the Publishing Wizard to publish the form to a Forms Library on SharePoint 2007.  The last step of the wizard asks to name the file, is there a way to format the file name a specific way (For example, RANK_LASTNAME_STARTDATE)  ??   Where RANK, LASTNAME and STARTDATE are fields on the form.    

there sure is.  On that last step, you select the function or equation box to the right of the file name box.  Use the concat function and you can add the fields right there.

Another option would create a field that has the filename in it already(using the concat function) and just selecting that text box for the file name in setting up your data connection.

Barmatt80:

Thanks for the reply !  I have tried your procedures using the fx button to no avail.  Correct me if I am wrong, do i need to be in design mode on the form and then do the following:    Tools --> Submit Options --> Allow users to submit this form (checkbox).  Click on "SharePoint document library"  then click on "Add" then I see the "Fx" or formula box.  In the Insert Formula Box:  I see 3 buttons (Insert Field or Group, Insert Function, Verify Fomula).  I click on "Insert Field or Group" button for RANK.  I do the same for LastNAME and StartDate fields so it looks like this:  RANK + LASTNAME + STARTDATE then click on OK button.  

After accomplishing this, do i now go to FIle --> Publish  ...??  and then test out the form

You would want to use the Insertfunction and select concat first.

concat(RANK, ",", LASTNAME, "-", STARTDATE) or maybe you do not want the seperating characters but that would be the syntax.

I would probably add a field to your form. Add a rule on submit that sets the field to this formula if it is blank. That way it gets set on the initial submit but not on subsequent where posisbly this data could change.  This way you have the filename in your document for future reference.

Then just use this field as the file name in submit connections.

When your form is complete then publish out to SharePoint.

I think you are missing the submit data connection which is where you specify the location for the XML to be saved. Then you select this data connection for your submit action.

Tools -> Data Connections Go through the wizard.

If I add a field to the form where would I place it on the form (hiden from view so users would not see it)  ?  Also wold I have to add a Data source to this field ?

Can you clarify when submitting the form using the same field how would I be able to accomplish this ? Perhaps this is similar to another blog I posted concerning "Submit Control Button".  

I also see a Tools --> Submit Options  as well.  Do I need to configure this as well ??

Hey Walter.

You can add a field to your data source but not to a view.  This field would be then "hidden" from the user's perspective.

The submit options is a way to handle form submits globally but not necessary if you use submit actions.

Probably from a perspective of getting started, once you have your data connections created you can use it with custom rules and look at the advanced options etc.

Hi Clay,

I am very interested in the technique you are describing. Could you please elaborate on it? I have been struggling for a week to find a solution to this. I want the submit options to "autogenerate" a name. This I know how to do, I am basically just using the now() function. However, If the user goes back and edits the form, and hits the submit button I don't want it to create a new file, but just overwrite the current file. Is there a way to do this type of logic in the "Insert Formula" section of the file naming? I believe that is what you were talking about when you say store the name in a field on the form, but can you please just walk through this procedure? I would really appreciate it.

 Thanks!

Create a field in your main datasource called filename

Add a open rule (Tools, form options, Open, rules)

Add a condition if filename is blank.

Set filename to now()

Then in your submit for the filename just reference the field.