Yes, this can be done without buying 80 more licenses.
1. Make a table of technicians or hopefully you already have such a table and I assume it has their email address.
2. Make a special form on that table called Tech Daily Routes.
3. Put a Report link field on the form of their routes. ie put the report link field on the form and set the report link field to be a report of Today's routes.
4. Put a field on the Technicians form called [Date to trigger email].
5. Set up an
OPEN type email Notification. Must be type = Open. Set the form to be used to be the special Daily Routes form. Set the trigger field for the open Notification to be to be the [Date to trigger email].
Now all you need to do is run a report of the technicians by opening the first one in edit mode and then Save and Next your way down the report putting "T" for today in hat date field. It will fire the Notification. Note that you cannot use grid edit.
When you have that all working nicely and get tired of the one by one editing, then build a Pipeline to run every day and update that field to "today", thus firing all the emails automatically.
------------------------------
Mark Shnier (YQC)
Quick Base Solution Provider
Your Quick Base Coach
http://QuickBaseCoach.commark.shnier@gmail.com
------------------------------
