Google Spreadsheet does not sync properly

  • windirect
    Asked on April 8, 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

  • Ben
    Replied on April 8, 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.

  • windirect
    Replied on April 8, 2015 at 2:26 PM

    Hi,

    the last entries are not complete.

    is missing:

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

     

    Google Spreadsheet does not sync properly Image 1 Screenshot 20

  • Ben
    Replied on April 8, 2015 at 4: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.

  • windirect
    Replied on April 9, 2015 at 5:46 AM

    Hi, 

    the spreadsheet does not synchronize today.

    what can i do?

    THX

     

     

  • Ben
    Replied on April 9, 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

  • Ben
    Replied on April 9, 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.

  • PghArtsCouncil
    Replied on April 9, 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.
  • Ben
    Replied on April 9, 2015 at 1: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.

  • windirect
    Replied on April 9, 2015 at 3:15 PM

    Hi,

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

    Google Spreadsheet does not sync properly Image 1 Screenshot 20

  • windirect
    Replied on April 9, 2015 at 3: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

  • Ben
    Replied on April 9, 2015 at 4: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.

  • Ben
    Replied on April 9, 2015 at 4: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.

  • windirect
    Replied on April 10, 2015 at 2: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.Google Spreadsheet does not sync properly Image 1 Screenshot 20

     

     

  • Welvin Support Team Lead
    Replied on April 10, 2015 at 9: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

  • windirect
    Replied on April 10, 2015 at 9: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

  • Welvin Support Team Lead
    Replied 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!

  • windirect
    Replied on April 13, 2015 at 5: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

     

     

     

     

  • Ben
    Replied on April 13, 2015 at 8: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.

  • windirect
    Replied on April 18, 2015 at 6:18 AM

    Hello, 

    here is my sheet from yesterday

    Google Spreadsheet does not sync properly Image 1 Screenshot 30

    Today I have column A - Submission Date!

    Everything moved again

    Google Spreadsheet does not sync properly Image 2 Screenshot 41

     

     

     

     

     

  • windirect
    Replied on April 18, 2015 at 6:22 AM

     

    I noticed is the last entry.

     

    Google Spreadsheet does not sync properly Image 1 Screenshot 20

  • BJoanna
    Replied on April 18, 2015 at 7: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. 

    Google Spreadsheet does not sync properly Image 1 Screenshot 20

    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. 

     

  • windirect
    Replied 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 checkedGoogle Spreadsheet does not sync properly Image 1 Screenshot 20

     

     

     

     

  • windirect
    Replied 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.

     

     

  • Ben
    Replied 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.

    Google Spreadsheet does not sync properly Image 1 Screenshot 20

    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.

  • windirect
    Replied on April 21, 2015 at 12:28 PM

    I tested with this setting ...

    the same problem!

    Google Spreadsheet does not sync properly Image 1 Screenshot 20

  • Ben
    Replied 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

  • windirect
    Replied 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.

     

  • alp_deniz
    Replied on April 21, 2015 at 1: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

  • windirect
    Replied on April 21, 2015 at 1:41 PM

    Okay thanks. Please find a solution.

  • alp_deniz
    Replied 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

  • windirect
    Replied on April 29, 2015 at 10:07 AM

    Hi,

    what should i do?

    reconnect?

    I still receive incomplete data!

    THX

     

  • Ben
    Replied 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.

  • windirect
    Replied on October 10, 2015 at 4: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

     

     

    Google Spreadsheet does not sync properly Image 1 Screenshot 20