I am not able to find the solution for this:
We are doing a numnber of vlaidations on each row of the repeating group. Then we count errors for each row. At the top, we want to do a sum of the errors:
None of this is in the database, because it is a previous of pontential errors before running a workflow.
I looked into the orchestra and active cell plugins, but they don’t seem to help here. How can I do the sum of error counts from each row and display those in the top error card?
How it’s currently showing in each cell, it is from a state/api call?
Now, each cell has one group per validation with a yes/no value per error. It validates the error as an expression returning yes/no and shows the text based on the yes/no value.
Then there’s a summary count of errors per cell as the sum errors yes/no formatted as numbers 1 or 0 repsectively.
What’s the datasource of these errors?
It’s a bunch of complex validations.
Example:
This second validation in the list of possible errors will evaluate whether the current date is within the cell’s allowed enrollment dates:
This other one evaluates whether the same course has already been taken earlier:
For each validation, when the group evaluates to a yes, it will be visible to reveal the error text.
Then, the counter will look up each error text’s yes/no and convert that to a sum of numbers:
What matters is there’s a number in the latter group, and I want to sum that number up a the parent level.
Use the ‘RG Extractor’ plugin by mike@scheduler.ai, then place the Transmit element inside the RG and paste the ‘error preview count per section’ expression in its first field. After that, place the Receive element anywhere outside of the RG, and set its first dataType 1 field to ‘number’.
Now, you can pull the sum of errors from each cell by simply setting the following expression in a text element: ‘Receive A, column 1: sum.’
This topic was automatically closed after 70 days. New replies are no longer allowed.
