Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / General MS InfoPath Questions / July 2007

Tip: Looking for answers? Try searching our database.

Infopath forms in Sharepoint

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Lisa - 05 Jul 2007 13:48 GMT
Hi, I've been trawlling through reams of threads and I still don;t understand
how I can assign sequential numbers to my infopath forms that are stored in
my sharepoint library.  Help please as I'm at my wits end ;(
Kalyan G Reddy MVP (GGK Tech) - 05 Jul 2007 15:18 GMT
Hello

Please read the Link below
http://www.infopathdev.com/forums/thread/5507.aspx

Hope it helps you
Signature

Kalyan G Reddy - INFOPATH MVP 2007
http://www.ggktech.com

> Hi, I've been trawlling through reams of threads and I still don;t understand
> how I can assign sequential numbers to my infopath forms that are stored in
> my sharepoint library.  Help please as I'm at my wits end ;(
Lisa - 05 Jul 2007 15:40 GMT
Thanks for the link but unfortunately it means noth ing tome.

I'm not a programmer or very techy.  I have a sharepoint site that I am the
administrator for but i have no design rights.

I have created a form in Infopath and would like my team members to be able
to use it and though that Sharepoint was the best way to do this.  I need
each form to have it's own unique ID number so that we can track them.  I
have heard that you can use the id number in sharepoint but don;t know how to
link the form to sharepoint or the id number.

Lisa

> Hello
>
[quoted text clipped - 6 lines]
> > how I can assign sequential numbers to my infopath forms that are stored in
> > my sharepoint library.  Help please as I'm at my wits end ;(
Fred33 - 05 Jul 2007 16:22 GMT
K, I dont know if there is one integreated in SharePoint already but here how
I did it with some of my InfoPath form.

In your form, create 2 variable
One for the ID one for a Status because you dont want that everytime you
open the form the ID change, only when its a new opened form.

In your Sharepoint Form Library, create a Column (you can hide it after so
its not show in the default view) that will keep the ID, you can name it
whatever you want, "IDForm".

In you Infopath form, create a connection that will look at that column.

In your rule when form in opened, check if there is a field in "IDForm" that
look like /d/d/d/d (Just for demo, this mean that the ID have 4 numbers).
This will be used to know if you already have at least 1 document in you
documents library. If no and Status=0 (new form), you now put a value for the
first ID. Like 1000. And then you change status form 0(new form) to
1(openedform) (can be what you want).

Add a second rule, if /d/d/d/d exist and status=0 then the ID of your new
form will be ID= max(@IDForm)+1 and again you dont forget to change status to
1. (So your second form will have ID = (1000)+1 = 1001 and so on.

Now you need to submit the form and link the field ID of your Infopath form
to the IDForm of your column.

Dont forget Status, because otherwise everytime you will open the same form,
it will overwrite the ID.

Also check the stop rule in each of your 2 rules.

> Thanks for the link but unfortunately it means noth ing tome.
>
[quoted text clipped - 19 lines]
> > > how I can assign sequential numbers to my infopath forms that are stored in
> > > my sharepoint library.  Help please as I'm at my wits end ;(
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.