function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
BryanHill10BryanHill10 

Need help bulk updating Name Field for all records in a Custom Object.

I need help changing the Name of 1500+ records in a custom object. When it was initially set up the developer set the record to be named with the auto number feature which doesn't make sense for this object. I would like to bulk update each record with data from another field in the same custom object.

Custom Object name is - Property Analysis
Field to be bulk updated is - Name
Field data already inputed to replace "Name" is - "Address__c"

Would really appreciate some help on this. 

 
Best Answer chosen by BryanHill10
Raj VakatiRaj Vakati
This are the steps 
  • Extract the data from Property Analysis as per below SOQL using workbench or some other tools 
           Select Id , Address__c from  Property_Analysis__c
  • Change Auto Number to  Text  for name filed 
  • Update the data from the extracted data by changing the Address__c to Name in the CSV header 
  • Perform Update  DML