Preview form submits correct values into listing, Published form does not... - InfoPath Dev
in

InfoPath Dev

Preview form submits correct values into listing, Published form does not...

Last post 04-12-2017 08:16 AM by wsimpkins. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 04-12-2017 07:25 AM

    Preview form submits correct values into listing, Published form does not...

    SEE ATTACHED SCREENSHOT I have been doing this for years and this is the oddest issue I have ever had with Infopath (using 2013 for this) I have a SharePoint list that I am customizing (the edit form) with Infopath. It is for call time tracking. The user can hit START button and a rule shoots Now() into the text field START then later, at the end of the call, they PRESS STOP button and it shoots the value for Now() into the text field STOP. The a third text field (DURATION) default value calculates the difference between START and STOP rounding to the closest minute. When previewed, the form works perfect and SUBMITS the correct data into the listing. After I publish the form and then run it from the SharePoint list webpage, the values for STOP and DURATION are wrong. The form magically duplicates the START value into the STOP field. So the calculated minutes are always “0” and the STOP time always matches the START time… All three fields are TEXTTYPE. The DURATION field Formula shown in pic. I have recreated the list as brand new and recreated every field with the same result. Used a different PC as well... I am going crazy. One other clue: When I run it in the browser and click START then STOP and then MANUALLY increase the STOP value by changing a 1 to a 2 etc, then the values are correct after it is submitted. It is as though the rule isnt putting the now() into the STOP field but it does put the right date and time in there. If it wasnt populating the field it should be BLANK after I submit it, it wouldn't just grab the START value arbitrarily.
  • 04-12-2017 07:42 AM In reply to

    Re: Preview form submits correct values into listing, Published form does not...

     Thanks for emailing your template to me - first, I'd try setting postback to "always" on the Start & Stop buttons (see attached screenshots) - I've noticed that seems to address many browser form anomalies. I'm curious about the rule on your submit button that sets Stop to itself? Can you tell me about that?


    Hilary Stoupa

  • 04-12-2017 08:11 AM In reply to

    Re: Preview form submits correct values into listing, Published form does not...

    haha! whoops. I forgot to take that out before I sent it. I added that a few minutes before I made the post. That is me simply 'grasping at straws'. Sometimes just trying odd things like that will give you another clue that will lead to discovery. I will try the button settings ASAP.
  • 04-12-2017 08:16 AM In reply to

    Re: Preview form submits correct values into listing, Published form does not...

    You amaze me! The "ALWAYS" fixed the problem. Thanks for saving me again!
Page 1 of 1 (4 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.