Jotform Tables: Submissions data is missing, but shows on the Inbox and PDF editor.

  • Profile Image
    Mobile_SWAT
    Asked on July 14, 2021 at 02:31 PM

    Dear whom it may concern,

    I am unable to view the submitted forms for one of the forms I Created. Could you help to check how I can extract the data? I need it ASAP.


    Thank you

    Best Regards,
    Teo Jun Xiang

  • Profile Image
    Yuta_J
    Answered on July 14, 2021 at 07:47 PM

    Hello,

    We are sorry for the inconvenience which may have caused. I replicated the issue on my end. Our backend team will be looking into this issue and get back to you once the issue has been resolved. For the time being, please kindly view the submissions in Inbox under the archive tab, or check the submission data in PDF Editor as a temporary workaround.

    Please let us know if you require further assistance.

  • Profile Image
    Mobile_SWAT
    Answered on July 15, 2021 at 05:57 AM

    Hi, could you give some screenshots for the workaround? Seems like I am unable to view them even in PDF format, there should be 20 tickets from June to July

  • Profile Image
    Rehan_F
    Answered on July 15, 2021 at 07:49 AM

    Greetings,

    Are you referring to the submissions in the Archives and Trash Folder? Here is how you can restore them from your inbox.

    1626349717_60f02095e3186_card.gif

    If these are not the submissions you are referring to then you'll have to wait until we get a response on the escalation from our backend team.

    Should you need further assistance then please let us know.

    Thanks

  • Profile Image
    Mobile_SWAT
    Answered on July 22, 2021 at 12:43 AM

    All these do not show the submissions dated AFTER JUN 2021. We need those dated after which we saw was submitted in email, but we cannot extract the informations and attachments.

    NEW DATA that is still MIA and only exists here:

    1626928968_60f8f7482a9ac_

    NEW DATA does not show up anywhere, all these are older than Jun 2021:

    https://www.jotform.com/pdf-editor/203078240350041

    1626928684_60f8f62c3fd2e_1626928684_60f8f62c4b173_1626928684_60f8f62c1a987_


    1626928684_60f8f62c0c4b7_1626928683_60f8f62b777db_

  • Profile Image
    Jed_C
    Answered on July 22, 2021 at 07:27 AM

    In your account history https://www.jotform.com/myaccount/history, it shows that you there were submissions deleted for this form https://www.jotform.com/form/203078240350041.

    Aren't those you've deleted last July are the submissions you've been looking for?

    1626953238_60f95616cf7d5_JotForm · My A

    If not, we'll have to wait for our dev team to check from backend data.

  • Profile Image
    Mobile_SWAT
    Answered on July 27, 2021 at 10:07 PM

    hi Jed, can I check how do I retrieve deleted forms then?


    we played around all these but don't see the forms deleted

    1627437999_6100bbaff3481_

  • Profile Image
    Jed_C
    Answered on July 27, 2021 at 11:21 PM

    Click on the checkbox beside the submissions and click on the restore button.

    1627442483_6100cd33f2ed9_restore.gif

  • Profile Image
    Mobile_SWAT
    Answered on July 29, 2021 at 12:25 AM

    Hi Jed, if it's in the actual interface of jotform we would have tried it - can you provide an actual solution by escalating this to the engineers?

    In the trash there was no submissions in the month of Jun 14-Jul 15 which are the ones that are missing. It is deleted on 12 Jul - yet it does not appear in trash. When restoring all there is none of the forms in question that is being re-stored, only those intentionally deleted.

    which gives 2 cases:

    1. there is an action by us which permanantly deleted the forms, even in trash
    2. there is an storage error by jotform in their cloud database

    Anw - i need the forms restored ASAP. Thanks


    1. After restoring all

    1627532513_61022ce13d029_

    2.Gap observed (3 days vs Apr 19)

    1627532603_61022d3b69449_

    3.Date filter

    1627532686_61022d8eaca80_

    4.Results of filter - required form not in sight1627532721_61022db165e56_ -


  • Profile Image
    Rehan_F
    Answered on July 29, 2021 at 02:07 AM

    Greetings,

    Kindly note that when the submissions are deleted from the trash folder they can not be restored. They are deleted from our servers as well.

    Deleting a submission from the inbox moves it to the trash folder. This temporary deletion is not recorded in the history section where you can see all the deleted submissions.

    However, when a submission is deleted from the trash folder as well then a record is created in the history section.

    The following screenshot share by my colleague above is showing all the submissions that were permanently deleted from the Trash Folder and unfortunately, these can not be restored.

    1627538811_6102457ba992b_

    Should you have any other questions then please let us know.

    Thanks

  • Profile Image
    Mobile_SWAT
    Answered on July 29, 2021 at 03:54 AM

    Noted, thanks