ChrisG

Assign a numerical value to text

Discussion created by ChrisG on Apr 17, 2012
Latest reply on Apr 19, 2012 by ChrisG

Dear FMP Guru's

 

I have a questionnaire where only fixed values can be entered using radio buttons. There are 5 values per field. Each value gets a score beginning with 1 and ending with 5.

What I want to do is convert all the answers to the correct numerical value and then add it all up. I am trying to avoid using a case statement as it becomes very cumbersome.

I was thinking of doing something like this:

 

List of possible answers:

A = 1; B = 2; C = 3; D = 4; E = 5

 

Then add up all the fields

Sum ( TextField1; TextField2; TextField3; TextField4; TextField5 )

 

Answer = 15

 

If TextField1 = A; TextField2 = B; TextField3 = C; TextField4 = D; TextField5 = E

 

Is it possible to do something like this?

 

Thank you

 

Chris G

Outcomes