Forum Discussion

LuisanaCardenas's avatar
LuisanaCardenas
Qrew Trainee
7 years ago

Can you add values in multi-line text fields?

I need to add values in a couple multi-line text fields. They are not numeric fields so I'm finding it hard to do this. Is there a solution? All options in the fields are numeric but we've made it a multi-line field so that they are forced to choose from a set of codes.
Formulas and functions
  • LuisanaCardenas's avatar
    LuisanaCardenas
    Qrew Trainee
    7 years ago
    Sorry about that, it's actually a multiple choice field, where the options are numeric. I would like to add a few of these fields to get a total. That's one case, then there is another case where I have formula-numeric fields(converting letter choices to numbers) that I want to add for a total as well. Does this make sense?
  • QuickBaseCoachD's avatar
    QuickBaseCoachD
    Qrew Captain
    7 years ago
    you can convert text to numbers using ToNumber([my text field])

    That will only work if the text looks like numbers, but it is OK to have leading zeros.

    If you need to convert pure text fields to numbers it would be a formula like

    Case([My multiple choice field],
    "Really Happy", 5, 
    "Sorta Happy", 4,
    "Ambivalent", 3,
    "Grumpy", 2,
    "Don't Even Ask", 1)