I am wondering if there is a way to assign a numerical value to a text answer. Here is an example of what I am trying to do:
A survey is designed for inspectors to fill out. As they answer questions like,
"What is the distance to the nearest fire extinguisher?"
1: 10 ft.
2: 50 ft.
3: 100 ft.
I would like to assign a numerical value to those answers so 1 point for 10 ft., 5 points for 50 ft., and 10 points for 100 ft. At the end, I would like to be able to tally up the results of my survey with a total score for every answer to a question and be able to assign a risk value that the inspector can both see and submit in the form.
Is this possible?