TeamDesk Knowledge Base & Support

   Home      FAQ      Forum      Idea Exchange      Ask a Question      My Stuff      Help   
Verification of e-mail notification
An on screen message verifying that an e-mail notification was sent (to..) would be helpful.

Robert Gustavsson
Date Created
1/11/2017 6:35:22 AM
Date Updated
1/11/2017 7:11:45 AM
New Idea
Promoted By
Patricio BustosRobert Gustavsson
cooper collier  1/11/2017 7:11:45 AM
As coincidence would have it, I was just working with notifications as this email hit my mailbox. So I may already have what you need in my brain...

If you are using a rule to generate your email notifications then recording the emails is easy. Create a multiline text box for "email logs" then after the email is sent, just do a record update. Something similar to [emails sent] = Now() & [sent to] &"\n"\&[emails sent]

If you are using the email notifications or there are more emails than a text box can accommodate. You can copy the emails to another table "EMAILS SENT" and link it to the sending table.

Make an "Emails Sent" table. Create a link to the table sending notification from. [emails from] The [email from] column would contain the Record ID of the originating table.

In the originating table make an email formula the formula would be something like.
"your database number"&"+emailnotice+"&[record id]&" The resulting email address would look like this

In your mail table make a rule for new records.
set the filter for records containing tag "emailnotice"
Then create a new record in the"Emails Sent" table.
assign Part([tags],2) to [email from] . This will create the link between the originating table and the emails sent table.
assign other columns as needed

I know my explanation can be confusing. It is always hard to explain without screen shots or an example database. Feel free to email me and I can help you out. it will only take a few minutes to setup. Once you see an example it becomes clear.

Back to Search Results