Scoring Database Choices


#1

I’m like to score someone’s responses to a form, but don’t know where I’d start.

For example, I have a row with three choices: rock, pop, and jazz. Depending on the choice you make on the form it then gives you a score. Say I choose rock and it gives me a score: ‘cool’.

I’d then like to build on that with other choices. So the form might ask if I prefer CDs or records. I choose records, and it gives me an updated score linked to my original choice. I’m now ‘very cool’.

Does that make sense? And is it possible?


#2

I think you just need a complex formula with a lot of IF() functions: https://support.airtable.com/hc/en-us/articles/221564887-Nested-IF-formulas


#3

That’s really useful, thank you. It’s going to take some time to get these formulas right!