I have created a new number field within my Opportunities object which is set to required and has a default value (0), however this is causing issues with closed Opportunities that did not have the field present when editing them.
I would have liked to simply do a mass update using SOQL, but as far as I'm aware we're cant do that. I would like to know what is the quickest/easiest way I can populate the records with this field empty with a figure?
I do not want to install applications to do this, and I should note I have more than 2k records so I believe govern limits will effect the possible solutions.
One solution I have tried is to create a trigger on before update, which would populate these fields if they are empty but this does not work, I believe the required attribute is kicking in before the trigger is.