You need to sign in to do that
Don't have an account?

Best way to turn Employee Number "0" lead fields to "blank"
I am looking for a way to switch the fields in SF that have a zero in the "No. Of Employees" Field to make them blank so that I can update them with a data.com clean. Someone suggested that there might be a way to write an Apex trigger for "if employees=0" then "make blank" - does anyone know if there is a better way or know how to write an Apex trigger that would be willing to help me?
Thank you!
Thank you!
Below link will have an overview of data loader and its capabilities.
https://developer.salesforce.com/page/Data_Loader
Below is the small piece of code. You can run this in your Developer Console
If your query return more than 10000 records. Run the above code again. Let me know if it helps you.
Regards
Amrender
Let me know if it helps you.
Regards
Amrender
SELECT Name
FROM Lead
WHERE NumberOfEmployees = 0
;
I have tried every iteration I can think of including using Account, deleting the spacing, using quotes, using different "where" qualifications, I cannot seem to run a query that returns results.
Ultimately, I am trying to run Amrender's code to complete the data clean and thought I would do a search first, I am new to using the developer console, but I have done some SQL before, I am not sure what I am doing wrong. Any help would be incredible!!
I captured some screen shots and I hope these will help you to run the code.
Let me know if it helps you
Regards
Amrender