I have been working with a Report rule that archives records from the main sheet to a dedicated archival sheet. When attempting to update a Report rule by adding additional steps, I ran into an unexpected behavior and just need to confirm the understanding.
The Report rule runs for each row in the table. I added 3 steps to the report. I had expected that each row would run individually through the 3 steps before moving to the next row to be processed. But it appears that all of the selected rows run through Step 1 first, then all selected rows run through Step 2, and so on.
is the later the expected behavior for a Report rule?
That surprises me, but Iโve never tried using multiple rules.
Since it surprises us both, I need to perform a dedicated unit test to confirm my observations unless someone can save me the timeโฆanyone else?
Ok, I created a small Report test and confirmed the order of processing. The report does the following:
In a table with a list of test records (1-20):
Image reflecting actual update order
Observations
***Updated: Additional Observation
The order of processing of the steps is as expected - 2a, 2b, 3a, 3b, 4 - as it would be for a single row. However for a Report, it appears that this order of processing is being applied to the bulk set of rows which was something I hadnโt expected.
Thatโs good to know, and very interesting.
Iโm not sure if this is similar, but Iโll post it anyways:
Some time ago I noticed a case where the Action type โExecute action on set of rowsโ ran the action on multiple rows in parallel, instead of in series one after another. This particular use case required serial execution, which is the only reason I figured that out, and thus had to setup a sort of back and forth loop (kind of similar to Steveโs โlooping with actionsโ tip).
Iโm thinking your case with the multi-step and multi-row Reports is perhaps also showing signs of parallel processing.
Yes, agreed on the parallel processing.
User | Count |
---|---|
39 | |
28 | |
23 | |
23 | |
13 |