How to report validation failures?

Hi @DoStep and welcome to the community!

Here is a simplified example project:

ValidateRows.morph (6.0 KB)

Its workflow is as follows:

  • Use the “Rule” action to create a column with validation errors. Note that only the first found error will be added to that column.
  • Use the “Derive table” action and filters to separate valid and invalid rows
  • Use the “Derive table” action in the “On condition” mode to handle invalid rows (this example
    stores invalid rows in a CSV file and sends it via email).

Please refer to the following tutorial for more details on the “On condition” mode:
https://easymorph.com/learn/conditional-workflows.html