Save the date! Join us on October 16 for our Product Ops launch event. Register here.
Dec 14, 2020 09:23 AM
Hello scripting experts
I’m busy moving a script for scoring tests (currently built in Python) into Airtable. The answers are being submitted to Airtable fields via a form. It would be easy enough to do in an Excel-type formula ( i.e. if(answer1=“X”,1,0) +if(answer2=“Y”,1,0), but I know there are more challenges to come so I am hoping to upskill a little bit in JavaScript (I would not consider myself a coder, I dabbled a little bit in Python about 5 years ago but that’s about it).
I instead want to pull the values that are being submitted in the table into an array, and check them against an answer key. (I want to do this in the same table)
Taking the first block of 7 questions, I feel like the answer might look something like this, but missing a few (big) pieces
//I've created a field to receive the test scores.
let table = base.getTable("Test Input");
let targetfield = "Test Scores";
var score1 = 0
let submitted_answers = [
//this is the array where I want to pull in the seven answers from fields in my "Test Input" table
]
var answer_key = [
["C"],
["C"],
["B"],
["B"],
["F"],
["D"],
["D"]
]
for (var i = 0; i = 7, i++ {
if submitted_answers[] == answer_key[]
score1++
}
targetfield = score1 / 7
It’s not very pretty, but I hope it makes sense :slightly_smiling_face:
Dec 16, 2020 10:45 AM
Welcome to the Airtable community!
The Airtable scripting environment is a great place to practice JavaScript skills. It isn’t such a great place to learn JavaScript from the ground up. If you aren’t comfortable with JavaScript, I suggest learning the basics of JavaScript first, then add in Airtable concepts. If you are already comfortable with JavaScript, examine the sample scripts that Airtable provides to learn the Airtable specific tasks…
Things to do in JavaScript:
Airtable specific things to do:
Once you can do all the individual parts, then combine them for your entire script.
Best of luck in your coding journey!
Dec 22, 2020 08:18 AM
Thanks @kuovonne - guess I’ll have to do some JS on the side before getting back to this. Appreciate the response!