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