Skip to main content

I need to create a test/quiz for my employees in order for them to be certified in a subject area.

I'd like to create a form with 30 questions, each question with up to 4 multiple choice answers.  I have an answer key, indicating which of the answers is correct

Is there a way for the employee to complete the form and submit and AT automatically compares the answers to the answer key and provides the number answers correct and the percentage of answers correct out of 100.

This might be easier with an (albeit long) formula field rather than a separate answer key (which I assume is either a separate table, or 30 fields in the same table with the correct answer identified).

That formula could look like:

SUM(

  IF({Question 1 field} = "Correct Answer", 1, 0),

  IF({Question 2 field} = "Correct Answer", 1, 0),

  IF({Question 3 field} = "Correct Answer", 1, 0),

  ...

  IF({Question 30 field} = "Correct Answer", 1, 0)

)/30

 ^ Format the result as a percentage

You can create a table with 30 single-select fields, where each field is one question, and the single-select choices are the possible answers. Then have the answer key in the formula field as Kamille describes.

​@shelley_flo 

This is one of the many cool features of Fillout’s advanced forms for Airtable.

Fillout lets you create multiple choice quizzes on an Airtable-specific form with all the features that you may be looking for in a quiz:

  • The quiz self-scores itself on the form itself, and those scores can automatically feed into your Airtable base.
  • Each quiz question can display a different “reply” to the user, depending on whether they got the question correct or incorrect.
  • You can have multiple pages for your quiz, and each page can have whatever number of quiz questions that you would like.
  • You can choose from 9 different types of questions for each quiz question, including  multiple choice, picture choice, checkbox, and more.
  • Since Fillout allows you to update existing Airtable records using a form, you can have users “retake” their quiz and their answers will overwrite their old quiz answers in Airtable. (If you don’t want to overwrite old answers, you can just create a normal form that creates new records in Airtable.)
  • And Fillout offers hundreds of other advanced form features that you can build into your quiz as well. Stuff like PDF viewers, signature capture, payment processing, CAPTCHAs, email/domain/SSO security, etc.

Hope this helps! If you’d like to hire the best Airtable consultant to help you with anything Airtable-related, please feel free to contact me through my website: Airtable consultant — ScottWorld 

Hey ​@shelley_flo,

I fully agree with ​@ScottWorld here. For an in depth comparison between Airtable’s native forms, and Fillout’s forms feel free to check out this article.

Mike, Consultant @ Automatic Nation 

Reply


Terms & Conditions