FEATURES
PLUGINS
RESOURCES
You can send email to your AppSynergy database by including your database email address in the To, Cc or Bcc lines of any email. Your database email address is YourAccountId@dbmail.appsynergy.com (you can find your Account ID via Help > About).
Email received by your database is stored in a set of three related tables. These tables are visible on the palette in the design window and can be used in your applications as needed.
There are generally two ways to link email to specific records in your database.
First, the most common way, is to have an email address associated with a particular customer record. For example, you might have a table called Customers with an Email_Address column. You could then create a user interface that links that column to InboundMailAddress.Email_Address using normal AppSynergy techniques. This will match the mail address in the Customers table to any email with a matching TO, CC, BCC or FROM email address, which can then link to the InboundMail and InboundMailAttachment tables. Often all the email detail can be placed in a Modal Panel and a button placed next to an email address field that opens that modal panel to show the associated email messages (contact support@appsynergy.com if you need assistance).
Second, less commonly used but highly flexible, is to add a Database Trigger to the InboundMail table. This would allow you to parse subject lines, etc. and create other records in the database to create relationships between an email ID and any other records. For example, a company might use this to parse a support ticket id from the subject line to link a particular email to a particular support ticket id.