-
patioabiertoAsked on November 25, 2017 at 5:29 AM
Hi! I need some help.
I am experiencing problems with an item in the form. When the form is completed is the option to put the date of birth but when I go to see spreedsheet or in the app the information is displayed in another format or not even. Please I need help. Thank you
Page URL: https://form.jotformz.com/72280703441651 -
Support_Management Jotform SupportReplied on November 25, 2017 at 6:58 AM
Are you seeing this on the integrated Google Sheet? I gave this a test run with a cloned copy of your form but the dates are properly formatted on mine. Here's how it looked like from my perspective:
Was there a chance you accidentally modified the sheet and changed the data format of these columns? By default, without any revisions to the sheet, it should work right out of the box.
Try redoing the integration with Google Spreadsheet by removing it then re-adding it to your form.
Related guide: How-to-Integrate-Form-with-Google-Spreadsheet
-
patioabiertoReplied on November 25, 2017 at 12:22 PM
Thanks, but the trouble persist, now the cell is in white
-
David JotForm Support ManagerReplied on November 25, 2017 at 1:20 PM
So, after you remove the Google Spreadsheet integration, and integrated back again, can you confirm that you did not do any changes to the new integrated spreadsheet?
I have checked that submission(ID: 3873868880429066545) in your form(ID: 72280703441651), and the date is there, so I have pushed the missing data to your spreadsheet, please check again if it worked. Let us know if the issue persist, and so we will forward this to our back-end team.
-
patioabiertoReplied on November 25, 2017 at 5:10 PM
Its works, thaks you very much!!