multiple choice quiz
I am needing to make a multiple choice quiz that the employees can login and take and show me the results. Pass / Fail type thing. Any help would be great as im new this. Thanks --------------...
Forum Discussion
Here's some examples.
Example 1 - multiple choice text and convert to answer
Q1 Formula (formula text)
Total D's (formula numeric)
Q3 Formula (formula rich text)
------------------------------
Everett Patterson
------------------------------
Example 1 - multiple choice text and convert to answer
Q1 Formula (formula text)
Case([Q1], "a. interact with many different people, strangers included.", "D","b. talk one-on-one mostly with people you already know.", "N","c. use the opportunity to make important contacts.", "A","d. leave as soon as it is polite to do so.", "C")Total D's (formula numeric)
var text letter = "D"; var number a = If([Q1 Formula]=$letter, 1, 0); var number b = $a+ If([Q2 Formula]=$letter, 1, 0); var number c = $b+ If([Q3 Formula]=$letter, 1, 0); var number d = $c+ If([Q4 Formula]=$letter, 1, 0); var number e = $d+ If([Q5 Formula]=$letter, 1, 0); var number f = $e+ If([Q6 Formula]=$letter, 1, 0); var number g = $f+ If([Q7 Formula]=$letter, 1, 0); var number h = $g+ If([Q8 Formula]=$letter, 1, 0); var number i = $h+ If([Q9 Formula]=$letter, 1, 0); var number j = $i+ If([Q10 Formula]=$letter, 1, 0); var number k = $j+ If([Q11 Formula]=$letter, 1, 0); var number l = $k+ If([Q12 Formula]=$letter, 1, 0); $l
Q3 Formula (formula rich text)
var text divstyle = "style=\"width: 100%; overflow: auto; display: inline;\""; var text astyle = "style=\"width: 12px; display: inline;\""; var text pstyle = "style=\"border: 1px solid black; border-image: none; width: 250px; height: 75px; text-align: center; color: rgb(82, 87, 91); line-height: 70px; font-size: 20pt; text-decoration: none; display: inline-block; cursor: pointer;\""; var text optionone = "Submissive"; var text optiontwo = "Self Sacrificing"; var text optionthree = "Sociable"; var text optionfour = "Strong Willed"; "<div "& $divstyle &">" & "<a "& $astyle &"onmouseover=\"$(this).children().css({'background-color':'#be1e2d', 'color':'#fff'});\" onmouseout=\"$(this).children().css({'background-color':'#fff', 'color':'#52575b'});\" onclick=\"$('#_fid_61').val('" & $optionone & "'); $(this).siblings().children('p').css({'background-color':'#fff', 'color':'#52575b'}); $(this).children().css({'background-color':'#be1e2d', 'color':'#fff'}); setTimeout(function(){var nextTabLink = $('li.ui-tabs-selected').next().children('a'); $(nextTabLink).click();},750); $('#tab_t3_link').css('background-color','lightgreen'); return false\">" & "<p "& $pstyle &">" & $optionone & "</p>" & "</a>" & "<a "& $astyle &"onmouseover=\"$(this).children().css({'background-color':'#be1e2d', 'color':'#fff'});\" onmouseout=\"$(this).children().css({'background-color':'#fff', 'color':'#52575b'});\" onclick=\"$('#_fid_61').val('" & $optiontwo & "'); $(this).siblings().children('p').css({'background-color':'#fff', 'color':'#52575b'}); $(this).children().css({'background-color':'#be1e2d', 'color':'#fff'}); setTimeout(function(){var nextTabLink = $('li.ui-tabs-selected').next().children('a'); $(nextTabLink).click();},750); $('#tab_t3_link').css('background-color','lightgreen'); return false\">" & "<p "& $pstyle &">" & $optiontwo & "</p>" & "</a>" & "<a "& $astyle &"onmouseover=\"$(this).children().css({'background-color':'#be1e2d', 'color':'#fff'});\" onmouseout=\"$(this).children().css({'background-color':'#fff', 'color':'#52575b'});\" onclick=\"$('#_fid_61').val('" & $optionthree & "'); $(this).siblings().children('p').css({'background-color':'#fff', 'color':'#52575b'}); $(this).children().css({'background-color':'#be1e2d', 'color':'#fff'}); setTimeout(function(){var nextTabLink = $('li.ui-tabs-selected').next().children('a'); $(nextTabLink).click();},750); $('#tab_t3_link').css('background-color','lightgreen'); return false\">" & "<p "& $pstyle &">" & $optionthree & "</p>" & "</a>" & "<a "& $astyle &"onmouseover=\"$(this).children().css({'background-color':'#be1e2d', 'color':'#fff'});\" onmouseout=\"$(this).children().css({'background-color':'#fff', 'color':'#52575b'});\" onclick=\"$('#_fid_61').val('" & $optionfour & "'); $(this).siblings().children('p').css({'background-color':'#fff', 'color':'#52575b'}); $(this).children().css({'background-color':'#be1e2d', 'color':'#fff'}); setTimeout(function(){var nextTabLink = $('li.ui-tabs-selected').next().children('a'); $(nextTabLink).click();},750); $('#tab_t1_link').css('background-color','lightgreen'); return false\">" & "<p "& $pstyle &">" & $optionfour & "</p>" & "</a>" & "</div>"
------------------------------
Everett Patterson
------------------------------
So i like the way example 1 looks, but how did you create it to look like that. I am still learning Quickbase so kinda lost on it.
------------------------------
Matthew Jones
------------------------------
------------------------------
Matthew Jones
------------------------------
- Make a new field for question 1, Text - Multiple Choice and fill in each answer (a, b, c, d, e)
Put the new field on your Form, and for the new field you should see the option to Display choices as radio buttons (instead of a dropdown) and change the label to the question
------------------------------
Everett Patterson
------------------------------- Ok last question i see you have Q1 Formula, can you show me how you have it setup like you did with the last screen shot. It will help me understand if i can see.
------------------------------
Matthew Jones
------------------------------- I'm not sure what answers you are trying to calculate or look for, do you have a mock up example?
Case([Q1], "a. this is the first answer", "a", "b. this is the second answer", "b", "c. this is the third answer", "c", "d. this is the fourth answer", "d")
------------------------------
Everett Patterson
------------------------------