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 does not sync properly

    Asked by windirect on April 08, 2015 at 11:51 AM
    have the same problem. I can not change the sheet every day. Yesterday everything was moved!!

    Today the sync does not work!

    Please hel

    Google integration Google Spreadsheet
  • Profile Image

    Answered by Ben on April 08, 2015 at 11:54 AM

    I apologize for the inconvenience. Since I am able to recreate the issue, I am raising it to our developers for inspection.

    As soon as there are any updates in regards to this, we will update you through this thread.

  • Profile Image

    Answered by windirect on April 08, 2015 at 02:26 PM

    Hi,

    the last entries are not complete.

    is missing:

    Nome, Cognome, Via, Luogo, Cap, Paese;

     

  • Profile Image

    Answered by Ben on April 08, 2015 at 04:14 PM

    Thank you for adding additional details.

    I have already raised this to our developers so as soon as there are any updates, they will update you here.

  • Profile Image

    Answered by windirect on April 09, 2015 at 05:46 AM

    Hi, 

    the spreadsheet does not synchronize today.

    what can i do?

    THX

     

     

  • Profile Image

    Answered by Ben on April 09, 2015 at 10:30 AM

    Unfortunately we will need to wait for the time when the developer posts the update on the forum that the integration is again possible. Until that time, you will not be able to create the spreadsheet.

    The only temporary alternative if you must have the data in the spreadsheet would be to use Zapier.

    This is the Zap that might be able to assist you: https://zapier.com/zapbook/jotform/google-sheets/

    You can see more about how to create the integration over the zap here: JotForm is now on Zapier: Send Your Form Data to 100+ Web Services

  • Profile Image

    Answered by Ben on April 09, 2015 at 12:42 PM

    Our developers have notified us that the Google integration issue has just been resolved.

    Please try to connect to it by:

    1. removing the current integration
    2. creating a new Google Spreadsheet integration

    Do let us know if you have any further issues after following these steps.

  • Profile Image

    Answered by PghArtsCouncil on April 09, 2015 at 12:51 PM

    Is there any way to fix the integration with the existing spreadsheet?  I have heavily customized formatting in the Google sheet and I would very much like to avoid having to recreate all of it.
  • Profile Image

    Answered by Ben on April 09, 2015 at 01:57 PM

    We always urge you to open a new thread for your issue so that we can best assist you. Now since this thread is opened by windirect, I have moved your thread to here: http://www.jotform.com/answers/549512

    Our developer will be answering it for you shortly.

    That way we will be able to assist you and assist the thread owner windirect.

    Thank you.

  • Profile Image

    Answered by windirect on April 09, 2015 at 03:15 PM

    Hi,

    I have created a new sheet. Now missing the entry in the first column :-((

  • Profile Image

    Answered by windirect on April 09, 2015 at 03:23 PM

    I work with scripts and copy the data to my company database. When changing the columns I need to change the skripte every time. :-((

    Please tell the developers: Please.... No longer move the column !!

    THX

  • Profile Image

    Answered by Ben on April 09, 2015 at 04:57 PM

    This is not directly related to Google Spreadsheet, but since you say that you are copying the data to database, I would recommend checking out our webhooks integration. It will allow you to pass the data to your scripts directly, so that you can take care of it in the manner of your choice.

    This should work with Google scripts. I know that you could capture POST, so this should be possible, but also possible over the php scripts.

    Now in regards to the spreadsheet columns.

    I believe that you would be able to move them around and to have the integration still upgrade the data properly.

    Please do note that you should not make any changes to the spreadsheet however such as adding scripts to it since that could break the integration as well at some point. I would always suggest using ImportRange option and import data from this spreadsheet to another one with the script.

    Doing it this way, will mean that even if you create new integration, all you would need to do is to change the import range function to point it to a new spreadsheet.

  • Profile Image

    Answered by Ben on April 09, 2015 at 04:59 PM

    Just to add, you can see more about webhooks here: How to Setup Webhook with JotForm

    Also, if once you move the columns, the integration is not updating the cells properly do let us know and we will raise this to our developers.

  • Profile Image

    Answered by windirect on April 10, 2015 at 02:02 AM

    My endpoint is another spreadsheet. Even with import range I had the same problem. If a value in another column migrates everything has to be changed.

    if I get a new entry of Jot in the spreadsheet, then I copy with scripts in the endpoint sheet and delete the entry to avoid duplicate. At the moment I do not have the value in the first column.

     

     

  • Profile Image
    JotForm Support

    Answered by Welvin on April 10, 2015 at 09:26 AM

    Hi,

    You probably had something in your script that automatically deletes the content in the first column. Can you check? You have few submissions in the "Tipo richiesta" field and it's impossible that the spreadsheet integration wouldn't include these data.

    If you don't mind, can you share the script here so we can try it too? Just to help you debug and confirm the case.

    I have cloned the form and made a few submissions and they all appear in the sheet so I suspect something in your script that creates the issue.

    Clone form: http://www.jotformpro.com/form/50993717109967 

    Spreadsheet link: https://docs.google.com/a/jotform.com/spreadsheets/d/1qWU_TfdUTTAq9jkm7c5HCZnWnaUD14j35f-c4Pk7sIA/edit#gid=611028096

    Thanks

  • Profile Image

    Answered by windirect on April 10, 2015 at 09:43 AM

    I'm sorry my bug !!!

    Before that, I always deleted column A.

    I hope that will not happen and the columns do not move more;-)

    Thanks

  • Profile Image
    JotForm Support

    Answered by Welvin on April 10, 2015 at 10:46 AM

    No worries. I would suggest changing the way how you process the data and make sure that all columns in the original sheet will remain intact.

    Please contact us again if there are any problems.

    Have a great day!

  • Profile Image

    Answered by windirect on April 13, 2015 at 05:16 AM

    Hi,

    I'm looking for some time for a solution to embed the form in wordpress. 

    Today user call me because they have problems with the I pad. 

    Various applications such as for example mobile menu and toggles on the left are blocked.

    I think the reason for this is the embed code.

    Currently works Chrome, Firefox and IE.

    Before I had always problems with scrolling on IE.

    Please have a look

    my wodpress Site http://it.win-direct.com/preventivo-infissi/

    <iframe id="JotFormIFrame" frameborder="0" scrolling="yes" style="width: 100%; height: 2720px; border: medium none;" src="//form.jotformeu.com/form/50076119320344?nojump" allowtransparency="true">

     

    embed code:

     

     

    Thanks

     

     

     

     

  • Profile Image

    Answered by Ben on April 13, 2015 at 08:29 AM

    Since we can only assist with one issue / question per thread I have moved your question to a new thread here: http://www.jotform.com/answers/551178

    We will be replying to it shortly.

  • Profile Image

    Answered by windirect on April 18, 2015 at 06:18 AM

    Hello, 

    here is my sheet from yesterday

    Today I have column A - Submission Date!

    Everything moved again

     

     

     

     

     

  • Profile Image

    Answered by windirect on April 18, 2015 at 06:22 AM

     

    I noticed is the last entry.

     

  • Profile Image
    JotForm Support

    Answered by BJoanna on April 18, 2015 at 07:39 AM

    Considering that I can not access to your Google Integration Spreadsheet I cloned and tested your form and I can not reproduce problem with dates. However Submission date is in Column A and this is normal behavior. 

    Are you still facing problem with wrong dates? In case you are you can try 

    1. removing the current integration

    2. creating a new Google Spreadsheet integration

    Hope this will help. Let us know if you need further assistance. 

     

  • Profile Image

    Answered by windirect on April 21, 2015 at 10:46 AM

    Hi,

    I have every day a new problem!!!

    My Spreadsheet:

    now I have a part of the fields blank. Nome, Cognome, (Firstname and name) is blank.

    This has nothing to do with my script. I've checked

     

     

     

     

  • Profile Image

    Answered by windirect on April 21, 2015 at 10:49 AM

    I get only a part of the data !!!

     

    it just does not work !! The columns have shifted again. And now missing half the data !!!

     I have not changed anything since 2 months.

    I am sorry

    if that does not work I will look for another provider.

     

     

  • Profile Image

    Answered by Ben on April 21, 2015 at 12:05 PM

    I believe that the issue here is that you have a different local settings of your spreadsheet than it is for example if it is set as Spain.

    If I change back to English, the date and everything was working.

    Could you please check and let us know if that works for you as well.

    If not, we will raise this to our developer to check and see what might be the issue.

  • Profile Image

    Answered by windirect on April 21, 2015 at 12:28 PM

    I tested with this setting ...

    the same problem!

  • Profile Image

    Answered by Ben on April 21, 2015 at 12:43 PM

    OK thank you for the screenshot. I am notifying our developer working on this to take a look and help resolve this issue.

    He will update you on this thread as soon as he inspects the issue and finds what is the cause of it.

    In the mean time I can only suggest to use zap to connect your jotform with zapier: JotForm -> Google SpreadSheet

  • Profile Image

    Answered by windirect on April 21, 2015 at 12:57 PM

    I only need a stable interface. I do not need anything else.

    Today I had a record. The missing completely in the spreadsheet and I did not get any mail from Jot. We solve a problem and get it 2 new.

     

  • Profile Image
    JotForm Support

    Answered by alp_deniz on April 21, 2015 at 01:06 PM

    Hello Windirect,

    I was working on additional features and it has been a very difficult month for me. Please accept my sincere apologies for the problems you experience. I will make sure they are resolved today and update this thread.

    Thank you for your understanding

    Kind regards

  • Profile Image

    Answered by windirect on April 21, 2015 at 01:41 PM

    Okay thanks. Please find a solution.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on April 26, 2015 at 10:07 PM

    Hello,

    The problems should have been fixed, however, unfortunately I was not able to test your integration. Could you please let me know?

    All the best

  • Profile Image

    Answered by windirect on April 29, 2015 at 10:07 AM

    Hi,

    what should i do?

    reconnect?

    I still receive incomplete data!

    THX

     

  • Profile Image

    Answered by Ben on April 29, 2015 at 11:32 AM

    Yes, do try to remove the integration and then recreate the integration once again to see if the same issue is still present for you or not.

    If it is, do update us here about it.

  • Profile Image

    Answered by windirect on October 10, 2015 at 04:44 AM

    Hi Guys, 

    lately we have problems with the synchnronization. 

    For example this entry was not transferred to Google Docs.

    Thanks for your help