Validate Test Answers with Ref Table

Hi,

I’m assembling a solution where test questions are submitted via a form and those answers (Rows) are referenced against an answer key table. My question is what is the best approach to having the answers ‘auto-grade’ each response based on the answer key? A virtual column ‘Correct’ with yes/no which would be driven by an expression? Then I like to show the number of correct or ‘TRUE’ statements in each row (individual).

Michael

Is the question itself a Ref field?

Yes