Sign In

Sending Email to Your Database

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 (you can find your Account ID via Help > About).

Email Tables

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.

Advanced Email Routing

You can set up a personalized email address on your own domain and route it to your database email address.

The following directions are for Google Workspace administrators.

Add Host

Add as a host you can forward mail to:

Add Rule

Now you can add a mail forwarding rule:

Now mail sent to will be routed to your database.

Using the Email Tables

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 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.

Love AppSynergy? Spread the Word...