While reviewing a custom report for a fairly simple straight forward form, I noticed for one staff member, the form was submitted twice. And then she also needed to submit the form two more times with new data. The form is asking staff for any accreditations  or accomplishments they have. This person had 3, the expectation would be for only 3 Instance IDs to appear in the Monitor and the Report. The form also kicks off a File Re-namer work flow, which then kicks off a File Filer workflow.

At first, I thought the workflow was running twice, but then when I went to the monitor and the report, I do see each of the 3 submissions (only for this user) are all unique... a total of 6 instances (for 3 form submissions).

Here is a screenshot right from the report only revealing relevant information. I am trying to re-create the problem and have not been successful. This appears to be an isolated issue as well, this has not happened to any other user. She also confirmed she did not submit each form two times, only three forms one time each.

Next question to follow this is how can I tell a LF Form what fields to look at to see if there is already a matching entry? There are a few logical combinations of fields they are filling out that if I can tell the form to validate, then the end user would get an error "that form has already been submitted" type of response. I did research through the KB here, but am not really finding this is easily accomplished unless I tell the form to write to it's own form specific sql table and then I can build in my validation checks that way.

I also attached a screenshot of the process diagram to show what I mean by "simple form"