Encrypted form does not send data to Google Spreadsheet.

  • dragonrojo1
    Asked on September 6, 2016 at 6:39 PM

    I made an encyptred form and i want to send the information to a spreadsheet in google, the mail arrives good to my acount but in the sheet of google does not change, i tryed changeing the acount but it does not work too

    Jotform Thread 925586 Screenshot
  • Kevin Support Team Lead
    Replied on September 6, 2016 at 10:21 PM

    I have tested the Google Spreadsheet integration with an encrypted form and I can see it works, but do note that when the data is sent to the spreadsheet and the form is encrypted, the data will be displayed like this: 

     Encrypted form does not send data to Google  Spreadsheet Screenshot 20

    Could you please try removing the integration and adding it once again? 

    If you're still not getting the data sent to your spreadsheet, please provide us a screenshot of the web console, we will be glad to further test it on our end. 

    These keyboard will help you to get the web console: 

    Google Chrome.

    Mac: Command + Option + J

    Windows: Control + Shift + J 

    Firefox.

    Windows: Ctrl+Shift+K

    Mac: Command+Option+K

    Please  let us know how it goes. 

  • dragonrojo1
    Replied on September 6, 2016 at 11:07 PM

    I deleted the sheet on Drive, eliminate the integration in my two forms (one encrypted and other normal), After I reintegrate the spreadsheet in bouht forms, I paste the code in my Muse proyect now they work even the encrypted one recover all data from the last test when they dont work. maybe it takes a time to refresh teh sheet. 

     

    Thank you

  • Elton Support Team Lead
    Replied on September 7, 2016 at 1:21 AM

    Hi,

    Great! It's good to know that it is working now.

    I also cloned your form here, integrated it with Google Spreadsheet and it is working for me too.

    Here's my cloned form: https://form.jotform.com/62501121008942

    Spreadsheet: https://docs.google.com/spreadsheets/d/1pCFikWX_wB3EkftL7BuxvRkZurZeBgdnWDblhMJIY3Y/edit?usp=sharing

    Feel free to submit a test if you want to.

    Here are my tests on the spreadsheet so far:

     Encrypted form does not send data to Google  Spreadsheet Screenshot 20

    If you come across this problem again, feel free to let us know.