Sent email for less then x rows

Question

Hi,

I would like to get an email if the number of rows is lower then 400000. For now, I have set an email on 0 rows. I have made an event  (send an email on the error) to achieve this.

However, I would also like to get an error when a number of rows is < 400000. The workflow should be finished I would like just to get information

cplewis90 · Accepted Answer

Hello @Andrzej,

One way you could achieve this is through a batch macro containing a condition tool and a detour tool. The condition tool would update the detour. Depending on how you set it all up you can pass the number of records to the macro and have the detour go to a side with an email tool a certain direction (left or right) and nothing on the other side.