Infopath Timestamp

[thefonz37]

I'm trying to collect data from 100+ employees via an Infopath form and store
it in an Access database. I'm having a little trouble figuring out how to
get the Infopath form return certain pieces of information, thought. First,
I would like the form to include the return e-mail address of the sender so
that there's no confusion over who sent what. Second, I would also like the
form to return a timestamp, so I know when the form was completed.

Is this possible?

Thanks in advance.

 

[Anuma(GGK Tech)]

Hi,

Add one field in the schema called as “Dateâ€. Add following rule to submit
button.

1. In Rules window Click on add button.
2. Click on add action.
3. Select “Date†in Field text box.
4. Enter “now()†in Fx text box.
5. Click on ok.
And also shred this date field data to access db.
I hope this will help you.

 

[Paresh]

I'm trying to collect data from 100+ employees via an Infopath form and store
it in an Access database. I'm having a little trouble figuring out how to
get the Infopath form return certain pieces of information, thought. First,
I would like the form to include the return e-mail address of the sender so
that there's no confusion over who sent what. Second, I would also like the
form to return a timestamp, so I know when the form was completed.

Is this possible?

Thanks in advance.

Hi,

If you are using InfoPath 2007, you can take a look at the following
links for getting user details:
http://blogs.msdn.com/timpash/archive/2006/08/22/712663.aspx
http://blogs.msdn.com/infopath/arch...e-user-profile-through-moss-web-services.aspx

Do let me know if you need further information.


Thanks,
Paresh

 

[thefonz37]

Great, guys, I figured it out. Thanks so much for your assistance.

 

[thefonz37]

Ok, one more quick question. Because security is important with this type of
data, it's important that the employees do not have access to the database
where this information is ultimately stored. So, it appears I can route
these forms through my e-mail, but then, for some reason, I can't export the
e-mails to my database from here. I can export to Excel and then import to
Access, but that seems like too many steps.

Any suggestions?