Quick Base Discussions

Expand all | Collapse all

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

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

    Posted 05-06-2017 12:35
    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,


  • 2.  RE: How do i turn the text field values into a number?

    Top
    Contributor
    Posted 05-06-2017 12:41
    ToNumber(Left([Answer], 1))


  • 3.  RE: How do i turn the text field values into a number?

    Posted 05-06-2017 12:55
    Thanks very much....