Expand all | Collapse all

Creating an exam

  • 1.  Creating an exam

    Posted 01-15-2020 16:06
    Edited by Jeff Jeff 01-15-2020 16:08
    Hello all,

    I'm looking to create an app that allows everyone on the internet to take a test, and I'm hoping to get some help with the basic app structure.  This will allow internal users to create tests, add questions and multiple choice answers.

    I'll layout what my initial thinking was.

    • Tests
      • has many related Test Questions
      • has many related Submissions
    • Test Questions: has many related Possible Answers, and one related correct answer
    • Submissions
      • Everyone on the internet will have the ability to add a record from the related Test
      • Should list all the Test Questions and allow the user to select from the Possible Answer for each question
    • Possible Answers

    I'm having trouble figuring out how I could display all the test questions on a Submission form. My goal was to then use formula fields to calculate how many of the given answers equal the correct answer and therefore have it automatically graded. Ideally the user will open the Tests table, pick a test, then click a button which adds a record to Submissions for that test and saves the record to submit their test.

    Hopefully I've started out in the right direction but I wouldn't mind totally changing the approach to something that would work better in Quickbase. I'm more concerned now with the basic structure right now and would work on permissions later to get it ready for Everyone on the internet.

    Jeff Jeff


  • 2.  RE: Creating an exam

    Posted 01-17-2020 12:25
    I have built these type of apps before, but the steps to create such an app are beyond the scope of what can be answered on this forum.  If you want to have some one on one assistance you can contact me directly.

    Mark Shnier (YQC)
    Quick Base Solution Provider
    Your Quick Base Coach