Form with scoring system

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?

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)

1 Like

Hi, thanks :slight_smile:

I’ll try this one