Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Form with scoring system

620 2
Showing results for 
Search instead for 
Did you mean: 

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 2

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