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

    Submission date includes apostrophe before the date start in Google Spreadsheet integrations

    Asked by kcboiatc on February 23, 2015 at 04:51 PM

    I recently setup a form and integrated it with Google Sheets. It was working great until Feb 18. My date data from the form is showing up in google sheets as " '2015-02-18 20:18:17" due to the " ' " preceding the date, I am unable to sort my data ascending by date. This is happening with any dates involved with my form.

    Before Feb 18 the date submitted "2015-02-18 20:18:17" no apostrophe . Please help!

     

     

     

    Page URL:
    http://form.jotform.us/form/50257898090161

    form data uploads Google Spreadsheet Google integration
  • Profile Image

    Answered by Ben on February 23, 2015 at 06:22 PM

    Thank you for reporting this to us.

    I am able to recreate the exact issue that you have described.

    I am now raising this to our developers and as soon as there are any updates in regards to this you will be updated about it through this thread.

  • Profile Image

    Answered by Ben on February 23, 2015 at 06:28 PM
     
  • Profile Image
    JotForm Support

    Answered by alp_deniz on February 26, 2015 at 12:17 AM

    Hello,

    Actually the apostrophe is intentional: It is used for consistency in spreadsheets in order to keep the format. Otherwise the sheet itself modifies the date string according to the default format.

    As for the solution, it is always possible and reliable to use Format -> Number -> Date [desired format]. Does it work for you? Would you have a suggestion?

    I will be very happy to hear your thoughts.

    Kind regards

    Alp

  • Profile Image

    Answered by kcboiatc on February 27, 2015 at 05:00 PM

    It does not work because the apostrophe prevents google sheets from recognizing it as a date. When I started the form the dates imported to google sheets with no apostrophe preceding it... For what ever reason it started submitting as     '2015-02-24 22:35:48 You try to enter dates preceded by an apostrophe in google sheets and let me know if you can sort the data by date. I can not until I go in and remove the apostrophe. I have other sheets in the workbook that reference the submitted data, when I try to use a formula to extract a date, it will only do it when there is NO APOSTROPHE.

    We ( I think I speak for most spreadsheet users) would always prefer to modify the date format as we want it... not how you think we do. Please please please remove the apostrophe. It does not do me any good and it creates a lot of work.

    I appreciate you and the JotForm team work and efforts - please help me accomplish this change. 

  • Profile Image
    JotForm Support

    Answered by Mike on February 27, 2015 at 06:10 PM

    Thank you for your explanation. The ticket is still open and we will keep you updated.

  • Profile Image

    Answered by kcboiatc on February 27, 2015 at 06:26 PM

    Thank you.

  • Profile Image
    JotForm Support

    Answered by alp_deniz on April 10, 2015 at 04:25 PM

    Hello,

    The issue is resolved and apostrophe is removed. Thank you very much for your notification.

    All the best

  • Profile Image

    Answered by kcboiatc on April 13, 2015 at 10:51 AM

    That works perfect, no more apostrophe on the form submission date!, However... there is still an apostrophe being sent when the user selects a date from a form field. I still encounter the same issue as before when trying to include that data in a formula. 

    Is there anyway you can remove the apostrophe from all data submitted that includes a date? 

    Thanks again!

     

  • Profile Image

    Answered by Ben on April 13, 2015 at 12:17 PM

    Great to hear that it worked :)

    I will update Alp (our developer) in regards to this so that he can take a look if the same can be done for all dates as per your request.

    As soon as there are any updates, we will update you through this thread.

  • Profile Image

    Answered by chantinon on April 17, 2015 at 03:13 PM

    This problem is back  :/
  • Profile Image

    Answered by Malcolm  on October 19, 2016 at 03:11 PM

    Yes, its back.  Cant use date picker to correct it in my form bc the date displays the wrong way when the form responses are sent into my doc template.