I am looking for recommendations on how to handle the following:

 

1.  I have a form that collects inspection data.

 

2.  Inspectors will check anywhere from 1 to 15 boxes per each shipment recieved.

 

3.  To keep the "size" of the inspection form on the manageable size, I have set the form up so that a user will enter data for "one" box at a time, submitting the data for "one" box and repeat entering the additional boxes to be checked.

 

4.  I then set up a "view" where the data is grouped by the "purchase order".

 

5.  If the data collected is "flagged" with the issue, I need an email to be sent to specific email address.

 

6.  The problem I have is what is the best way to consolidate the various "Box" data  unique to a "purchase order", run a check for issues, if an issue is observed an email is sent out.

 

7.  Can I accomplish this task in Zoho Creator or will I have to use Zoho Report?  One thought I have is to send the raw data to Zoho Report, set up specific reporting that will flag a "purchase order" that has an issue sending out an email.