Google sheets integration: Submissions data is not showing completely

  • Profile Image
    sasatepic
    Asked on March 13, 2018 at 07:24 AM

    Hi, 


    I've setup google sheet s integration, first 501 ubmissions are displaying correctly, other 400 (od ~900 total) are not, they are only displaying time, IP and edit link.

    I've attached screenshot of the situation.

    I've tried removing integration and readded, but with no luck, even changed the folder, but with no luck.

    Please help us, because this is VERY important to us.

  • Profile Image
    BJoanna
    Answered on March 13, 2018 at 10:43 AM

    I have manually pushed the data of your form to the Spreadsheet. Please check if all data is now shown. I also downloaded your data from the submission page as an Excel and all data is shown inside of the Sheet. 

    How to Export Form Data to Excel

    I also noticed that you are storing your data on our EU servers. Please note that you have to log in to your account using eu subdomain - https://eu.jotform.com/ 

    If the data is still missing from the Spreadsheet please try to re-integrate the form again with Google Spreadsheet. 

    How to Integrate Form with Google Spreadsheet

    If that also does not resolve the issue, provide us a link of your Spreadsheet file with view access. 

  • Profile Image
    sasatepic
    Answered on March 13, 2018 at 12:43 PM
    Hi,
    It's not working.
    Here is link for form you manually pushed data to: https://docs.google.com/spreadsheets/d/10Txrc3bghJJfzbnAMv2_x5GBGtUf5hMRz8zDbNPyib8/edit?usp=sharing
    Here is link for form I've reintegrated: https://docs.google.com/spreadsheets/d/1QokFskZ8XPiEPWUYs-t8ky4hacW8ea68Wfd5GiZwuFs/edit?usp=sharing
    I'm using EU domain.
    Best regards,
    Sasa
    ...
  • Profile Image
    Nik_C
    Answered on March 13, 2018 at 02:38 PM

    I checked your submissions and I saw what you had in mind.

    Did you recently change the data storage location (from the US to EU for example or vice versa)?

    We will wait for your response so we can check further.

    Thank you!

  • Profile Image
    sasatepic
    Answered on March 13, 2018 at 02:43 PM
    Hi, no I didn't change location.
    ...
  • Profile Image
    Nik_C
    Answered on March 13, 2018 at 03:28 PM

    Thank you for additional information. I will forward this issue to our backend team for further checking.

    We will inform you further via this thread.

    Thank you!

  • Profile Image
    sasatepic
    Answered on March 19, 2018 at 05:43 AM
    Hi,
    What is the status of this?
    Regards,
    Sasa
    ...
  • Profile Image
    Nik_C
    Answered on March 19, 2018 at 06:57 AM

    I'm afraid that we don't have any updates at this time.

    We'll inform you as soon as there is any new information.

    Thank you!

  • Profile Image
    sasatepic
    Answered on March 19, 2018 at 04:43 PM
    Ok,
    This was a vital part of our experience with JotForm, we have over 1000 submissions for STEM Games competition with over 15 different faculties participating and thus we had to develop custom google sheets script to filter and distribute the dana in realtime (as submissions appear).
    So that google sheets integration was vital to us, now we have to do it mannualy – by exporting excel table and imporitng it into google sheets, which is not automatic at all.
    We think it would be ok if we could have some discount or refund in this case.
    Regards,
    Sasa.
    ...
  • Profile Image
    Kevin_G
    Answered on March 19, 2018 at 06:23 PM

    We think it would be ok if we could have some discount or refund in this case.

    I will ask to see what we can do about this, we will keep you updated via this thread. 

    Thanks.

  • Profile Image
    Denis
    Answered on March 23, 2018 at 08:12 AM

    Hello,

    We are sorry for the inconvenience caused. The problem is fixed. Please re-integrate your form with Google Spreadsheets again and let us know if the issue still persists on your side. If you need any further assistance please feel free to contact us anytime. 

    Regards.