I have a free-form text field with numerical value...
# general
l
I have a free-form text field with numerical values separated by a /. Example: 15/20/40 What I need to do is sum these values and store it in another custom decimal field OR show it in a formula field in a saved search. In this case, the value should be 75 (15+20+50). Is this possible via a saved search or only through scripting/workflow?
r
you could do it in a saved search with formulas and trim. But if anyone has entered the data incorrectly the formula is going to fail. I never ever store numerical values as a text field. Can you convert to the 3 unique fields instead?
l
It can be one number or more. So creating multiple fields would not work.
But I'll try the trim formula. Thank you!
k
why not give the users a numeric field that they can just type the math they want into it anyways?
r
Yeah a free form text field that will always be a problem if you are trying to do math on the value. What if the user types “abd123zuy” instead of what you are expecting?
l
The free-form text field must be shown in the printed PO. The users do not want to retype the numbers to sum them in another custom field. Users are aware that the numbers must always be separated by a /.