JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.
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.
Google Spreadsheet Integration IssueAsked by chiragvora123 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?
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.
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
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.
Create another sheet to view the data by referring to the other sheet: https://docs.google.com/spreadsheets/d/1N4cuM_IuNXwAF3Kibgyh3DIKWOYUS179W07itw9Mjlg/edit#gid=1754351616