Creating a form with preferences

  • Profile Image
    wrt
    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
    jonathan
    Answered on July 28, 2015 at 04:07 PM

    Hi,

    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.

    Days

    Services type

    DateTime

    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.

    Thanks.