Signups not transferring to Google spreadsheet

  • Profile Image
    stnuttall
    Asked on February 12, 2018 at 04:32 PM

    The first 5 - 6 registrations transferred seamlessly over to the Google Drive form but now they have stopped. I have checked the integrations and all seems to be fine and I have reinstalled the Jotform and re-published - but new signups still are not going over.

    Any suggestions for what I need to do would be appreciated! Having to manually enter all these responses will be a real pain!

    Thanks in advance.

    Sharon Nuttall

  • Profile Image
    Welvin
    Answered on February 12, 2018 at 06:10 PM

    I think you mean Google Spreadsheet since that is the only integration present in the form unless you have removed Google Drive which is a different integration.

    I've manually synced the missing submissions. Please check. Please note that this isn't a final fix. If the integration is still not working, I would suggest removing it again then re-integrate.

    Also, note that doing any changes in the spreadsheet file is not recommended especially the first row where the field labels are placed. If you want to edit or do something with the submissions, do it into a new spreadsheet and use ImportRange function to fetch the data. 

  • Profile Image
    stnuttall
    Answered on February 12, 2018 at 07:56 PM

    Thank you, Welvin. You are right; I meant Google Spreadsheet. Thanks for manually syncing the submissions; they look fine. 

    One thing I just did was remove the Capcha widget I had installed and the Spreadsheet synced perfectly. Unfortunately, because I did that after you had worked on my account, I'm not sure whether it was something you did or my removing the capcha that corrected the syncing! (My mistake!)

    I may reinstall the capcha just to see if that prevents the syncing and then at least I'll know for sure.

    Thank you for being so helpful. 

    Sharon

  • Profile Image
    stnuttall
    Answered on February 12, 2018 at 08:13 PM

    Just FYI, I went in and reinstalled the Google Captcha and, sure enough, the entries did not sync with the Google Spreadsheet. As soon as I removed the Captcha, it started syncing again.

    I've only used the 2 Google Captchas so I don't know if this is a problem with all of them, but I think I won't install any Captchas for now.

    We had one entry early on that looked very much like spam but I'd rather deal with a couple of "iffy" entries than not have the entries syncing properly.

  • Profile Image
    Nik_C
    Answered on February 13, 2018 at 02:22 AM

    Thank you for additional information. Could you please tell us which Captcha did you use?

    Is it the regular one:

    1518506463Screen Shot 2018-02-13 at 8.20

    Regular one with reCaptcha:

    1518506520Screen Shot 2018-02-13 at 8.21

    Or did you use one of the widgets?

    I tested with regular Captcha, but I wasn't able to replicate this issue.

    We'll wait for your response.

    Thank you!

  • Profile Image
    stnuttall
    Answered on February 13, 2018 at 04:23 PM

    I didn't even notice the Captcha available in the Basic options. I used both the Google reCAPTCHA and the Google Invisible reCAPTCHA under the widgets. Both seemed to prevent the information from syncing with the spreadsheet.

    I've now included the CAPTCHA that's under Basic and it seems to be working fine. I haven't turned on the reCAPTCHA as it seems to me to make it extra-difficult - and I hate CAPTCHAs that are particularly hard to figure out!

    Is there some compelling reason I should turn the reCAPTCHA on?

    Thanks for all your help! I'm most impressed with your customer service.

    Sharon

  • Profile Image
    Welvin
    Answered on February 13, 2018 at 04:47 PM

    The Google reCaptcha is working to my end. Anyways, if the basic works for you, then I suggest keeping it that way. We cannot create a ticket unless we can replicate the problem. I tried twice on different forms, cannot replicate it.

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

    Form (cloned from yours): https://form.jotform.com/80436037964966.

    You can keep the basic one, and not the recaptcha. They worked the same on preventing spams, plus we already have an anti-spam (bots) measure in place. The recaptcha is basically to make it harder for spammers to guest the codes.