use different time format in submission spreadsheet

  • Profile Image
    flashnick
    Asked on December 19, 2012 at 04:57 AM

    Can I alter the date format in the submission spreadsheet?

  • Profile Image
    abajan
    Answered on December 19, 2012 at 05:44 AM

    Hi

    That's not currently doable in the form builder. Initially, I was going to suggest Google Spreadsheet integration but I subsequently discovered that due to the compound nature of the field (both date and time in a single field) it's not possible to edit the format without removing one of the elements.

    What I could do is submit a ticket to request the feature. What is your preferred format?

  • Profile Image
    stevenyilin
    Answered on May 07, 2013 at 06:36 PM

    this doesnt make sense at all!

    somehow jotform submission dates is one format...  and the date entered from the calender tool is in a different format that google speadsheet does not recognise.

    is there a way to get a datevalue so one can do simple calculations like numbers of days between submission and customer entered target dates?

    if i add a calender tool to my form later... do i have to intergrate it into a NEW spreadsheet altogether?

    is there no way of adding it to an existing integration? my staff will think i m nuts if keep sending new spreadsheets to bookmark!

    thanks

    steve

  • Profile Image
    EltonCris
    Answered on May 07, 2013 at 08:44 PM

    @stevenyilin

    Please open your question in a separate thread so we can assist you properly. Thank you for your understanding.