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

Question

Question

Where Are Saved Forms Kept in the Database?

asked on April 3, 2014

When a user selects the "Save unfinished for to complete later" checkbox, where is that data stored in the Forms database?

2 0

Answer

APPROVED ANSWER SELECTED ANSWER
replied on April 23, 2014

Draft submission is considered a submission to forms and uses some of the code paths of a real submission.  Like all data it can be found in the cf_bp_data table.  Look for the draft data by searching for all items with a certain submission_id.  You can determine the submission id from the email.  For example:

http://localhost/E-forms/Form/resume/14844/29053

 

means the submission id is 29053

SELECT * FROM [dbo].[cf_bp_data] where submission_id = 29053

 

1 0

Replies

replied on April 4, 2014

The data is stored as a draft submission in a few tables, why do you want to access the draft forms?

0 0
replied on April 14, 2014

Can you please tell me what tables those are? We are testing some processes and need to edit a few to get them to complete correctly.

0 0
APPROVED ANSWER SELECTED ANSWER
replied on April 23, 2014

Draft submission is considered a submission to forms and uses some of the code paths of a real submission.  Like all data it can be found in the cf_bp_data table.  Look for the draft data by searching for all items with a certain submission_id.  You can determine the submission id from the email.  For example:

http://localhost/E-forms/Form/resume/14844/29053

 

means the submission id is 29053

SELECT * FROM [dbo].[cf_bp_data] where submission_id = 29053

 

1 0
replied on June 30, 2023

Have the drafts changed tables or are they still in the mentioned table? Thanks

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

Sign in to reply to this post.