Issues with Google Spreadsheets Integration

  • Profile Image
    Asked 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.

  • Profile Image
    Answered 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.