Skip to main content

Scoring Database Choices

  • July 2, 2018
  • 2 replies
  • 40 views

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?

This topic has been closed for replies.

2 replies

Forum|alt.badge.img+17

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


  • Author
  • New Participant
  • July 3, 2018

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


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