Scoring system where number of criteria scored is ...

[Mayla_Granados]

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?

[Russell_Findlay]

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)

[Mayla_Granados]

Hi, thanks :slightly_smiling_face:

I’ll try this one