WORKATO FOR LOGGING EMAILS
Quick Base allows users to easily set up notifications, subscriptions, and reminders. These tools are great for designing workflows, improving communication with internal and external users, and keeping abreast of changes in an app. The shortfall of notifications, subscriptions, and reminders is there is no way to log the emails that have been sent to users – there is no audit trail. Furthermore, if an invalid email address is entered in an email field in Quick Base and that field is the field the email is addressed to, the notification, subscription, or reminder will not be sent. The same logic holds if you input specific emails into a notification, subscription, or reminder; if the email address is invalid, it will not be sent. Unfortunately, there is no native functionality in Quick Base to inform you of an invalid email address.
Workato can be used to overcome the invalid email address and email logging shortcomings from Quick Base. Recipes can be built to send emails to internal and external users that mimic Quick Base notifications, subscriptions, and reminders. With Workato, sent emails can be logged in two different ways.
Both solutions above solve Quick Base’s limitation of catching an invalid email address. If Workato is unable to complete a recipe, it sends an error email to the Workato administrator. From the Workato error email, it is easy to find the invalid email address in Quick Base and correct the data entry error.
Workato also enhances Quick Base's native ability to send reports. In both solutions, Workato can send reports from Quick Base, Dropbox, etc. can be added as attachments in the email.
If you are interested in learning more about non-native Quick Base functionality, check out the article, Google Maps for Data Visualization.
Author: TJ Lawless (firstname.lastname@example.org)
Date Submitted: 1.4.18