Do you want to bulk update a large batch of Gravity Forms Entries? For example: You need to replace a piece of text in a particular field value. But not in just one entry, but in 12321 entries! A nearly undoable task by hand, but updating that much entries is a breeze with our Update Multiple Entries add-on. And Advanced Merge Tags will do the search and replace for you. Let me show you how to do it.
1.Creating a form to trigger the bulk update
The Update Multiple Entries Addon provides a new type of feed for Gravity Forms, which can be used to trigger updates in the entries of a target form. So, to mass update a large batch of entries we need to create a ‘trigger’ form with one text field which we label description:
2. Adding the Update Multiple Entries Feed
Then go to the Settings page of your new trigger form and select the ‘Update Entries’ tab:
Click ‘Add New’ to add a new Update Multiple Entries Feed. This will open the Feed Settings of your new feed.
In this example we want to replace the word ‘dog’ by ‘cat’ in all the entries in the target form. So let’s do it like this:
- Enter the name of the Feed, like “Search and replace ‘dog’ “.
- Select the target form which entries you want to update.
- We narrow down the batch of entries to be updated to entries which have the word ‘dog’ in the value, by configuring the Target Entry Conditions by adding the rule: ‘Just a Text Field’ contains ‘dog’. This wil only update entries which have the word ‘dog’ in a textfield value, skipping other entries.
- In the Field Mapping we target the ”Just a Text Field’ -field and set the value it to a custom value so we are able to use Merge Tags. In this case we want to modify a value from the target entry, so we use the special target Merge Tag to get the targets entry field value: {target:1}.
- But we don’t want the actual value, but the value with ‘dog’ replaced by ‘cat’. So we use a special Merge Tag Modifier: gwp_replace: {target:1:gwp_replace search=”dog” replace=”cat”}
Now everything is ready!
3. Triggering the bulk update of multiple entries
Open the trigger form in preview mode, enter something in the Description and hit Submit:
4. Result of the bulk entry update
Before the update there were 12321 entries with ‘I love my dog!’ in the target form:
Below is the entry in the trigger form which executed the Update Multiple Entries Feed as we configured it. As you can see it executed te update of 25 entries to determine the server speed. The rest of the entries were updated in 12 chunks to prevent crossing the PHP execution time limit (30 seconds on most servers). These chunks run in a background process.
After around 3 minutes the Update Multiple Entries feed has updated every entry of the 12321 entries. Of course the speed can be faster or slower depending on the server.
Our Premium add-ons for Gravity Forms
List Text
Add features like textarea, placeholder and custom validation to a column or multiple columns in a Gravity Forms List Field.
Entry to Database
Integrates Gravity Forms with internal or external databases, offering flexible mapping of form fields to database columns and real-time synchronization between entries and database rows.
DateTime Field
The GravityWP - DateTime Field add-on adds a dedicated Date/Time field to Gravity Forms so users can enter both a date and a time in a single input.
JWT Prefill
Fill forms with data you can trust. Prefill Gravity Forms fields with a secure token instead of links with editable url parameters, so your data is accurate, tamper-proof, and ready to use.
Read tutorials about
Gravity Forms Discount Code Field: Apply Fixed or Percentage Discounts in a Form
Learn how to create a Gravity Forms discount code field that applies fixed or percentage discounts. This tutorial shows how to calculate subtotals, discount amounts, and final totals using tested form logic.
Gravity Forms Zoom Integration: Create Zoom Meetings From Booking Forms
Learn how to connect Gravity Forms to Zoom without Zapier using GravityWP API Connector. This step-by-step tutorial shows how to create Zoom meetings from booking form submissions and save the returned meeting details back to Gravity Forms.
Gravity Forms monday.com Integration: Create New Items From Form Submissions
Learn how to connect Gravity Forms to monday.com without Zapier using GravityWP API Connector. This step-by-step tutorial shows how to create new monday.com items from form submissions and save the returned monday.com item ID back to Gravity Forms.
Gravity Forms Pipedrive Integration: Send Form Contacts to Pipedrive Without Zapier
Learn how to connect Gravity Forms to Pipedrive without Zapier using GravityWP API Connector. This step-by-step tutorial shows how to send form contacts, custom fields, and the returned Pipedrive Person ID directly from WordPress to Pipedrive CRM.
