How to Fill a Column Across Multiple Rows at Once in TableCrafter

Updated July 2026 • 6 min read • By Fahad Murtaza

Updating a status field across 50 rows one click at a time is the kind of repetitive task that makes people wish they had a spreadsheet instead of a database. TableCrafter's bulk column fill feature brings that spreadsheet capability to your Gravity Forms data: select the rows you want to update, choose a column, type or select a value, and apply it to every selected row in a single operation. 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, and no per-row limits on the free tier. 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. CSV remains the most universally supported data exchange format, used by 91% of business intelligence tools (Gartner, 2025).

What Bulk Column Fill Does?

Bulk column fill is an extension of inline editing that applies one value to a specific field across multiple Gravity Forms entries simultaneously. Instead of opening cells one at a time, you select a set of rows using checkboxes, invoke the bulk fill action, specify the target column and value, and confirm. TableCrafter fires one API call per selected entry in parallel and updates the display when all writes complete.

The feature requires the table to have inline editing enabled Pro and the target column to have Allow Inline Edit toggled on.

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 Do I Use Bulk Column Fill?

1. Enable row selection. In the table builder under Display Options, turn on the Row Checkboxes toggle. This adds a checkbox column as the leftmost column in your table. Save the table.
2. Load your table on the front-end page where you placed the shortcode.
3. Select rows by clicking the checkboxes on the left side of each row you want to update. A count indicator at the top of the table (e.g., "12 rows selected") updates as you check rows. To select all visible rows at once, check the checkbox in the column header row.
4. Open the bulk actions bar. Once at least one row is selected, a bulk action toolbar appears above the table. Click the Fill Column button in this toolbar.
5. Choose the target column from the dropdown in the bulk fill dialog. Only columns with Allow Inline Edit enabled appear in this list, read-only columns are not valid bulk fill targets.
6. Enter or select the new value. The input type matches the field type: a text input for text fields, a dropdown for choice fields, a date picker for date fields. For dropdown fields, all options from the original Gravity Forms field are available.
7. Confirm the fill. Click Apply to [N] Rows where N is your selection count. A confirmation prompt appears: "You are about to update [column name] in 12 entries. This cannot be undone from the table. Continue?" Click Confirm.
8. Wait for completion. A progress indicator shows how many updates have completed. When all writes finish, the table re-renders the affected rows with the new values and removes the checkboxes from selection state.

What Are the Real-World Use Cases?

Approving a Batch of Applications

A hiring manager is reviewing 30 job applications submitted through a Gravity Form. She filters the table to show applications from qualified candidates, selects all 30 visible rows with the header checkbox, and uses bulk fill to set the Status column to "Approved for Interview". What would take 30 individual status changes takes 10 seconds.

Assigning a Category to Imported Entries

A data import created 150 entries with a blank Category field. The entries need to be categorized as either Residential or Commercial. The operations lead filters the table to show the first set of addresses, selects them, fills the Category column with "Residential", clears the filter, selects the remaining set, and fills with "Commercial". Two bulk fills handle 150 entries.

Setting a Price Update Across Products

A product catalog stored in Gravity Forms entries needs a price increase applied to all entries in the "Hardware" category. Filter the table by category, select all, fill the Price column with the new value. Done in one operation rather than 40 individual cell edits.

Marking Rows Reviewed

An auditor works through a table marking entries as reviewed. Rather than clicking a checkbox per row after reviewing each one, she reviews 20 rows, selects all 20, and fills the Reviewed column with "Yes". She then moves to the next 20. Batch confirmation is faster than per-row confirmation when the review logic is being tracked mentally rather than in the table itself.

How It Compares to One-by-One Editing?

For a concrete comparison, consider updating 50 rows individually using inline editing:

• Click cell → select value → Tab → repeat = roughly 4 interactions per row
• 50 rows × 4 interactions = 200 interactions, approximately 3 to 4 minutes at a fast pace

With bulk column fill for the same 50 rows:

• Check header checkbox (select all) → click Fill Column → select column → enter value → confirm = 5 interactions total
• Time: approximately 15 to 20 seconds

Bulk fill is not always the right tool, if each row needs a different value, one-by-one editing is the only option. But for the common case of applying one value across many rows, the time savings are significant.

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 Combining Bulk Fill with Filters Work?

The most powerful pattern is using filters to narrow the visible rows before selecting and filling. Filter by a date range, a status value, a category, or any other filterable column, then select all filtered rows (header checkbox selects all visible rows, not all rows in the table), and apply the bulk fill. Only the filtered-visible rows are selected, hidden rows are unaffected.

This filter-then-fill pattern effectively lets you run conditional bulk updates: "Set Status to Closed for all entries where Date is before 2025-01-01." You apply the date filter, select all, fill Status. The filter provides the conditional logic; the bulk fill provides the update.

What Are the Next Steps?

Bulk column fill pairs naturally with the filter feature for conditional updates and with role gating to ensure only appropriate users can perform bulk operations. For even larger batch updates involving data not present in the current UI, consider using Gravity Forms' import feature alongside TableCrafter's display layer rather than performing bulk fills manually.

If the expected behavior does not appear after saving, clear any page or object caches active on your site. Caching plugins such as WP Rocket, W3 Total Cache, or LiteSpeed Cache may serve a stale version of the page that predates your configuration change.

This step completes the connection between your data source and the TableCrafter table engine. Once saved, the plugin caches the connection credentials in the WordPress options table and uses them on every subsequent page load. If you update the source configuration later — for example, rotating an API key or changing a sheet URL — return to this step, enter the new value, and save again. The table updates immediately on next load without any shortcode changes.