Skip to main content
Question

How do i turn the text field values into a number?

  • May 6, 2017
  • 0 replies
  • 24 views

Hi there,

I have a customer satisfaction app and I have a number of questions with multiple choice text fields with values like this:

5-Extremely professionally
4-Very professionally
3-Somewhat professionally
2-Not so professionally
1-Not at all professionally

I need to take the first character and turn it into the number above so I can calculate my ratings.

What's the best way of handing this?

Thanks,
This topic has been closed for replies.

  • Registered
  • May 6, 2017
ToNumber(Left([Answer], 1))

  • Author
  • Registered
  • May 6, 2017
Thanks very much....