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

    Creating a form with preferences

    Asked by wrt 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? 

    creating different create
  • Profile Image
    JotForm Support

    Answered by jonathan 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.