Date/time not pushing to google sheet in proper format.

  • Profile Image
    fredfon
    Asked on December 15, 2017 at 11:48 AM

    Date/time not pushing to google sheet in proper format.

    https://www.jotform.com/70785856979179

    Date/time appears properly on jot form list-but on the google spreadsheets it appears as a number that makes no sense. See attached pic.
    Would be a drag to have to remove integration and re-apply as I have applied a lot of conditional formatting to the sheet.

    Please advise.

    Thank you
    1513356466date:time jotform.jpeg

  • Profile Image
    Mike_G
    Answered on December 15, 2017 at 01:20 PM

    I have created a clone version to try to replicate the issue you are having, but I was not able to.

    1513361747t13_14_50.png

    You mentioned that you have applied a lot of conditional formatting to the sheet integrated with your form. Please know that we do not encourage our users to alter anything on the sheet integrated with their form to prevent any inconvenience. However, in your case, you can try to change the format of the "Submission Date" and "DateTime" columns in your spreadsheet (please see image below).

    1513362012t13_18_13.png

    I hope this helps. If you have other questions or concerns, please feel free to contact us again anytime.

  • Profile Image
    fredfon
    Answered on December 15, 2017 at 01:43 PM
    That worked.
    Thank You for your prompt response.
    ...