Browser Forms

while updating smartobject creating duplicate row

dakesun — Tue, 23 Feb 2010 12:30:41 GMT

Hi,

I am using a Infopath form with somany views, i created a smartobject and which created sql database table.

when i submitted the first view, it created a new row in table with first views data in sql database.

but i capture second view data and submitted, it is saving perfectly but creating a another row and saving into that row.

please help, how can i save second view data in the sameid as first and so on.

actually in submit options, i added new rule but its not working as i looking, creating duplicate rows.

Thanks

ravi k dake

Re: Auto-Save Function with Filename(ID)

qnguyen — Tue, 02 Dec 2008 08:16:27 GMT

I got it.

Thanks

Re: Auto-Save Function with Filename(ID)

Anuma — Tue, 02 Dec 2008 08:11:00 GMT

Hi,

If you are asking about Browser form, then follow below steps:

Open your form in Design Mode.
Select Tools à Form Options.
Switch to “browser” tab.
Uncheck “Save”, “Save As”, “Close” and “Print View” check boxes.
Click on ok.

If you are asking normal InfoPath form, then follow the below steps:

Open your form in Design Mode.
Select Tools à Form Options.
Switch to “Open and Save” tab.
Uncheck “Save”, “Save As” and “Print” check boxes.
Click on ok.

Re: Auto-Save Function with Filename(ID)

Yathees — Tue, 02 Dec 2008 07:59:16 GMT

Hi,

You can drop the buttons in the infopaht menu "extras" -> "formular options" or somethin like formular options i have a german version...

Re: Auto-Save Function with Filename(ID)

qnguyen — Tue, 02 Dec 2008 07:41:47 GMT

Hi,

How can we disable buttons of InfoPath Form Services (Save, Save As..., Close, Print View) if we do auto-save.

Thanks

Re: Auto-Save Function with Filename(ID)

Anuma — Sat, 29 Nov 2008 06:58:34 GMT

HI,

If you want to display any one of the field information in the file name, then enter that field name xpath in the file name. Other wise you can use text like your "Form name" or "Name".

concat(Name, "", now())

Re: Auto-Save Function with Filename(ID)

Dave Schafer — Tue, 25 Nov 2008 19:30:27 GMT

Hello,

I am attempting to "auto-save" in the same manner. After adding the button and changing the action to submit I'm clicking on the FX button to insert the field "NAME" which doesn't exist in any of my data sources. Do I need to add another data source to get the "Name" field?

When I look at the actual form library I am working in, the name field is inhereted from site content type: "Document"

Thanks in advance for any assist.

Dave

Re: Auto-Save Function with Filename(ID)

Yathees — Fri, 07 Nov 2008 12:49:52 GMT

thanxs Guys, it worked quit good ;-)

Re: Auto-Save Function with Filename(ID)

Anuma — Fri, 07 Nov 2008 12:11:54 GMT

Hi,

use concat function in the filename field. This will not submit the duplicate file names in the form. We can create duplicate forms with using only “Name” field in the file name. Use below function in the FormName field.

concat(Name, "", now())

Nameà Xpath for which field you want to display in the file name.

Re: Auto-Save Function with Filename(ID)

Hari Krishna — Fri, 07 Nov 2008 11:58:00 GMT

Hi,

To Set the variable follow the steps given below:

1. Click on fx button.

2. In 'Insert Formula' window click on 'Insert Field or Group' button.

3. Select 'Name' field and click ok.

4. Until all the windows close.

Re: Auto-Save Function with Filename(ID)

Yathees — Fri, 07 Nov 2008 11:44:26 GMT

Hi Paresh thanxs for your quick reply!

How does this rule have to look like? I don't know the variable vor filename...

Re: Auto-Save Function with Filename(ID)

paresh — Fri, 07 Nov 2008 10:50:54 GMT

You can insert your own button for this, have a "Submit" data connection to the form library, and add a rule to the button to execute this submit dataconnection.

Hope this helps. Do let me know if you need further information.

Thanks,

Paresh

http://www.openzeas.com/blogs/Paresh

Auto-Save Function with Filename(ID)

Yathees — Fri, 07 Nov 2008 10:07:21 GMT

Hi Guys,

Auto-Save Function with Filename(ID)

My Question/Problem ;-) :

Currently we are designing an Infopath browser enabled Form. And this one should when someone click on the "Save" button automatically save the form with the form ID as the document name. I have read this post http://www.infopathdev.com/forums/p/7051/25726.aspx#25726, but that doesn't help me much...

Can someone help me out?