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 would like to create a multiple date-picker that would translate to one cell in a google sheets

    Asked by sysadmin@toothworks.com on March 21, 2014 at 11:08 AM

    Hi There,


    I am creating a Staff Time Off Request Form and am trying to achieve something particular.

    We will need the form to be integrated into a shared Google Sheets and I am trying to limit the amount of cells that the form will create. One option I have been requested is to allow the staff members to choose multiple non consecutive dates.

    I would like to know, what is my best option for limiting this to a single collumn output on a google sheets;

    If I use multiple instances of the date picker and lable them Date1, Date2, Date3, Date4, that would translate to multiple collumns on the Google Sheets.

    Do you have any recommendations?




  • Profile Image
    JotForm Support Manager

    Answered by Jeanette on March 21, 2014 at 12:56 PM

    Yes, each field would be translated into a column

    An alternative would be to integrate the form with Google Drive and create a sub-folder, based on the Name field