I have a requirement to update the field labels of 200 fields in a custom object and mass delete another 100 fields. what is the most time efficient way to accomplish this? I read a post that said this might be possible using ANT tool or Force.com IDE and change the XML or maybe using Salesforce Toolkit: http://sftoolkit.co/. Has anyone done something similar to this? Thanks for your time.
An IDE is arguably the easiest way to edit fields. Simply pull down the object, edit all the labels, then save the changes. You can do this in MavensMate, Force.com IDE, and others that support the object folder (most, if not all, do).
To delete fields, you need a destructive tool. My tool of choice is the Ant Toolkit or the Workbench. Simply create a "destructiveChanges.xml" file that contains a list of fields to delete:
<?xml version="1.0" encoding="UTF-8"?> <Package xmlns="http://soap.sforce.com/2006/04/metadata"> <types> <members>ObjectName.FieldName1</members> <members>ObjectName.FieldName2</members> <members>ObjectName.FieldName3</members> <members>ObjectName.FieldName4</members> ... <name>CustomField</name> </types> <version>42.0</version> </Package>
Note that you also need an empty package.xml for this:
<?xml version="1.0" encoding="UTF-8"?> <Package xmlns="http://soap.sforce.com/2006/04/metadata"> <version>42.0</version> </Package>
Also see this answer which goes into greater detail on using the Workbench.