CRM Watcher

CRM Watcher is the source for the latest Microsoft Dynamics CRM News and Downloads.

Tuesday, September 05, 2006

Replace CRM Database values (A, B and C) at once (with D)

Is it possible to replace one or more values in the Dynamics CRM database at once?

New Dynamics CRM users want to know if it's possible with Dynamics CRM to replace values in the database (A, B and C) at once with another value (D).

With Dynamics CRM this is easy to realize:
  1. Select Tools and then Advanced Find.
  2. Select the right entity (accounts or contacts in this example).
  3. Define a row that says '[fieldname] contains A'. Define also rows for the values B and C (replace A, B and C with the values you want to use).
  4. Select the 3 (or more) defined rows and group them with the option 'Group OR'.
  5. Click the 'Find' button; the results will be shown.
  6. Select all the records in the view.
  7. Select in the top menu 'More Actions' and then 'Edit'; an account form (or contact form) appears.
  8. Select the field that you want to change for all the selected records and type the value 'D' (replace D with the value you want).
  9. Click the 'Save' button and all selected records have been changed.