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

    Likert Scale Randomization / API or parsing data from form to my database

    Asked by Jim  on February 09, 2017 at 09:31 AM

    Hi there. I'm trying to build a more complexed survey and I need to understand if Jotform can accommodate.

    The survey consists of 3 sections.

    1) General Information: This section will have questions that require free form text boxes. The free form text boxes must have character length limits. Can Jotform do this?

    2) Section 2 and 3, are Likert Scale questions such as:

    How important is teamwork to your employer?

    -Extremely important, Very important -Moderately important -Slightly important -Not at all

    These questions (not the answers) need to be randomized per new user to avoid common method bias. How can I do this?

    Also, sections 2 and 3 cannot be grouped together. They must have their own randomization. Can this be done? If so how?

    Can I ask a question like: Choose your top 20 values from a list, then once they choose the 20...ask them another question to narrow those 20 down to their top 10? (logic jumps...assumingly)

    Lastly, I need to be able to export the data (via API or something) into my SQL database instantly through code.  What is your solution for that? 

     

    Please help!  If you can help me, I will gladly signup for the service right now. 

  • Profile Image
    JotForm Support

    Answered by Kevin_G on February 09, 2017 at 11:23 AM

    1). Yes, you can indeed limit the number of characters entered in a field, to achieve that you only need to open the field properties, go to the options tab and turn on the limit entry option: 

    2). You could use either a check box or survey fields to list these questions: 

    These questions (not the answers) need to be randomized per new user to avoid common method bias. How can I do this?

    This can be done using our Shuffle widget: http://widgets.jotform.com/widget/shuffle 

    This guide will help to add the widget: https://www.jotform.com/help/252-How-to-Add-a-Widget-to-your-Form 

    Also, sections 2 and 3 cannot be grouped together. They must have their own randomization. Can this be done? If so how?

    You could add a page break to separate your fields, I have tested this and I can see the fields will be changed inside the page section, they will not be changed with fields of other pages. 

    This guide will help you to add the page break to your form: https://www.jotform.com/help/119-How-to-Create-Multi-Page-Forms 

    Can I ask a question like: Choose your top 20 values from a list, then once they choose the 20...ask them another question to narrow those 20 down to their top 10? (logic jumps...assumingly)

    You could indeed list the options, but as far as I know it is not possible to send this selected options to another field and allow them to be ordered. 

    However, you may take a look on these widgets that may help you: 

    https://widgets.jotform.com/app/dual_listbox

    https://widgets.jotform.com/app/visual_multi_select

    https://widgets.jotform.com/widget/orderable_list

    Lastly, I need to be able to export the data (via API or something) into my SQL database instantly through code.  What is your solution for that? 

    You could get info about our API here: 

    http://api.jotform.com/docs/

    https://developers.jotform.com/libraries

    And this guide will also help you to send the submitted data to your MySQL database: https://www.jotform.com/help/126-How-to-send-Submissions-to-Your-MySQL-Database-Using-PHP 

    Hope this helps.