We have an issue where some users accidentally enter a non-numeric value in a custom field. This has resulted in downstream issues with some of the python/API scripts that we run to load data into projects.
I'd like to create an exception report where I could check if the custom field has a non-numeric value and where the field is not blank. I reviewed the list of expressions available in WF and didn't see anything that would work.
Anyone have any creative suggestions? Thank you!
Topics help categorize Community content and increase your ability to discover relevant content.
I often refer to this Calculated data expressions reference in such cases, and for your Is This Numeric challenge, can suggest a few options:
Thanks Doug. On the last suggestion, can you please elaborate? Do you mean format the custom form field as a Number? Anything else I can do to reject non-numeric input?
Think I got this figured out, but another way. I created another calc field that checks the LEN() of "My Field". If length of the data in "My Field" is <> 12, then it returns "Error". Now I can report on the "Error" field separately in a report.
Glad you got something worked out. What I was referring to was the data type of the Custom Parameter: when you create it, you could choose "Number" instead of "Text" to ensure that only numbers are allowed to be entered.