How to get data out of repeating group?

data1 · 2025-02-18T08:16:51.881Z

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:

image585×373 70.4 KB

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?

Qaiser · 2025-02-18T09:37:16.432Z

How it’s currently showing in each cell, it is from a state/api call?

data1 · 2025-02-18T09:41:06.242Z

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.

Qaiser · 2025-02-18T09:43:14.715Z

What’s the datasource of these errors?

data1 · 2025-02-18T09:56:18.814Z

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:

image1039×324 33.2 KB

This other one evaluates whether the same course has already been taken earlier:

image1034×345 34.5 KB

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:

image719×440 32.6 KB

What matters is there’s a number in the latter group, and I want to sum that number up a the parent level.

homyhservices · 2025-04-09T14:27:25.377Z

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.’