Discussions

Expand all | Collapse all

Can you add values in multi-line text fields?

  • 1.  Can you add values in multi-line text fields?

    Posted 04-17-2018 22:22
    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.


  • 2.  RE: Can you add values in multi-line text fields?

    Posted 04-17-2018 22:23
    Do you in fact mean a Multi-select field type?


  • 3.  RE: Can you add values in multi-line text fields?

    Posted 04-18-2018 17:29
    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?


  • 4.  RE: Can you add values in multi-line text fields?

    Posted 04-18-2018 18:28
    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)