Format Submissions Date on Google Spreadsheet Integration

  • Profile Image
    shelleykim
    Asked on November 05, 2013 at 02:05 PM

    I just used the app to populate all the submissions for my form on a Google Spreadsheet. However, the date is coming out as day/month/year. I've tried to reformat this on the Google Spreadsheet to reflect the format of month/day/year but it doesn't work. Any suggestions? 

    Thank you!

  • Profile Image
    EliezerN
    Answered on November 05, 2013 at 03:31 PM

    Thanks for contacting us.

    Is this the form you are talking about https://www.jotform.com/33075478854162? I found that you have the correct date format (mmddyyyy) in the form:

    I cloned your form and built the integration, then sent a submission and the google spreadsheet does not recognize that format as a date:

    Is that the way you are getting this error? or does the google calendar pop-up when you click on the date? If you get the error in the same way I do, that requires us to forward this issue to our next level support.

    So, please let us know so tha we can forward this issue to our next level support.

    Thanks

  • Profile Image
    shelleykim
    Answered on November 05, 2013 at 04:15 PM

    Hi,

    Thanks for the response. Yes, that is the form I was talking about. However, the only thing I have a problem with is the Submission date for the first column in the Google Spreadsheet. If I submit something on my form today, it comes out as 5/11/2013. Any way to fix that? Thank you!

  • Profile Image
    EltonCris
    Answered on November 05, 2013 at 10:13 PM

    @shelleykim 

    I am able to reproduce the problem. This might be due to the changed made on the mentioned integration. I am not sure if the date format is possible on the integration though but I will have to forward this to our developers for further investigation.

    As a workaround and while waiting for a solution, please use a calendar field (date/time) field for now in order to get the desired date format on every submissions.

    Thanks!

  • Profile Image
    portoakaland
    Answered on November 05, 2013 at 10:26 PM

    How do I get answer to the question ipost on the forum quickly?  I need help ASAP.

  • Profile Image
    EltonCris
    Answered on November 05, 2013 at 10:30 PM

    @portoakaland

    If you have similar question about this, please open it on a new thread so we can handle and provide you updates on your threads. We will also respond to your threads shortly.

    Thanks for your understanding!

  • Profile Image
    alp_deniz
    Answered on November 06, 2013 at 10:15 AM

    Hello,

    Submission date is now shown as you like (mm/dd/yyyy). Please let us know if you have further feedback.

    Best