I have an infopath form that is published to a SharePoint library. After the form is filled out, the user clicks a custom "Submit" button which has a rule with the following actions: 1) submit to main connection (database table), 2) submit to connection
(SharePoint library - which starts an approval workflow in SharePoint), 3) thank-you message, and 4) close form without prompt.
99% of the time, all works well with form data getting submitted to database table, and also to the SharePoint library (which triggers the approval workflow). 1% of the time, when my custom submit button gets clicked, only the first rule action performs
(i.e., data is submitted to main database connection), but the process stops at the action to submit to the SharePoint list.
I have checked and triple-checked the actions in the submit button rule, and they appear to be correct - and, in fact, behave correctly 99% of the time. It's that 1% when the rule breaks at the point of submitting to SharePoint library that has me
crazy. This occurs only sporadically with different users -- users who it works correctly for most of the time.
I also have a form field I created called "DupChecker" that looks in the database table to see if the exact record exists, and if it does, it will not allow the user to submit it again. So when the use
View Complete Post