We had students respond to a number of self-reflection questions, and their answers are in table 1. Table 2 uses lookup fields to pull in those answers, and then a formula field to attempt to score them.Each question has 5 answer choices, and each a...
Hoping someone can guide me with setting up a formula to score tests that are reported on another table.Here's the current setup:Table 1 - record of all test takers by session ID, including fields for all of their question responses.Table 2 - questio...
Hoping someone can help figure out the best way to set this up.We have students taking various assessments that range in length from apron 20 - 100 questions. The assessments feed into a table with the submission ID as the primary record field, and t...
Adam solved multiple problems we were having getting Airtable to fit into our workflow, and when we then reached out to him about another project, he talked us into a more efficient and elegant solution that wouldn't require any paid hours from him a...
Thanks for the suggestion, @Ben_Young1 ! I wasn't familiar with SWITCH - that is so much easier to read, I will definitely use that moving forward! Unfortunately, the formula you posted has the same results for me - all answers are scored EXCEPT -...
I have a question on a very similar issue. Created an automation that finds information about a record on one table, and then writes that information to a field on another table. The trigger is when a record matches conditions, or more specifically...
