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
Rebecca
11/01/2021, 2:57 PM
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
Luis
11/01/2021, 3:08 PM
It can be one number or more. So creating multiple fields would not work.
Luis
11/01/2021, 3:08 PM
But I'll try the trim formula. Thank you!
k
KevinJ of Kansas
11/01/2021, 3:42 PM
why not give the users a numeric field that they can just type the math they want into it anyways?
r
Rebecca
11/01/2021, 4:16 PM
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
Luis
11/01/2021, 10:09 PM
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 /.