Value-Threshold Email Alerts

TableCrafter table builder, connect Gravity Forms, Google Sheets, Airtable, CSV, or JSON data sources
TableCrafter table builder, connect Gravity Forms, Google Sheets, Airtable, CSV, or JSON data sources

Set up per-table alert rules that automatically send an email the moment a Gravity Forms field value crosses a defined threshold, whether the change came from an inline edit, a bulk fill, or an entry duplication.

Pro Only Inline Editing Bulk Fill Entry Duplicate wp_mail
⚠️

Requires TableCrafter Pro. Email alert rules are stripped server-side on the free tier. The "Email Alerts" section will not appear in the table builder without an active Pro license. See Licensing & Activation for upgrade instructions.

Overview

Email alerts give you passive monitoring on any Gravity Forms field that matters to your workflow. Instead of polling a table for changes, you define a rule once, field, operator, threshold, and recipient, and TableCrafter handles the rest. When a user saves an edit and the new value crosses your threshold for the first time, an email goes out immediately via WordPress's native wp_mail() function.

Alerts are scoped per table configuration, not per form. This means two tables built on the same Gravity Forms form can have completely different alert rules, useful when the same form data surfaces in different views for different teams.

Common patterns where alerts add real value:

Creating a Rule in the Table Builder

Alert rules are configured inside the TableCrafter admin builder for each table. Navigate to WordPress Admin > TableCrafter, open the table you want to configure (or create a new one), and scroll to the Email Alerts section below the column list.

Click Add Alert Rule to expand a new rule row. Each rule has four fields:

Field ID

Enter the Gravity Forms field ID that this rule should watch. You can find field IDs in your Gravity Forms form editor, each field shows its ID in the top-right corner of the field block, or in the field settings panel under "Advanced." For example, if your "Quantity" field is field 5, enter 5 here.

ℹ️

Only fields that are mapped as columns in this table configuration will be evaluated at runtime. If the watched field ID is not mapped to any column in this table, the alert rule will never fire.

Operator

Choose the comparison operator from the dropdown. Six operators are available covering numeric comparisons and string matching. See the Operator Reference section below for the full list with examples.

Threshold

Enter the comparison value as a plain string or number. For numeric operators (>, <, >=, <=), enter a number such as 500 or 9.99. For string operators (=, contains), enter the exact text to match, such as Urgent or Approved. Threshold values are sanitized server-side before storage.

Recipient Email

Enter the email address that should receive the alert. To notify multiple recipients from a single rule, enter a comma-separated list: manager@example.com, warehouse@example.com. TableCrafter passes the full list directly to wp_mail() as an array of addresses.

Click Save Table at the top of the builder to persist your rules. Rules take effect immediately for all subsequent edits, no cache flush required.

Operator Reference

The following six operators are supported. Numeric comparisons cast both the stored field value and your threshold to floats before comparing. String comparisons are case-insensitive.

Operator Meaning Field type Example rule
> New value is greater than threshold Numeric Field 3 > 500, alert when order total exceeds $500
< New value is less than threshold Numeric Field 5 < 10, alert when inventory drops below 10 units
>= New value is greater than or equal to threshold Numeric Field 8 >= 100, alert when a score reaches exactly 100 or higher
<= New value is less than or equal to threshold Numeric Field 2 <= 0, alert when a balance hits zero or goes negative
= New value exactly equals threshold (case-insensitive) Text / select Field 7 = Urgent, alert when a status field is set to "Urgent"
contains New value contains threshold as a substring (case-insensitive) Text Field 4 contains overdue, alert when a notes field includes the word "overdue"
💡

For Gravity Forms dropdown and radio button fields, use the = operator and enter the field's stored value (the "value" attribute in your form editor, not necessarily the label shown to users). Check the field's Choices tab in Gravity Forms to confirm the stored value.

Trigger Timing: When the Alert Fires

TableCrafter uses a crossing-detection model, not a steady-state model. This distinction matters: an alert fires only the first time a value moves from one side of the threshold to the other as a result of an edit. It does not fire on every save where the condition happens to be true.

Concretely, this means:

Alerts fire for changes made through any of the three Pro write operations: inline cell editing, bulk column fill, and entry duplication. They do not fire for changes made directly in Gravity Forms admin or via the Gravity Forms API outside of TableCrafter.

⚠️

Bulk fill applies the same value to multiple entries at once. If 15 entries cross the threshold in a single bulk fill operation, the alert will fire once per entry that crosses, meaning up to 15 emails could be sent. Use bulk fill alert rules deliberately, and consider using a targeted per-entry workflow for high-volume tables.

Email Format and Delivery

TableCrafter sends alert emails using WordPress's built-in wp_mail() function. This means delivery depends on your site's mail configuration, the same setup that handles Gravity Forms notification emails, WordPress password reset emails, and any other WordPress-generated mail.

The default alert email includes:

ℹ️

If your site is not configured with an SMTP plugin, wp_mail() falls back to PHP's mail() function, which many hosting environments block or throttle. If alert emails are not arriving, install and configure an SMTP plugin such as WP Mail SMTP and verify deliverability there first.

The email content is not currently template-editable through the admin UI, but the wp_mail arguments are passed through WordPress's standard filter hooks, so developers can intercept and modify them. See Hooks & Filters for available filter points.

Practical Example: Inventory Low-Stock Alert

Suppose you have a Gravity Forms form that tracks product inventory. Each entry represents a product, and field 5 stores the current quantity on hand. You want your purchasing manager to receive an email whenever any product's quantity drops below 5 units as a result of someone updating the table inline.

Here is how to configure this rule:

  1. Go to WordPress Admin > TableCrafter and open your inventory table.
  2. Scroll to the Email Alerts section and click Add Alert Rule.
  3. Set Field ID to 5 (your Quantity field).
  4. Set Operator to < (less than).
  5. Set Threshold to 5.
  6. Set Recipient Email to purchasing@yourcompany.com.
  7. Click Save Table.

Now, when a warehouse team member edits the Quantity cell for a product from 7 to 4 inline in the frontend table, TableCrafter detects that the value crossed the < 5 threshold (it was above before, below after), and immediately sends an email to purchasing@yourcompany.com with the entry details.

If that same product's quantity is edited again from 4 to 3, no second alert fires, the value was already below the threshold before the edit. The next alert for this product would only fire if the quantity is first restored above 5 and then drops below it again in a subsequent edit.

// The rule as stored in the table configuration (internal representation):
{
  "field_id": "5",
  "operator": "<",
  "threshold": "5",
  "email": "purchasing@yourcompany.com"
}

Pro Enforcement and Free Tier Behavior

Email alert rules are enforced entirely server-side. When a table configuration is saved on a site without an active Pro license, any alert rules present in the submitted data are stripped before the configuration is written to the database. This means:

To upgrade to Pro and unlock email alerts along with all other Pro features, visit tablecrafter.com/#pricing or see the Licensing & Activation doc for step-by-step instructions on purchasing, downloading, and activating your Pro license key.

💡

You can add as many alert rules as you need per table, there is no hard limit. Each rule evaluates independently, so a single field edit can trigger multiple alerts if it satisfies more than one rule (for example, if you have separate alerts configured for two different recipient emails watching the same field).