function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
Krish NKrish N 

What is the best way to mass update a field based on the location name

Hello all, We have a location object based our customer accounts. There are thousands of location records for a single account. I've to mass update a text field in those location records based on the location name.
For ex:
If the location name for account "Sample Coorporation" is Sample T0274, I want to update a text field to T0274. Lets say this account has 1500 locations with names such as Sample T0001, Sample T0002, Sample T0003 .......... Sample T1500. I want to update a text field with values T0001 for Sample T0001, T0002 for Sample T0002 ........ T1500 for Sample T1500 location. What is an effective way to acheive this?
 
Best Answer chosen by Krish N
Raj VakatiRaj Vakati
Export the data into excel with the related data  i mean location and its account and then manipulate the data 

Upload it 

All Answers

Raj VakatiRaj Vakati
YOu want to do one time ?? 

Or you want to do it every time
Krish NKrish N
Just one time
Raj VakatiRaj Vakati
Export the data into excel with the related data  i mean location and its account and then manipulate the data 

Upload it 
This was selected as the best answer