​
What is a QB Trigger?
"Code that is automatically executed in response to specific events that occur on a particular table."
A QB Trigger can be fired when a record is Added, Modified or Deleted. The QB Trigger can be designed to perform one or many actions against your QuickBase when fired. We take advantage of the QuickBase Email Notification functionality to fire "QB Triggers".
Example
When a record is modified, a QB Trigger can be designed to read the edited record, download the file attachment and email it to the email address stored in the "Email" field on the edited record.
Benefits
​
-
Email File Attachments to your users, you can even send them to email
addresses that do not have access to your QuickBase application.
-
Create an Audit of events that take place within your QuickBase application.
-
Upload files to QuickBase from an email message, good for modile device uploads
QB Triggers
Trigger an Action to occur when a record is Added,
Modified or Deleted!
More Demos below...
Here are some other examples of what Triggers can do...
Enforce Referential Integrity meaning, if I delete a master record, make sure all child, and grandchild record(s) get deleted as well:
Click to demo Enforce Referential Integrity in my QuickBase
Send an email message to QuickBase and have the info in the message inserted into an existing QuickBase table:
Click to demo Send Email to QuickBase
Send an email message to QuickBase that has files attached to it and insert the files into file attachment fields in QuickBase:
Click to demo Send Email to QuickBase with File Attachments
Send a TEXT message to QuickBase to pull information out of QuickBase and send it back to the person that sent the text.
Click to demo Send TEXT to QuickBase