Google Spreadsheet Implementation changes

  • Profile Image
    Thinkbright
    Asked on March 02, 2015 at 01:16 PM

    Hello Support,

     

    I have a question. Since February 18 I've noticed that dates in our google sheets - jot form linked spreadsheets are getting stored as text instead of dates e.g. ('2015-02-18 18:28:39 instead of 2/18/2015 18:10:19) Is this a bug? It is causing us a lot of trouble in our implementations.

     

    Thanks,

     

    Pablo Castellanos

    Bright

     

  • Profile Image
    Sean
    Answered on March 02, 2015 at 02:21 PM

    I believe you are referring to the Submission Date column in your Google Spreadsheet? 



    This not a bug. This is the predefined format (by Jotform) used when storing the exact time a submission was done. This time can not be adjusted but your can add a field to your form that could provide similar data. Is that a possible workaround for you?

    You can use the DateTime field under your Quick Tools tab to store similar data in the order that you desire.







    I hope this information helped. Do let us know if further assistance is needed.


    Cheers!

  • Profile Image
    Thinkbright
    Answered on March 02, 2015 at 02:32 PM

    Thanks for your answer. It's very interesting since somehow google spreadsheets is not handling the date as a date anymore. Maybe it's a change on their side. Anyways, I found a workaround using iferror + DATEVALUE.

    Best,

    Pablo

  • Profile Image
    Sean
    Answered on March 02, 2015 at 02:38 PM

    Great! I am glad you were able to find a sufficient workaround. Please don't hesitate to contact us if further assistance is needed.