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