Need to delete duplicate entries from database

  • HRdept
    Asked on November 11, 2021 at 5:37 AM

    Hi,

    We need to delete duplicate entries from database.

    Please help us out in this query as soon as possible.

  • Cecile JotForm Support
    Replied on November 11, 2021 at 6:50 AM

    Hello there,

    Thank you for contacting support.

    You can utilize the search function in Jotform tables to find duplicate submissions.

    Guide: How-to-Search-a-Submission-from-the-Submissions-Page

    Then, you may proceed with the deletion of the duplicates.

    Guide: How-to-Delete-Form-Submission-Data

    Duplicate submissions usually happen when the thank you page is reloaded. This occurs if the browser is not closed properly. Thus, when the user reopened their browser, there is a tendency that the Thank you page will be reloaded. 

    To avoid duplicates in the future, you may take advantage of our unique question and unique submission features.

    Guides:

    How-to-set-Form-Limits-Based-on-a-Unique-Question

    How-to-Set-Unique-Submissions-on-a-Form

    You can also add a captcha field in your form, so even if the thank you page is reloaded, it will at least prevent the form from re-submitting until the captcha is filled. 

    Guide: How-to-Add-a-Captcha-Field

    Let us know if you have any other concerns.