We train service dogs for children with autism. As part of that, we evaluate the dogs at points during their training to give them a "score" to see how they're doing. My challenge is trying to convert a "word" category option to a "number" that can provide a numerical score.
Category: Out (Single Choice, Inline Category Field)
Option 1: Lagger
Option 2: Leader
Calculation: "Lagger" should = 0 and "Leader" should = 1
So the Calculation field should output a 0 or 1 depending on whether the trainer selects Lagger or Leader
I hope I'm making sense!
So first, I'm not sure how to assign the numerics to the Options and then do the calculation. Can this be done in one Calculation field?
Second, I will need another Calculation field that adds up all the Scores (i.e. @OutScore + @BackScore + @GaitScore = TotalScore) which would be the Total Numeric Score
Oh and I train dogs for kids, not write code, so if you could help explain in Captain Dummy talk so I can understand, that would be fantastic!! I have seen a few similar posts in the forum, but not sure I'm getting it.
Please sign in to leave a comment.