How to Change the Entry ID Column Used for Updating Data in WPSyncSheets for Gravity Forms
By default, WPSyncSheets for Gravity Forms updates rows in Google Sheets using the Entry ID column.
In some scenarios, you may want to update existing rows based on a different column instead of the Entry ID.
WPSyncSheets provides a filter that allows you to define a custom column header for a specific form and feed, which will be used to locate and update rows in the sheet.
When Should You Use This?
You want to update rows using a custom identifier instead of the Entry ID.
Important Notes Before Using This Filter
Please keep the following points in mind before applying this customization
- The selected column must contain unique values
- Duplicate values may cause incorrect or unexpected row updates
- If multiple rows share the same value, only one row may be updated
- This setting applies per form and per feed
- The first column is required to be mapped to the Entry ID and cannot be modified
Filter: Change the Column Used to Update Rows
Use the filter below to specify the Google Sheet column header that should be used to identify and update rows instead of the default Entry ID column.
Example: Use “Email” as the Update Column
add_filter ( 'wpssg_header_to_update_entry', function( $label, $feed_id, $form_id ) {
if ( ( 6 === (int) $feed_id) && 1 === (int) $form_id ) {
return 'Email';
}
return $label;
}, 10, 3 );
.
This change only affects the specified feed and form. Other feeds or forms will remain unchanged.