Time Value Updated When Form is Submitted - InfoPath Dev
in

InfoPath Dev

Time Value Updated When Form is Submitted

Last post 05-27-2013 06:09 PM by roballen88. 2 replies.
Page 1 of 1 (3 items)
Sort Posts: Previous Next
  • 05-26-2013 06:30 PM

    Time Value Updated When Form is Submitted

    Hi,

    I have an InfoPath 2007 form, which is used as a checklist for users throughout the day. The logic is as follows

    User clicks a button control.

    Complete (Yes / No) field is updated to Yes. (this field is hidden) 

    Thisn update then also updates a Time Value in another field with the formula: substring-after(now(), "T")

    Meaning when a user clicks a button, it marks a task as complete and sets the current time. If the user clicks the button again, it clears all of this data.

    Problem is, when I actually submit the form; the time values are all updated with the submission time, not the time the button was clicked.

     Any ideas? Thanks...Rob

    Filed under: ,
  • 05-27-2013 05:26 AM In reply to

    Re: Time Value Updated When Form is Submitted

    Could you check the Rule/Logic Inspector? I would suspect there's another rule somewhere, on submit, that is overwriting the previously set value of the time the other button was clicked.

    Another issue might be that the Complete and Time are within a repeating table. If the button to label a task as complete lies outside of the repeating table, then clicking Complete is probably setting the value of ALL the rows, not just one.

    If neither of these two address the issue, feel free to attach the form template (via the Options tab) and I can take a quick look.

    Thanks.

    Ernesto Machado
    Qdabra® Software/ InfoPathDev.com
    The InfoPath Experts – Streamline data gathering to turn process into knowledge.™


  • 05-27-2013 06:09 PM In reply to

    Re: Time Value Updated When Form is Submitted

    Hi Ernesto,

    Thanks for your help. Not sure why, but when I set the Postback Settings to Always for each of the Time fields, it seemed to work correctly....very strange.

    Users are happy now, so I won't try and engineer a more logical approach unless it breaks!

     Thanks

Page 1 of 1 (3 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.