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

    Issues with Google Spreadsheets Integration

    Asked by c2forms on October 29, 2015 at 07:48 PM

    I have integrated my sheet with a goole form and have two issues. One is a bug. The other I just want to verify functionality.

     

    1) The submission date is showing correctly in the jotform submissions view but goes into the sheet as a number like 42306.8214.

    2) I remember a while ago that when you added a submission it updated the entire google sheet according to the submissions in jotform. Now in our testing it appears we can delete items from the sheet and it only updates new submissions. I actually really like that but just would like to verify that is the way it really works.

     

    Thanks for your assistance.

    Page URL:
    https://form.jotform.com/52727200888965

    Submissions Google integration Google Spreadsheet
  • Profile Image

    Answered by Ben on October 30, 2015 at 03:29 AM

    The reason why the date is shown to you as such number is because your spreadsheet got turned into a different locale.

    To fix it, you should set locale for your spreadsheet to United States.

    To do that you should click on File -> SpreadSheet Settings and then change the dropdown under Locale label.

    As soon as you do, you should see dates coming in properly.

    Now the second part of your post is telling me that you have broken your integration. It might still be working, but it is bound to break at some point.

    The reason why I say that is because no changes should be made to the sheet that is created by the integration, or it will cause the integration to break (even if it seems to work right after the change). This includes removal of the submission as well.

    You can use any type of functionality to copy the data to the other sheet that you can then edit and do any action that you wish no matter if that sheet is part of the original spreadsheet or not, as long as the sheet created by integration, as mentioned above, does not get modified.