What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    Google Spreadsheet integration had stopped working, a way to fix it without re-integration

    Asked by Thinkbright on April 09, 2015 at 02:07 PM

    Hello Jotform team,

    I need your support. My form http://www.jotform.co/form/43566107084859 was integrated with my google spreadsheet: 

    https://docs.google.com/a/thinkbright.co/spreadsheets/d/1zUW1DJvGoMM-iO_1_8wCFnD4FRMZFPfZKF_ZHw-Q5Pg/edit#gid=1882536991

     

    The integration was somehow lost.

     

    Could you help me re-do it. Please note that I can't integrate with a new spreadsheet since a lot of other automated processes depend on the form being linked to that specific sheet.

     

    Thanks a lot,

     

    Pablo Castellanos

    Page URL:
    http://www.jotform.co/form/43566107084859

    JotForm style automated integrate
  • Profile Image
    JotForm Support

    Answered by Welvin on April 09, 2015 at 04:28 PM

    Hi Pablo,

    Our apologies for the issue. We have some issues about the Google Spreadsheet a while ago, but our developer have just made an update and this update should resolve the problem. I'm sorry, but you need to re-integrate the form to Google Spreadsheet in order to refresh the connection.

    In general, we do not recommend doing any modification to the sheet because that would cause some serious issue in the integration. Modification such as changing the headers (first row) as well as adding columns and custom functions.

    If you want to re-use the current sheet, you can do the integration through Zapier:

    https://zapier.com/zapbook/jotform/google-sheets/

    In Zapier, you will have the option to use an existing sheet rather than creating a new one. 

    Thanks

  • Profile Image

    Answered by Thinkbright on April 09, 2015 at 04:34 PM

    Welvin,

    I'm sorry but this is totally unacceptable. The amount of work that my team would need to do to to reintegrate our >20 forms is a lot. This is a reason enough to shift to another forms service provider.

    Regarding Zapier, the costs for doing what Jotforms has not been able to get right is 50USD/month. Would you cover these fees?

    I'm really unhappy with this answer. And I would like to ask again if you can re-integrate my existing forms.

     

    Thanks,

     

    Pablo

  • Profile Image
    JotForm Support

    Answered by Welvin on April 09, 2015 at 05:50 PM

    Hi Pablo,

    I'm sorry, but I though that you have the issue in the single form only. I just checked your account and you only have 17 forms so I'm wondering if you have another account with us. Please let us know the form URL's so we can check it and let our developers know about it.

    As for using Zapier, I'm sorry but it looks like they have changed their pricing sets. I have 1500 tasks per month in Zapier.

    With regards to re-integrating the form to Google Spreadsheet without losing the current sheet, will forward that to our developer to see if there's a way to do that. But let us know first the other forms that have the same issue so we can add it to the report.

    Thanks

  • Profile Image
    JotForm Support

    Answered by alp_deniz on April 10, 2015 at 02:58 AM

    Hello,

    This issue is prioritized. I will update here very soon.

    Best