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 / April 2006

Tip: Looking for answers? Try searching our database.

Form timer

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
CG - 16 Apr 2006 20:04 GMT
Is there a way to put a time on when form is opened and have it track the
time until the Submit button or some other bench mark is reached and save
that somewhere?
Adam Harding - 18 Apr 2006 12:09 GMT
Hi

Yes

Set one data field to have its default vaule = Now() untick the this value
is recalculated and that is your start time and date.  On the submit button
have rule the sets the other data field to Now() and untick the same
recalculate box.

Thus you have a start and end time recorded.  Now to calculate time
differences is a tricky funtion and i have never bothered learning it.  
However, there are one or two complete descriptions of how to do it on this
forum that you should take a look at.

Cheers CG

hope this helps Adam

> Is there a way to put a time on when form is opened and have it track the
> time until the Submit button or some other bench mark is reached and save
> that somewhere?
S.Y.M. Wong-A-Ton - 19 Apr 2006 12:26 GMT
Adam's suggestion should work. I have just one addition: After you have the
two fields as indicated by Adam, you can use a formula as demonstrated in
this article
http://enterprise-solutions.swits.net/infopath/time-calculations-using-rules.htm
to calculate the difference in time. Since your users aren't expected to take
more than one day to fill out the form, it should be enough to cover your
scenario.

A second option is to use code in the OnLoad and OnSubmitRequest events of
the form to do the initialization of the timer and saving of the time elapsed.
---
S.Y.M. Wong-A-Ton

> Is there a way to put a time on when form is opened and have it track the
> time until the Submit button or some other bench mark is reached and save
> that somewhere?
 
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.