My submissions data are now blank

  • Profile Image
    shetani
    Asked on July 13, 2016 at 09:08 AM

    Hi,

    I just realized today that all submissions (490 of them) for one of my forms have been cleared. There are 490 submissions, but all data is empty. Can you please assist me with this as soon as possible, can I restore these submissions somehow?

    Has something happened on my end that caused this?

    Please assist!

    Form ID: 61625902789365

    Regards,

    Ines

    Screenshot
  • Profile Image
    EltonCris
    Answered on July 13, 2016 at 11:46 AM

    Thanks for reporting.

    I can see a huge list in your form submissions columns that are now blank.

    By the way, the following fields in your forms are read only. May we know how you come up with values on these fields? Is it from another form or through a custom URL parameters?

    I will also escalate this to our developers so they can further investigate. You will be informed here once this is resolved.

  • Profile Image
    shetani
    Answered on July 13, 2016 at 11:53 AM

    Hi Elton,

    Thank you for your follow up, assistance will be greatly appreciated as these were performance evaluations for our employees and we are approaching the deadline!

    Yes, the values that show up in those read-only fields are pre-filled with name of reviewer and status "pending" or "done".

    If status is "pending", then I use conditional statements to unhide a field ("personal code") which can then be filled out and the reviewer can proceed to next page.

    (Edited to add: forms were pre-filled by importing submissions via import.jotform.io. I had a large number of fields that needed to be pre-filled, and using URL was not a solution for me because URLs can be manipulated with to change the pre-filled value. So I imported pre-filled submissions, and sent form EDIT links to reviewers)

    Cheers,
    Ines

  • Profile Image
    Kevin_G
    Answered on July 13, 2016 at 01:18 PM

    Thank you for letting us know about how your form works. 

    I have checked your form and I can see the issue as well; however, I can see that my colleague has already opened a ticket for this, our developers will investigate the issue and we will let you know when this is resolved. 

     

  • Profile Image
    shetani
    Answered on July 13, 2016 at 01:48 PM

    Great, thank you so much!

    Cheers,
    Ines

  • Profile Image
    eee
    Answered on July 13, 2016 at 05:10 PM

    Hey Ines,

    We have fixed the problem,

    Please give it a try and let us know your result,

    Kindest Regards,

    - Ertugrul.

  • Profile Image
    shetani
    Answered on July 13, 2016 at 06:02 PM

    Hi Ertugrul,

    I see the submissions have now rolled in. Thank you so much for the tremendous help!

     

    I'm just mentioning the below FYI in case the info will be useful to the developers, it looks like conditionally-filled values may not have been restored correctly:

    I made a very complicated form with a 3-level workflow (forms are re-edited 3 times).

    For example, see screenshot below.

    1st Reviewer Status (column 3) is set to Pending by default (via conditions). When he submits his review, Status (column 3) is changed to Done, and is set to Pending for 2nd Reviewer (column 6).

    Now, the Status field (which is conditionally-filled) is a bit messed up because 1st Reviewer already submitted his review, but his status (column 3) is still showing as Pending.
    I haven't looked at all the submissions and all other fields yet.

     

    Please note that I'm only saying this FYI in case some other JotForm users might have a similar issue now with conditionally-filled fields. I have enough data to redo these conditionally-filled parts on my end and I will re-upload the submissions with correct data.

    You have saved me a lot of embarrassment and a lot of late working hours.

    Thank you so much!!

    Cheers,
    Ines

  • Profile Image
    shetani
    Answered on July 13, 2016 at 06:51 PM

    Hi again,

    Sorry - looks like I still have a problem.

    I have fixed the data of the submissions now and tried to import them via import.jotform.io, but they are again coming up as blank.

    I have used import.jotform.io for this particular form a bunch of times over the last few weeks and have never had a problem with it.

    Can you please check what is the issue now?

    Thanks and cheers,
    Ines

  • Profile Image
    Kevin_G
    Answered on July 13, 2016 at 09:23 PM

    @shetani,

    I can see your issue; however, this thread was originally opened to report empty submissions in your form and this seems to be related to the import app, this is why I have removed it to another thread, it can be found here: https://www.jotform.com/answers/882176 

    We will assist you there as soon as possible. 

    Thanks.