Form Submissions Database Cleanup

  • Resolved rmesupport

    (@rmesupport)


    1 year, 11 months ago

    Hi Support
    To set the scene ……..
    We use a Forminator form to collect user input data.
    Occasionally the users will start a form but the process will not complete – for various reasons. We accept this and make adjustments within our administration process to account for this, including the form count (used in the Behavior>>Lifespan calculation).
    Once our data collection is complete we delete all submissions using the bulk update function on the Forms Submissions page.
    Our question is ………
    How do we safely clean up the data base for the “failed to complete” submissions, that don’t present on the Form Submissions page.
    These “failed to complete” submissions are held in the form count, so we would like to have this count back to zero ready for our next data collection.
    These “failed to complete” submissions also present in the form Export file as follows eg.
    “Feb 16, 2023 @ 3:25 PM”,,,,,,,,,,,,
    “Feb 9, 2023 @ 8:59 PM”,,,,,,,,,,,,
    “Feb 5, 2023 @ 9:26 AM”,,,,,,,,,,,,
    We can find these submissions in “Table: wp_frmt_form_entry“
    But can’t see any matching records in the “Table: wp_frmt_form_entry_meta“
    Is it OK for us just to delete these “failed to complete” submissions from “Table: wp_frmt_form_entry“? And will this then set the form count to zero (used in the Behavior>>Lifespan calculation)? Or will this risk corrupting the database?
    Many thanks,
    RME

    • This topic was modified 1 year, 11 months ago by rmesupport.
Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Support Kris – WPMU DEV Support

    (@wpmudevsupport13)

    Hi @rmesupport

    I hope you are doing well today.

    I pinged our Forminator Team to review your query and get more details in this matter.We will post an update here as soon as more information is available.

    Kind Regards,
    Kris

    Plugin Support Kris – WPMU DEV Support

    (@wpmudevsupport13)

    Hi again @rmesupport

    You can easily delete it from wp_frmt_form_entry if you didn’t find any entries related to that entry_id in wp_frmt_form_entry_meta.
    Additionally, if you wish to delete all submissions and start from zero, you can apply delete a submission, which deletes all complete and failed submissions.

    Kind Regards,
    Kris

    Thread Starter rmesupport

    (@rmesupport)

    Hi Kris
    Thanks for the confirmation re data base edits.
    How do we “apply delete a submission”? – the failed submissions do not appear in the Submissions page.

    Plugin Support Nithin – WPMU DEV Support

    (@wpmudevsupport11)

    Hi @rmesupport,

    How do we “apply delete a submission”? – the failed submissions do not appear in the Submissions page.

    You can apply the option to delete submissions under Forminator > Forms > Bulk Action. You’l have to select the form where you want to delete the submissions and apply the “Delete Submissions” option via the Bulk Action dropdown and that should help in such cases.

    Screenshot at 11:23:36.png

    Please do check and see how that goes.

    Kind Regards,

    Nithin

    Thread Starter rmesupport

    (@rmesupport)

    Hi Nithin
    Thanks for your response.
    We have already deleted those records directly on the database.
    Next time we will try your suggestion.
    Many thanks, RME

    • This reply was modified 1 year, 11 months ago by rmesupport.
Viewing 5 replies - 1 through 5 (of 5 total)
  • The topic ‘Form Submissions Database Cleanup’ is closed to new replies.