You are viewing limited content. For full access, please sign in.

Discussion

Discussion

Monitoring the life cycle of a submission from draft to completion, to see who completed it

Forms
Updated November 3, 2020
posted on July 28, 2020

A user reported that his drafts are getting submitted without his knowledge. Since he does not have an Forms account, his drafts are in the public box. The links he has in his email have a submission ID in them which I can use to try to track the history and find out who is submitting his drafts.

However when I search for this submission ID in the cf_form_submissions table, it does not exist, which means it has entered a state in which it must have been moved to another table.

I was thinking that both drafts and submissions are stored in this table and I would find it even if it was submitted.

In order to find the history I need to find a way to find a submission's status from draft through completion. I don't believe deleting a draft is a function that is available so I can safely assume no one got a hold of it and deleted it.

0 0
replied on November 3, 2020

I can't see how this is true, after trying to use this to show clients who submitted their many many missing drafts.

If a POST /Forms/Form/Submit action is a submission of the draft, you would only ever see one event. Instead there are many events associated with this action for the same ID.

This must meant that a POST /Forms/Form/Submit is simply a save of the draft.

We are trying to find out where the drafts are being lost to, not when they are saved. The drafts simply disappear from the draft bin and no one can find an associated instance for it, so the data is lost forever.

I am opening a support case.

0 0
replied on July 29, 2020

The draft submission will be deleted after the draft is submitted, a new submission with Submit action will be created instead.

You can check the IIS logs to see from which machine the draft was submitted, the request is as following.

2020-07-29 10:31:50 10.16.32.172 POST /Forms/Form/Submit - 80 - 10.16.32.71 Mozilla/5.0+(Windows+NT+10.0;+Win64;+x64)+AppleWebKit/537.36+(KHTML,+like+Gecko)+Chrome/84.0.4147.89+Safari/537.36+Edg/84.0.522.44 http://xxx/Forms/form/resume/30829/97602 200 0 0 88

3 0
replied on July 30, 2020

Awesome, this worked. I used a grep program to search the text files for all instances and found the new submission ID based on when it was submitted (IIS uses UTC time). Also I could see that the workstation which submitted was the same used to access it and update drafts in all instances previously.

Thanks for the info!

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...