How to Send an Alert When a Table Field Exceeds a Threshold

Updated July 2026 • 6 min read • By Fahad Murtaza • By Fahad Murtaza

Waiting to notice a critical value buried in rows of data is how problems slip through the cracks. TableCrafter's Pro email alert system lets you define a threshold on any numeric field and fire an automatic notification the moment an entry crosses it, no custom code, no third-party automation tools required. WordPress powers 43% of all websites globally (W3Techs, July 2026), and TableCrafter bridges the gap between the data you collect and the tables your users need to see, no custom PHP, no dashboard access required for viewers. The free version on WordPress.org supports CSV, JSON, Google Sheets, and Excel. Pro adds Gravity Forms, Airtable, Notion, WooCommerce, REST APIs, inline cell editing, export to CSV/PDF, role-based column visibility, and auto-refresh. Every table embeds on any page with a [tablecrafter] shortcode or the native Gutenberg block. WooCommerce powers over 6 million live online stores (BuiltWith, 2026).

What You Need Before You Start?

Threshold alerts are a Pro feature. Before configuring one, confirm the following are in place:

• TableCrafter Pro is installed and activated on your WordPress site.
• You have at least one published table connected to a Gravity Forms data source. Alerts can reference any numeric column in that table, including Number, Calculation, Rating, or any field whose values are consistently parseable as numbers.
• Your WordPress site can send email. TableCrafter uses wp_mail() under the hood, so if your hosting blocks outbound mail you will need an SMTP plugin such as WP Mail SMTP before alerts will deliver reliably.
• You know which field ID in Gravity Forms corresponds to the column you want to watch. You can find this under Forms → the form name → Edit → click the field to see its Field ID in the right panel.

How Does Step 1, Open the Table Builder for Your Target Table Work?

Navigate to TableCrafter → Tables in the WordPress admin sidebar. Find the table whose data you want to monitor and click Edit. If you have not created a table yet, click Add New, select your Gravity Forms data source, and publish it before continuing, the alert configuration lives inside the table settings, not as a global plugin setting.

Inside the table builder you will see a tabbed interface. The tabs typically include Columns, Filters, Permissions, and Alerts. Click the Alerts tab.

The column mapping you define here is stored as a JSON configuration in the WordPress database. You can export this configuration using the TableCrafter export tool and import it to another table or another site. This is useful when replicating a table layout across multiple pages or when migrating a table to a staging environment for testing before going live.

How Does Step 2, Add a Threshold Alert Rule Work?

On the Alerts tab, click Add Alert. A rule card expands with the following fields:

• Alert Type, select Field Threshold from the dropdown. Other options include New Entry and Entry Updated, but threshold monitoring requires this specific type.
• Column, pick the column that contains your numeric data. The dropdown is populated from the columns you have already configured on the Columns tab. If a column is missing here, go back and add it first.
• Condition, choose the comparison operator: Greater than, Greater than or equal to, Less than, Less than or equal to, or Equals. For a typical "exceeds" alert, use Greater than.
• Threshold Value, enter the numeric boundary. For example, 1000 to alert when a mileage column exceeds one thousand miles, or 0.95 for a ratio column.
• Recipients, a comma-separated list of email addresses that should receive the alert. You can mix WordPress user emails and external addresses.
• Subject, the email subject line. Supports merge tags such as {entry_id}, {field_value}, and {form_title}.
• Message Body, freeform text with the same merge tag support. Keep it actionable: include a direct link to the entry if your workflow calls for immediate review.

A fully configured rule might look like this:

Alert Type:       Field Threshold
Column:           Total Miles
Condition:        Greater than
Threshold Value:  5000
Recipients:       dispatcher@company.com, manager@company.com
Subject:          [Alert] Total Miles exceeded {field_value} on entry #{entry_id}
Message:          Entry #{entry_id} in {form_title} recorded {field_value} miles,
                  which exceeds the 5,000-mile threshold.
                  Review it here: {entry_url}

How Do Step 3, Save and Verify the Configuration Work?

Click Save Table at the top right of the builder. TableCrafter writes the alert rule to the table's stored configuration in the WordPress database.

To confirm the rule is active without waiting for real data to cross the threshold, you can create a test entry in Gravity Forms directly (Forms → the source form → Entries → Add New) with a value that intentionally exceeds your threshold, then immediately edit that entry through the TableCrafter frontend using the inline editor. The alert should fire within seconds.

TableCrafter re-fetches this data on each page load by default. If your data source updates infrequently and your site has significant traffic, enable the built-in caching option in the table's Performance tab. This stores the fetched data for a configurable number of minutes and serves it from WordPress transients, reducing API calls to the source and improving page load time for visitors.

How Does Step 4, Embed the Table with the Shortcode Work?

If you have not already placed the table on a page, add it with any of the three equivalent shortcodes TableCrafter supports:

[tablecrafter id="42"]
[tablecrafter id="42"]
[tablecrafter id="42"]

Replace 42 with your actual table ID, visible in the URL when you edit the table (post=42). All three shortcodes resolve to the same handler; the aliases exist for backward compatibility with earlier plugin versions.

Once embedded, authorized users editing a cell in the watched column will unknowingly (or knowingly) trigger the alert pipeline whenever their saved value crosses the configured boundary. From their perspective the edit saves normally, no extra confirmation or modal appears.

The configuration you set here applies to every visitor who loads a page containing this table, regardless of whether they are logged in. Role-specific overrides for columns and rows are a separate layer and do not replace these global display settings. Apply global settings first, then add role restrictions as needed for tables that serve multiple user types.

How Does Combine Alerts with Role-Based Permissions Work?

A common pattern is to restrict which roles can edit the threshold column while keeping the data visible to all. For example, drivers on a load tracking table might see their mileage figures but only dispatchers can update them. This prevents accidental alert spam from untrained users entering test values.

Configure this under the Permissions tab of the same table builder:

• Table-level permissions control who can view the table at all.
• Column-level permissions control which roles see or can edit a specific column. Set the Total Miles column to Edit for the dispatcher role and Read Only for the driver role.

Both table-level and column-level permission rules are Pro features. The Free tier renders tables as read-only for all visitors, so no inline editing, and therefore no change-triggered alerts, are possible on the free plan.

How Does Troubleshooting Alerts That Do Not Fire Work?

If you followed the steps above but emails are not arriving, work through this checklist in order:

• Check your spam folder. WordPress default mail often triggers spam filters. Configure an SMTP plugin with authenticated sending (SendGrid, Mailgun, etc.) to improve deliverability.
• Confirm the edit path. Only edits made through the TableCrafter inline editor fire alert hooks. Gravity Forms admin edits bypass the alert system entirely.
• Verify the column type. If the column stores text that happens to look numeric, the threshold comparison may fail silently. Ensure the Gravity Forms field type is Number or a Calculation field.
• Check the threshold value format. Enter thresholds without currency symbols or commas. Use 1500 not $1,500.
• Re-save the table. Occasionally a caching plugin will serve a stale table configuration. After making changes in the builder, save the table, then flush any page cache (NitroPack, WP Rocket, etc.) on the page hosting the shortcode.
• Inspect the browser console. When a cell is saved, TableCrafter posts to wp-admin/admin-ajax.php. A failed nonce check or a PHP error during the save will return a non-200 response and prevent the alert from being queued. Open DevTools → Network tab → filter by admin-ajax → look for error responses.