InfoPath Dev

I am designing a form where I want the date and time to be recorded when the user submits the form.  However, I want those controls to be in a hidden optional section that only the Admin can access.  So I have hidden the controls, but when the end user submits the form the time and Date are not recorded until the Admin opens it, sometimes days later.  Is there a way to make the Date and Time record at the submit time?

You would need to add a rule to your submit that has an action to set the value of those fields.  This will then trigger when submitted and populate the field values with now() or today()

Thanks for the suggestion, but do I need to put the now() and today() formula in both the set field value Rule location and the actual fields themselves?

Hello

If you want the Date and Time use now( ) and if only date use Today( ) in the Rule location

Hi

Good news, you need only set it in the rule and not the default value, one other tip you can un-tick the "Update this value when the result of the formula is recalculated " that should achieve the same result, but to be absolutely sure use the rule that is linked to the button on submit that sets

Hidden Datefield = Today().  That way it is only when the button is pressed the date is set and not otherwise.

Cheers Adam

Thanks!  All of your advice was helpful.  However, your tips didn't work until I rebound my datafields for Date and Time out of the optional section and into the "myfields" main section.  Thanks for all of the help!  

Sorry, but I just hit another road block...  I enabled my form so that it is browser capable, and now I can only successfully submit about 50% of the time.  I will pull up the page and try and submit but recieve an error, then close it and try again and it will work correctly.  I think that it has something to do with the Postback Settings (ie always, only when needed, never) on the Browser Form Tab.  I have messed with it with no luck.  Any ideas? 

Hi

How are you submitting, via a web service?  That determines whether the submit is succesful or not, it sounds like the web service doesn't recognise a new record until a fail occurs, almost like it is holding on to the old data until it finds out it is wrong and then ditches it.

Best off posting this question in the browser capable forum, they will be able to help you out further

Cheers

Adam