Hello,
I'm trying to build a workflow that will perform some basic validations and output the results. Using the screenshot attached, assume each of the 3 fields were being checked for a valid value (via a formula tool). Those values in red text are to denote an error. My desired output would be to display a new "Error" column where it would inform which column had an error. In this display, the input record has two errors in two columns respectively. I would like for the output to parse this into two separate rows as shown. Any suggestions on how to accomplish this?
Thanks in advance!
What's the error criteria? When Field1 is an 'X' and, additionally, when Field2 is a 'Y'.
For example, let's assume Field 1 is a required field and the user forgets to enter a value (so Null). Then I would want the Error column to indicate the column where the error occurred. I kept my original visual simple but I also intend to have another output column - next to the Error column - that will be labeled Error Type where it will reveal the type of error (i.e. "Required Field").
User | Count |
---|---|
19 | |
14 | |
13 | |
9 | |
8 |