Google Sheet integration with wrong date format

  • Profile Image
    BuryTrainingServices
    Asked on October 26, 2020 at 08:24 AM

    Hi There

    please help, when integrating with google sheets the wrong date format show

    i have read forum and looked at going into sheet and modifying date format there but
    that does not correct the error if date is uploaded incorrectly.

    example

    date entered on form

    3rd September 2020

    date showing on google sheet
    9-03-2020

    so even if i do the data format it can do put correct date.


    regards

    colin

  • Profile Image
    Sonnyfer
    Answered on October 26, 2020 at 09:43 AM

    Hello Colin - Apologies for the inconvenience.

    I assume this is the form you're working on: https://www.jotform.com/201264235414344

    I checked the Date fields on it and can't seem to find a "3rd September 2020" format. Anyhow, you can change the Date Format on the properties of your Date Picker fields to match the formatting on your Google Sheets.

    1603719766_5f96d256a2272_

    Hope this information helps.

  • Profile Image
     
    Answered on October 26, 2020 at 11:16 AM

    Hi There

    please look at pics attached to explain in more depth

    picture one shows the current settings1603724875_5f96e64b270b1_date1.pngpicture 2 shows actual data save on pdf & submissions  and google sheet
    1603725125_5f96e74543b5a_date2.png


    picture 3 data on google sheet

    1603725328_5f96e8107e587_date3.pnghave tried to manually correct in sheets but it just returns to same as above have also tried to correct using the date format tool.

  • Profile Image
    Carlos_C
    Answered on October 26, 2020 at 02:57 PM

    Hello There

    After checking your message, I was able to create a clone and set up a quiz: https://form.jotform.com/202996098022965.

    I wasn't able to reproduce the issue, this my result:

    1603738406_5f971b2655759_Screenshot - 20

    Could you please try to remove the Google Sheet integration and reintegrate with a new file just to verify if the Google Sheet is having issues?


  • Profile Image
    colin 
    Answered on October 26, 2020 at 06:28 PM

    ok I have removed old integrated file and compiled a new one


    the issue is when we integrate within google sheets


    some of the entries show up with the date (dd-mm-yyyy) separator "-"

    and some entries show up with the date (dd/mm/yyyy) sperator "/"  

    once you try and change the date separator from"-" into "/" then the date format changes

    and because I need to have file in  CSV to manipulate in other programs I must be able to have date separator has "/"

    1603751265_5f974d61687e2_date4.png

  • Profile Image
    Carlos_C
    Answered on October 26, 2020 at 08:25 PM

    Hello,

    I already escalate the issue to the developer's team, and once he has an update we will reach you out.


  • Profile Image
    BuryTrainingServices
    Answered on October 28, 2020 at 10:57 AM

    URGENT

    Hi Guys

    really need to try and get this sorted.


    im unable to collate correct training records via date because of incorrect date produces on some entireties


    COLIN

  • Profile Image
    KrisLei
    Answered on October 28, 2020 at 12:22 PM

    Hello Colin,

    As I have verified, the escalated ticket is currently on our important list and still being work upon by a designated team.

    Would it be okay if you try to integrate the form into Google Sheets via Zapier for the time being?: https://zapier.com/apps/jotform/integrations

    Let's see if it will make a difference, and I have also cleared your form cache. Kindly give it a try, and please do let us know how it goes. Thank you.

  • Profile Image
    colin jones 
    Answered on October 29, 2020 at 04:24 AM

    hi have had a quick look at zapier,.


    looks very complicated to set up don't think I have time to even start trying to use.

    just need simple access to data via google sheets or excel with correct formatting has the programme is supposed to do.

    regards

    colin



  • Profile Image
    Richie_P
    Answered on October 29, 2020 at 06:24 AM

    We do apologize for the inconvenience.

    We cannot give an ETA when this issue would be resolved however, I will try to ask for possible progress of the investigation.

    Once we have further information, you will be notified at this support ticket.

  • Profile Image
    BuryTrainingServices
    Answered on November 01, 2020 at 09:24 AM

    Hi Guys


    it is with some disapointment that I find myself having to ask again, what's happending with the problem I have with the date changing the format.


    i really need to sort so I can continue to work with my form.


    regards

    colin

  • Profile Image
    Carlos_C
    Answered on November 01, 2020 at 12:45 PM

    At the moment we don't have an update yet since the team still working on your ticket.

    We already request an update and one we have we will reach you as soon as possible.


  • Profile Image
    Colin jones
    Answered on November 08, 2020 at 06:21 PM

    It is with some disappointment I find myself having to msg yet again.

    please could advice if this issue is going to be resolved.


    or do I amandon any hope of a resolution.


    colin

  • Profile Image
    roneet
    Answered on November 08, 2020 at 10:29 PM

    Hello Colin,

    We are sorry for the inconvenience this has caused.

    Unfortunately, we have not received an update as of now.

    As a workaround, I would suggest you use the Date Picker widget where you would be able to change the hyphen to a slash.

    1604892536_5fa8b7782790a_

    1604892332_5fa8b6ac4dfe6_

    Result in Google Sheet:

    1604892431_5fa8b70feb087_

    I hope this would be helpful.

    Thanks.

  • Profile Image
    BuryTrainingServices
    Answered on November 11, 2020 at 04:45 AM

    Hi there


    I already use date picker

    It even happens with your eatable export to csv or excell


    Really need to sort, but does not look like I'm not going to get it resolved


  • Profile Image
    Richie_P
    Answered on November 11, 2020 at 05:55 AM

    Thank you for checking out the work around.

    Unfortunately, updates are not available as of the moment however the ticket has been assigned already to our developers.

    Once we have further information, you will be notified at this support ticket.

  • Profile Image
    serbay
    Answered on December 07, 2020 at 11:26 AM

    Hello @BuryTrainingServices,


    The Google Integration seems to work smoothly with all its features.

    We figured out that the problem was caused by changing the 'Format' option of the date picker field you used on the form after the integration was configured.


    If you change the format of the date picker between two submissions, new submission data will be saved with the new format settings.

    After you set the DatePicker format precisely, all new submissions will saved in the date format you prefer.

    Your previous submissions are not affected by the new format settings.


    Thanks for your understanding.

    Regards.