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.
Set which vendor should handle each kind of fault — it'll be auto-suggested when you review a work order.