Is is possible to create a conditional "send email with new data" event?
Scenario is as follows:
- Application is a simple leads generation database
- Leads table is joined to the SalesRep table which contains the SalesRep email address
- When a new lead is added or edited, user would like "the option" of sending an email to the SalesRep with the lead data.
I've thought of two ways to address this:
- create a second "Save" button on the bottom of the page. The second button might say "Save and eMail SalesRep" which is linked to the event. Could require a lot of manual page editing (?)
OR
- create a field (displayed to the user as a checkbox) in the Leads table with the caption "eMail SalesRep ?" and evaluate this field in the "send email with new data event." The only caveat is that I'd like the value in this field reset (i.e. not left checked) the next time a user opens the record to edit it.
Any suggestions as to the best way to accomplish this?
Many thanks -
Rick