Can you keep database of entered fields?

  • Russ Henderson
    Asked on November 19, 2021 at 1: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?

  • Mike_G JotForm Support
    Replied on November 19, 2021 at 2: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.

  • roseann0716
    Replied on November 19, 2021 at 3: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  Screenshot 10You 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  Screenshot 21

    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