Skip to main content
Question

Can you add values in multi-line text fields?

  • April 18, 2018
  • 0 replies
  • 46 views
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.
    This topic has been closed for replies.

    Do you in fact mean a Multi-select field type?
    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?
    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)
    Terms & ConditionsAccessibility statement