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?