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

    Substituting Date Values After Submission

    Asked by JuliaIngram on July 21, 2015 at 08:31 PM

    Hello, I was wondering if there was any way to replace a standard numerical date (ex. 8/16/2015) with one that is spelled out (ex. Wednesday, August 16) once it is submitted. Particularly, I have a checkbox type question with each option formatted as a spelled out date as the latter example, but I would like the submission to appear in the Google spreadsheet I have integrated submissions with in numerical format, either as a replacement for the spelled out format, or in a separate column as a response from another field.

    Basically, I want the form to look like this: Wednesday, August 16

    But the spreadsheet to say this: 8/16/2015

     

    Thank you!

    after after submission values Submissions checkbox format integrated date substitute spreadsheet
  • Profile Image
    JotForm Support

    Answered by Chriistian on July 22, 2015 at 03:11 AM

    Hi JuliaIngram,

    Thanks for contacting us.

     

    As per checking, you can only format a Date field in your form to the following format as shown in the screenshot below.

    However, in the Google Spreadsheet, you can format the Date field column, just follow the instructions below:

    1. Highlight the Date field column.

    2. Click Number button.

    3. Click "More Formats" in the dropdown options.

    4. Click "More Date and Time Formats" option.

    5. Select the format you want to set to the column.

     

    Do let us know if you need further assistance.


    Regards.