Google Spreadsheet Integration Issue

  • Profile Image
    chiragvora123
    Asked on June 26, 2014 at 03:12 AM

    I always face this issue. The submission time always changes the style due to which my whole calculations are affected. How to retify that?

     

  • Profile Image
    ashwin_d
    Answered on June 26, 2014 at 04:42 AM

    Hello chiragvora123,

    I am not sure if I have understood your question correctly.

    When you say that "The submission time always changes the style", do you mean to say that the time format gets changed or you have done some customization on your google spreadsheet?

    Please be noted that any changes in the column names will cause the integration to break. Please explain your problem a bit more in detail. I would suggest you to share a screenshot of the problem for us to be able to understand your issue better. The following guide should help you upload image in your forum post:  http://www.jotform.com/answers/277033

    We will wait for your response.

    Thank you!

  • Profile Image
    chiragvora123
    Answered on June 26, 2014 at 05:55 AM

    See what happening is sometimes the timestamp is 6/26/2014 13:29:10 and after few time it automatically changes to 06/26/2014 13:29:10 due to which all my formulas are getting wrong.. And more over.. the bad part is i have done calculations in different sheets of same spreadsheet, it automatically gets deleted and i have create all my formulas again

  • Profile Image
    NeilVicente
    Answered on June 26, 2014 at 07:22 AM

    @chiragvora123

    Our Google spreadsheets integration works in a way that each time a new submission is created, JotForm uploads the entire spreadsheet from our server to your Google account, overwriting the old copy. That also means edits made to the spreadsheet will be gone.

    Unfortunately, there is no way around this. Our integration works this way to protect the integrity of the data on Google's servers, e.g., if a column is deleted or went missing, syncing data would be a mess.

  • Profile Image
    lsymms
    Answered on June 23, 2016 at 11:37 AM

    Create another sheet to view the data by referring to the other sheet: https://docs.google.com/spreadsheets/d/1N4cuM_IuNXwAF3Kibgyh3DIKWOYUS179W07itw9Mjlg/edit#gid=1754351616