Create a multiple choice quiz that self scores

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