-
JimAsked on February 9, 2017 at 9: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 fields 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.
-
Kevin Support Team LeadReplied on February 9, 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:
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.