Creating a form with preferences

  • Profile Image
    Asked on July 28, 2015 at 02:41 PM

    I need to create a spreadsheet that contains four individual days, several services with different times that vary on the days. The client needs to select those service times they are interested in by preference 1 thru 3. Any idea? 

  • Profile Image
    Answered on July 28, 2015 at 04:07 PM


    Can you also share to us the URL of the form you are working this on. We can evaluate further once we understand how the form will be.


    Initially, I think you will need to have the following fields/data on the form.


    Services type


    because you will probably need to filter the would be generated submission data base on those fields/data.

    If you will be integrating the form to Google Spreadsheet (since you mentioned spreadsheet), we know that the form submission data will only go to a single spreadsheet every time.

    So there will be a need to work outside the form submission spreadsheet (by copying the submission sheet separately), to be able to do all the filtering process -- that is, create Sheet for Days, Services, and DateTime.

    Let us know how we can be of further assistance.