Converting Text Input to Numerical Value

Need help Database
1

Hi Guys

I am certain there is an easy way to achieve this, but I can’t for the life of me work it out.

I have radio button options that a user can select from:

  • 10 Days
  • 20 Days
  • 30 Days
  • 2 Months
  • 3 Months

I want to assign a day value to each of these inputs as a numeric value:

  • 10
  • 20
  • 30
  • 60
  • 90

I will then use this value in calculations. Is there a quick way to do this?

2

Hi there, @simon12… if it was me, I would likely use an option set to define the radio button options, and I would use an attribute on the option set (with an attribute type of number) to define the numeric value associated with each option.

Hope this helps.

Best…
Mike