Conditional Bulk Update if Value=x Then Set It To=y

Navigate to Data Management > Bulk Operations.

Select the database and record type. Then explore the templates for an existing solution that may be close to what you need.

Under Step 1, set up a Filter to narrow the records down to only those you would like to update.

In this example, the filter is looking for records with a State/Region value of "New York."

When you click Search, Insycle will list matching records in the Record Viewer at the bottom of the page. These are the records that the changes you specify will be made to. 

Add columns to the view from the Layout tab under Step 1.

If you make changes to the filter, click the Search button again to refresh the results in the Record Viewer.

Now you'll tell Insycle how to update data based on the condition you just set. 

Under Step 2, make sure you are working in the Update tab. When the Update action is applied, previously existing data will be removed from the field.

This change will be made to all records that match your Step 1 Filter– in this example, contacts with a State/Region value of "New York."

Select the Field Name that should be updated, and enter the New Value.

Preview Changes in a CSV Report

Now with the filters and update actions in place, you can preview the changes. It's important to verify that your fields are being updated as expected before those changes are pushed to your live database.

Under Step 3, click the Review button, then in the Bulk Update popup, select Preview and click Next.

On the Notify tab, add any additional recipients who should receive the CSV (and make sure to hit Enter after each address). You can also provide additional context in the message subject or body.

On the When tab, click Run Now and select which records to apply the change to (in most cases this will be All), then click the Run Now button.

Open the CSV file from your email in a spreadsheet application and review the columns. For each field you’ve set up to change, a column will appear for both (Before) and (After). This will let you know what you started with and what change will be made to your CRM. 

Apply Changes to Your CRM

If everything in your CSV preview looks correct, return to Insycle and move forward with applying the changes to the live CRM data.

Under Step 3, click the Review button, this time select Update mode.

On the When tab, click Run Now and select which records to apply the change to (in most cases this will be All), then click the Run Now button.

Save a Template and Setup Automation to Maintain Formatting

After you've seen the results in the CRM and you are satisfied with how the operation runs, you can save your configuration as a template, and set up automation so this formatting operation runs on a set schedule.

You can create templates for as many states or regions as needed, then create a Recipe to run them all together. 

Using templates and automation, you'll save time and ensure that your fields are consistently updated on an ongoing basis.

Navigate to Data Management > Transform Data, then select the database and record type in the top menu.

Under Step 1, filter your database down to the records that you would like to update.

In this example, we're looking for records that have not been updated in the last 7 days, that do have a value in the "Pipedrive Owner ID" custom field.

When you click Search, Insycle will list matching records in the Record Viewer at the bottom of the page. 

If you change the filter, click the Search button again to refresh the results in the Record Viewer. Add fields to the Record Viewer on the Layout tab of Step 1.

Under Step 2, tell Insycle what values to look for, and what to replace them with if found.

Here is an example of mapping owner ID numbers so the Pipedrive Owner ID sets the HubSpot owner ID. The "Pipedrive Owner ID" field data is not modified; it's used as input for the mapping. The mapping output is applied to the "Contact Owner" field.

1. Select the Field containing the value you want to look at.
2. Select the Map: Values function. With this, all the content in the field must match the Existing Text value. If it matches, the New Text value will be used.
3. In the Existing Text field, enter the value you want to look for. 
4. If the Existing Text is found, the New Text value will be used for the next steps. In this example, if the Pipedrive Owner ID field has a value of "17282680," the New Text value, "199451430" will be used.
5. Click the plus at the end of the row to add another function for this field.
6. If there are different values you want to look for and map, add another Map: Values function. In this example, we're looking for either "19196515" or "1876250," and if either of those is found, the New Text value, "199451430" will be applied. We're mapping two Pipedrive owners to one HubSpot owner.
7. When a value in the selected field doesn't match the Existing Text from either of the preceding functions, or it's blank, you can use the Map: Default value (unmapped) to apply a default value. 
8. Select the Copy: Value function and the Target Field the new value should be written into. By copying the value to a different, target field, the data in the initial field remains intact.

You may need to do some experimentation. Use the Preview mode and CSV report to see if you get the desired result.

Preview Changes in the CSV Report

With the filters and functions set up, you can preview the changes in a CSV file. It's important to verify that your changes are working as expected before they are pushed to your live database.

Under Step 3, click the Review button, then select Preview in the popup.

On the Notify tab, you can select recipients for the emailed report and add additional context to the message. (Make sure to hit Enter after each email address.)

On the When tab, click Run Now and select which records to apply the change to (you could do All, but if you have a large number of records, you may just want to do a chunk for your preview), then click the Run Now button.

Open the CSV file from your email in a spreadsheet application and review the (Before) and (After) columns. 

To help review the results in this example, we've pasted the original Pipiedrive Owner ID values in. This makes it easy to verify that the ID numbers are changing as expected. We get these by using the Export button under Step 1.

If the results don't look how you expected, return to your filters in Step 1 and functions in Step 2 and try making some adjustments, then preview again.

Apply Changes to the CRM

If everything in your CSV preview looks correct, return to Insycle and apply the changes to the live CRM data.

Under Step 3, click the Review button, this time select Update mode.

On the When tab, you should use Run Now the first time you apply these changes to the CRM. If you have a large number of records, you may want to do a smaller batch to review the results in your CRM.

You may find the same data is duplicated in different fields and are looking for a reliable way to do some bulk cleanup. With Insycle, you can easily identify redundant values, put together a recipe to clean it up, and set up automation for ongoing upkeep.

For this example, let's say you have discovered duplicate phone numbers that need cleanup. 

In the Transform Data module, you can compare values between two fields and store the result of the comparison in another field. 

Set up the Filter in Step 1 to find the records with values in the problem fields. 

In Step 2, use the Compare function to look for a match between the first and second selected fields.  Compare: Is Equal? (Exact), looks for an exact match while Compare: Is Equal? (Related) ignores capitalization differences and spaces before or after. This example uses a custom field, "Values Match" as the Target Field where the "True/False" outcome will be recorded.

After you've run the Transform operation, use the Bulk Operations module to clear the duplicate values. 

In Step 1, set up the Filter to find the records where the custom field contains "True." 

Under Step 2, select the field to clear the values from, leaving the New Value field blank.

Create templates for both of these operations. Then you can create a Recipe to run these together automatically on a set schedule.

When you're overwriting field data, you may want to refer to the old values or restore them later. You can export a CSV file that could act as a backup by clicking the Export button under Step 1.

The CSV only includes fields that are visible in the Record Viewer. Use the Layout tab under Step 1 to add more fields and preserve all the data that might be needed.

As long as a field is writable, you can update it using Insycle. Use the Cleanse Data module to see a full list of writable fields.

Yes, the pre-existing data in the record will be overwritten by the bulk update. If you need this data for reference or restoration, it will be available in the CSV in the Activity Tracker. 

Yes. All pre-existing data will be available in the Activity Tracker CSV for restoration purposes if required. Or, you can create a backup export of your data before overwriting, as explained in the Advanced How-Tos above.