The first step is to create a VIEW that displays all of the records that you wish to update (you may find this FAQ useful in creating this VIEW - How Can I create  a Custom View)

Adding the new value to a field on multiple records can be achieved by using the Global Update option. This is located at the foot of the main module;

You can select the field that you wish to update by clicking on the drop down selector - This list shows all of the available fields that can be updated using this method.

You add the value that you wish to update your fields with in the NEW VALUE box.

Select GO - this will prompt you with a warning about how many records are going to be updated and also that these cannot be undone should you carry this out in error.

Once you confirm the OK button your records will be updated with the data that you have supplied.

Tips and Tricks on Globally Updating Records

1. When updating the ASSIGNED TO fields, this requires the USER ID not the name  (This FAQ may help you find your USER ID's)

2. If the field you are updating is a Check Box the values that you will need to be aware of are - 0 = Unticked and 1 = Ticked

3. Remember to get the values to be exactly the same, especially if you are entering a value such as an item in a Picklist

WARNING : THIS OPTION OVERWRITES THE CURRENT DATA - IT DOES NOT APPEND TO THE EXISTING DATA.

• Rate This Article

  
  
• Feedback and Comments

  Name:

  
  

You may also be interested in:

• How do I Create a Mailshot in OpenCRM from a spreadsheet?  Updated : 13-05-2013 13:31
  OpenCRM::Contacts OpenCRM::Emails
• Help, I can't find any records - the Recent Items view is not showing any data anymore!  Updated : 02-05-2013 13:05
  OpenCRM::Contacts OpenCRM::Companies
• Social Network links on Companies, Contacts and Leads - how do we find usernames from the various Social Media Networks?  Updated : 12-04-2013 14:24
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Companies
• How to use the Outlook Add-in with OpenCRM. How to sync Contacts, Calender entries and Emails between Outlook and OpenCRM using the Outlook Add-in.  Updated : 23-07-2012 15:52
  OpenCRM::Calendar OpenCRM::Emails OpenCRM::Contacts OpenCRM::Activities OpenCRM::Add-in::Outlook Windows::Outlook
• How can I add or link a Contact to a Company?  Updated : 09-07-2012 10:29
  OpenCRM::Contacts OpenCRM::Companies

• How can I import my LinkedIn contacts into OpenCRM?

   

    Updated : 13-11-2012 12:17
  OpenCRM::Contacts OpenCRM::Data Import-Export
• I want choose some records from a list and export these records only, is there a simple way of doing this?  Updated : 14-05-2012 10:01
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Companies

• How does the Mapping tool work in OpenCRM? I want to see the locations of my Leads, Companies and Contacts on a Map, how do I do this?

    Updated : 16-11-2012 12:47
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Companies
• How can I change the fields visible on the Basic and Advanced Search screens?  Updated : 03-04-2012 15:11
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Activities OpenCRM::Companies OpenCRM::Opportunities OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Projects OpenCRM::Helpdesk
• I need to bulk update a set of records in OpenCRM, how do I do this?  Updated : 17-02-2012 12:47
  OpenCRM::Leads OpenCRM::Contacts OpenCRM::Activities OpenCRM::Companies OpenCRM::Opportunities OpenCRM::Quotes OpenCRM::Orders::Sales Orders OpenCRM::Orders::Purchase Orders OpenCRM::Invoice OpenCRM::Projects OpenCRM::Documents OpenCRM::Contracts OpenCRM::Events OpenCRM::Campaigns