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 m...
Forum Discussion
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)
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)