The date format is incorrect in the integrated Google Spreadsheet

  • patioabierto
    Asked 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 youundefined Screenshot 10

    Jotform Thread 1306882 Screenshot
  • Support_Management Jotform Support
    Replied 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:

    The date format is incorrect in the integrated Google Spreadsheet  Image 1 Screenshot 20

    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 

  • patioabierto
    Replied on November 25, 2017 at 12:22 PM

    Thanks, but the trouble persist, now the cell is in white1511630449IMG 3BD499EF23AC 1 Screenshot 10

    1511630449IMG 3BD499EF23AC 1 Screenshot 101511630542Captura de pantalla 2017 11 25 Screenshot 32

  • David JotForm Support Manager
    Replied 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.

  • patioabierto
    Replied on November 25, 2017 at 5:10 PM

    Its works, thaks you very much!!