What is JotForm?
JotForm is a free online form builder which helps you create online forms without writing a single line of code. No sign-up required.

At JotForm, we want to make sure that you’re getting the online form builder help that you need. Our friendly customer support team is available 24/7.

We believe that if one user has a question, there could be more users who may have the same question. This is why many of our support forum threads are public and available to be searched and viewed. If you’d like help immediately, feel free to search for a similar question, or submit your question or concern.


  • Profile Image

    I am having date format issues in the add on for Google Spreadsheets

    Asked by marbellamike on April 16, 2014 at 06:55 AM

    Hi,

    I have three forms created with you at the moment all of which provide data to me through google spreadsheets and the perfomance is great.

    I am english speaking and based for time location in Spain.  The first part of my data has exported fine for the first couple of hundred submissions and I am able to adjust the date / time format to display as i wish

    i.e. 

    11/04/2014

    11/04/2014  12:12:10

    But after that it appears the auto date/time inputing to my spread sheet is being traeated as text.  I have th esheet and the settings in JF  set correctly for the location format but this then does not allow me to build reports based on the data.

    Any ideas welcome.

    Kind regards,

    Michael



    Page URL:
    http://form.jotformeu.com/form/40825064409352?

    format Reports Submissions style size
  • Profile Image
    JotForm Support

    Answered by TitusN on April 16, 2014 at 08:56 AM

    Hello,

    Let me see if I understand:

     - When the form is filled, the time/date of the new submission is populated in Google Spreadsheet

     - The Time zone settings are correct

     - The Time/Date Field is however read as text - which does not allow you to use the spreadsheet results to build a report - right?

    Kindly clarify.

    In the meantime -

    Why not try the following:

    1. Add a Date-time field onto your form

    2. Open the Properties dialog

    3. Hide the field

    4. Make sure the default value is turned on

    5. You may turn on/off time

    This field will make sure that it captures the time the form is being used - and it gives you more formatting options. 

    This change will however require you to reintegrate your Google Spreadsheet - which will create a new one rather than connect to the old one.