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
------------------------------ Matthew Jones ------------------------------
So quickbase is up and running for other things, I have created a app area for testing. I started to create a test using a form but idk if this is the right direction, i do have the question in it as multiple choice but i am really needing to be bale to create many quizzes at we move on. But at the same time i need to make sure the other employees cannot see the quizzes other people have completed also so they cannot cheat.
------------------------------ Matthew Jones ------------------------------
The Score fields would be formula numeric fields. You could use a CASE or IF statement to capture the correct answer, giving a 1 or correct and 0 for incorrect.
Then you could sum all the scores and divide them by the number of questions to get your overall score.
You could use roles and permissions to restrict users from seeing reports, charts, data, etc.
You could use dynamic form rules to make your form more user friendly.
That is one basic idea on how to go about doing it.
------------------------------ Andrew andrew.fry25@gmail.com ------------------------------
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
Example 2 - show one question at a time (yes I made a progress bar out of the tabs with onclick goes to next tab, hey it works)
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
