Applies to Consumable and Part entries only, since these are the ones tied to a meter count.
Compares each part's actual page run against its rated shelf life. Positive variance means it outlasted the rating; negative means it wore out early.
One link per client — it works for all of their machines, so there's no need for a separate link per copier.
The trigger runs daily and sends meter reading request emails to all clients on the 1st business day of each month. If the 1st falls on a weekend, emails go out on Monday.
1. Open your Apps Script project
2. Change the function dropdown to
setupTrigger3. Click ▶ Run
4. Done — reminders will fire automatically every 1st business day
removeTrigger from the Apps Script editor the same way.Send a test reminder email to all clients right now, regardless of the date. Make sure client emails are assigned to machines first.
Uses the same 1st-business-day trigger above — no separate setup needed. On that day, if any printery machine with a counter (Pages or Impressions type) is missing its reading for the month, this email goes out listing what's still pending, grouped by department. Embroidery-type machines are never included since they have no reading to chase.
Send a test reminder right now, using this month's data, regardless of the date. Save the email above first.
Set which vendor should handle each kind of fault — it'll be auto-suggested when you review a work order.