- chiragvora123Asked 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?
- JotForm Supportashwin_dAnswered on June 26, 2014 at 04:42 AM
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.
- chiragvora123Answered 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
- JotForm SupportNeilVicenteAnswered on June 26, 2014 at 07:22 AM
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.
- lsymmsAnswered 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