Can you add values in multi-line text fields?

  • 0
  • 1
  • Question
  • Updated 7 months ago
  • Answered
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.
Photo of Luisana Cardenas

Luisana Cardenas

  • 174 Points 100 badge 2x thumb

Posted 7 months ago

  • 0
  • 1
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
Do you in fact mean a Multi-select field type?
Photo of Luisana Cardenas

Luisana Cardenas

  • 174 Points 100 badge 2x thumb
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?
Photo of QuickBaseCoach App Dev./Training

QuickBaseCoach App Dev./Training, Champion

  • 51,256 Points 50k badge 2x thumb
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)