Can you keep database of entered fields?

  • Profile Image
    Russ Henderson 
    Asked on November 19, 2021 at 01:22 PM

    Does Jotform record each form and the associated fields in a table that we can download as a single document?

    If so, how long is the field data within that table maintained over time?

    Can an admin individually edit/delete records or empty that table as needed?

    Are attachments such as photos kept as part of this table?

  • Profile Image
    Mike_G
    Answered on November 19, 2021 at 02:51 PM

    You can view form submissions on the Jotform Tables.

    Form submissions (uploaded files included) are kept in our server and can be accessed through the Jotform Tables via your account as long as you do not delete them. Please note that permanently deleted submissions are irrecoverable.

    However, you also need to consider that accounts on a free subscription only have a total of 500 submission storage space. And, if you are also planning to collect files from your respondents, every account has an upload storage limit based on its plan subscription — accounts on a free subscription have a total of 100 MB of upload storage space.

    You can delete your form submissions to free your account's storage space. But again, since form submissions are not recoverable once purged, you can always download your form submissions and the uploaded files first before deleting them.

    You may find the following guides helpful:

    https://www.jotform.com/help/269-how-to-view-form-submissions/

    https://www.jotform.com/help/356-how-to-download-the-submission-files/

    https://www.jotform.com/help/73-how-to-download-form-submissions-as-excel-csv-pdf/

    https://www.jotform.com/help/377-how-to-delete-form-submission-data/

    https://www.jotform.com/help/408-understanding-your-account-usage-and-limits/

    Feel free to let us know if you need any further assistance.

  • Profile Image
    roseann0716
    Answered on November 19, 2021 at 03:06 PM

    Hi Russ,

    Under "All Forms" on your Jotform account homepage, you will see all the forms you've created. Right below a specific form, you will see how many submissions are there. It's also a clickable hyperlink that leads you to Jotform Table that serves as your database for all the submissions. 1637352051_6198027347caa_You can download the entire table as an Excel file. You can also download all attached images/files by using the "Download Attachments" option.

    1637352098_619802a26ba4a_

    About your last question, if an admin can individually edit/delete records or empty a table, the answer is yes. You can also watch this video to learn more about the Jotform Table.


    I hope I was able to help.

    Thanks,

    Rose