I would like to create a multiple date-picker that would translate to one cell in a google sheets

  • Profile Image
    Asked 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
    Answered 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