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

    Have a excel sheet that I would like to convert to Jot Form. It has a large drop down list that needs to be dealt with. Can Jot form do this?

    Asked by Dennis  on March 03, 2016 at 02:13 PM

    This list of schools is the issue which is drop.

  • Profile Image
    JotForm Support

    Answered by Kevin_G on March 03, 2016 at 03:37 PM

    If I can understand you correctly, you are trying to import the options from the Excel file to the drop down field in your form.

    If so, then it is not possible, you will need to add all the options manually in the Form Builder.

    If I did not understand your question, please provide us a bit more, we will be glad to help.

  • Profile Image

    Answered by dmelton49 on March 03, 2016 at 04:45 PM
    So I have 1400 colleges I want to add and u r saying I have to do each manual??

    ...
  • Profile Image
    JotForm Support

    Answered by Kevin_G on March 03, 2016 at 06:20 PM

    Yes, I think it is the only way to do it currently, as I can understand, you want to import the list of colleges from your spreadsheet.

    Here is a thread where one of our colleagues helped to achieve the same that you are trying to do, please take a look: http://www.jotform.com/answers/769171-How-can-I-add-data-from-a-spreadsheet-to-the-options-of-a-dropdown-field

    Hope this will help you.

  • Profile Image

    Answered by dmelton49 on March 04, 2016 at 11:45 AM
    This worked great!! Thank you. on to the issue of getting drop to align with matrix. https://www.jotform.com/?formID=60634033347147

    ...
  • Profile Image
    JotForm Support

    Answered by Charlie on March 04, 2016 at 02:20 PM

    I have cloned your form, you can check mine in this link: https://form.jotform.com/60635899621971. Is that how you would like to align the drop down with the matrix field?

    You can clone my form to have a version of it in your account by following this guide: http://www.jotform.com/help/42-How-to-Clone-an-Existing-Form-from-a-URL.

    Here's how I did mine:

    1. First, make sure to move the first "School" drop down field to a new line. Make sure to only do it in this drop down field.

    2. After that, paste this custom CSS code in your CSS tab in your Form Designer Tool:

    .form-all {

        width : 150% !important;

    }

     

    .form-line.form-line-column {

        width : 20% !important;

    }

     

    .form-line.form-line-column > div {

        width : 100% !important;

    }

     

    .form-line.form-line-column > div > select, .form-line.form-line-column > div > table {

        width : 100% !important;

    }

    Here's a screenshot showing where I pasted my CSS code.

     

    You can adjust the form width depending on your own preference. Let us know if you need more help on this.

  • Profile Image

    Answered by dmelton49 on March 04, 2016 at 04:45 PM
    Very nice ! how did u do that!!

    ...
  • Profile Image
    JotForm Support

    Answered by EltonCris on March 04, 2016 at 09:42 PM

    Basically, to create columns, you just have to shrink the fields as specified by my colleague. The CSS will enhance the design further. Just follow my colleague's guide and it will give you the desired output you want as shown on his demo form.

    You can also create your own CSS codes by going to the CSS tab as shown in the second screenshot. Just click any of the fields or sections in your form and it will dynamically create a CSS class of that element. You can then define properties by clicking any of the CSS helpers above.

    Example:

    Let us know should you have any other questions.