Skip to main content

Form with scoring system

  • May 4, 2021
  • 2 replies
  • 104 views

Hi everyone!

I am using Airtable to have my applicants fill out their information. Now I am thinking to use it for test (multiple choice question type). Can I set a scoring system in the airtable? That way I don;t have to check the answers manually if they select the correct one?

2 replies

Forum|alt.badge.img+16

Perhaps for each question using a formula like if or switch that scores each column and then doing a sum of the total of correct answers.

If and switch - if you have responses a,b, where a is correct you would effectively have a score field if(source =a,1,0)


  • Author
  • New Participant
  • May 5, 2021

Perhaps for each question using a formula like if or switch that scores each column and then doing a sum of the total of correct answers.

If and switch - if you have responses a,b, where a is correct you would effectively have a score field if(source =a,1,0)


Hi, thanks :slightly_smiling_face:

I’ll try this one