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?

  • Profile Image
    Dennis 
    Asked on March 03, 2016 at 02:13 PM

    This list of schools is the issue which is drop.

  • Profile Image
    Kevin_G
    Answered 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
    dmelton49
    Answered 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
    Kevin_G
    Answered 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
    dmelton49
    Answered 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
    Charlie
    Answered 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
    dmelton49
    Answered on March 04, 2016 at 04:45 PM
    Very nice ! how did u do that!!

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