Trigger an Action to occur when a record is Added, Modified or Deleted!
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 Quick Base when fired. We take advantage of the Quick Base 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 Quick Base application.
-
Create an Audit of events that take place within your Quick Base application.
-
Upload files to Quick Base from an email message, good for modile device uploads
Webinar recording...
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 Quick Base
Send an email message to Quick Base and have the info in the message inserted into an existing Quick Base table:
Click to demo Send Email to Quick Base
Send an email message to Quick Base that has files attached to it and insert the files into file attachment fields in Quick Base:
Click to demo Send Email to Quick Base with File Attachments
Send a TEXT message to Quick Base to pull information out of Quick Base and send it back to the person that sent the text.
Click to demo Send TEXT to Quick Base