Discussions

 View Only
  • 1.  Creating dynamic Surveys

    Posted 10-17-2019 15:48
    Hi Everyone, 

    I am trying to ease the process of survey collection and analysis by having all surveys be created via Quick Base. While I found a way to open surveys for everyone on the internet, and ensure friendly user interface, I wanted to know how to create a Likert scale type of question. 

    Would appreciate any and all help on this! Thank you in advance.

    ------------------------------
    Nada Mousa
    ------------------------------


  • 2.  RE: Creating dynamic Surveys

    Posted 10-17-2019 17:51
    Here is the easiest example. Make a Multiple Choice field and use either the 5 or 7 Likert scale. When you put it on the form, you can go to Customize This Form and there will be an option for that field "Display choices as radio buttons (instead of a dropdown)". Make it Required if you want to hide the option None of the above or it will appear at the bottom by default.



    ------------------------------
    Everett Patterson
    ------------------------------



  • 3.  RE: Creating dynamic Surveys

    Posted 10-21-2019 11:14
    Thank you so much!

    ------------------------------
    Nada Mousa
    ------------------------------



  • 4.  RE: Creating dynamic Surveys

    Posted 10-18-2019 09:21
    Edited by Adam Keever 10-18-2019 10:10
    Here is another option similar to Everett's suggestion:

    Add an image on load formula rich text field to force the radio buttons in horizontal orientation and hide the field on your form (this suggestion and code came from Chayce Duncan of Quandry Consulting Group). Add multiple choice fields as Everett suggested. Add a text form element for descriptions (also could be used for your questions if you want a larger font for your questions.

    Here is the result:

    Here is the image on load code for the formula rich text field:
    "<img src=\"/i/clear2x2.gif\" " &
    "onload=\"javascript:if(typeof QBU=='undefined'){QBU={};setTimeout(function(){" & 
        "$('.RadioButtons br').remove();" &
        "$('.RadioButtons label.NoneOfTheAbove').remove();" &
        "$('.RadioButtons label').css('margin-right', '25px')" &
    "}, 500)}\">"​
    Here is one way to hide the field (in this example it is titled [HORIZ_IOL]) on a form:

    Here is how to adjust text size and add bold type in a form text element (added in this example just after the section heading element):
    Since the HTML for underline type is not allowed in the text element, a line break, </br>, and many underscores were used to create the appearance of underlined text.

    If you have the need to calculate an overall or average score, you would need to add a formula numeric field for each likert checkbox field and us the ToNumber function in order to return the number value of the likert scale (using the likert field name from the above form for example: ToNumber([Likert_Scale1]). Then you would need an additional formula numeric to sum or average all of the likert formula numeric fields.

    ***The above works best for desktop. If you will be using for mobile, the IOL will not work and the checkbox radio buttons will be vertical. Making all of the Likert_Scale fileds required removes the 'None of the above' option and only shows the 1 through 7 options in this example.



    ------------------------------
    Adam Keever
    ------------------------------