Google Spreadsheet Implementation changes

  • Thinkbright
    Asked on March 2, 2015 at 1: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

     

  • Sean
    Replied on March 2, 2015 at 2:21 PM

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

    Google Spreadsheet Implementation changes Image 1 Screenshot 50

    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.

    Google Spreadsheet Implementation changes Image 2 Screenshot 61

    Google Spreadsheet Implementation changes Image 3 Screenshot 72

    Google Spreadsheet Implementation changes Image 4 Screenshot 83

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


    Cheers!

  • Thinkbright
    Replied on March 2, 2015 at 2: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

  • Sean
    Replied on March 2, 2015 at 2: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.