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 / February 2007

Tip: Looking for answers? Try searching our database.

Fill out new SP forms based on data in prior forms?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
George - 22 Feb 2007 14:37 GMT
I have a form built in IP and uploaded to a SharePoint Form Library.  

How can I set things up so that users of this form (those who have to fill
it out) can fill out new forms based on the data in previously-filled out
forms.  

For example, I use a repeating table for certain historical information.  
Having to repeat filling out this table eack week is unacceptable.  I'd like
to start filling out the new form using the data from the previous form.  Is
this possible/easy to enable?
S.Y.M. Wong-A-Ton - 28 Feb 2007 05:19 GMT
I don't think it is easy to enable, but it is certainly possible. Here's an
idea: If InfoPath has to get data from the previous form every time a new
form is created, you can create a table in SQL Server for example to store
the data (that you need to load when a new form is created) whenever a form
is saved to the Forms Library. So when you save a form to SharePoint, you
also save the historical data to SQL Server. And every time a new form is
saved, you just overwrite the historical data in SQL Server, since you only
need to retain the last saved data. Once you've got this working, you can
write code in the OnLoad event handler of the form to retrieve this data
whenever a new form is created and load it into the form using either code or
an XSLT.
---
S.Y.M. Wong-A-Ton

> I have a form built in IP and uploaded to a SharePoint Form Library.  
>
[quoted text clipped - 6 lines]
> to start filling out the new form using the data from the previous form.  Is
> this possible/easy to enable?
 
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.