You need to sign in to do that
Don't have an account?
alok29nov
Need to update some field of an object with the fileds of some other object
Hi All,
I have a requirement where I need to update some fields of opportunity. I have another custom object with many fields( apprx 10000 records). Now I need to update fields of oportunity with the filds of custom object. Records are already present in both the object. What would be the best solution for this.
Thanks in advance!
Regards
Alok
Is it something that would require the update of a field in one of the objects once a user updates a record ? If so, then you can do it through a trigger or maybe through a simple Workflow rule, and activate it right after you mass update all the records you need to do. For the mass update, I still would use data loader to do so. I'm sure you might be able to do a sort of trigger, but you'd end up having to touch all the records for the trigger to work.
Data loader should be a lot simpler for the mass update and then, you'd have to write only a trigger or workflow rule to update the fields in either object, based on the user entry.
All Answers
I think your best route would be through Data Loader, specially because of the amount of records. You can download both objects, update the records using a tool of your choice (SQL, Excel, MySQL...) and then, run the updates back to SFDC through Data Loader again.
B
Thanks for your prompt response Baguiar! I have one more query. Is it possible to do the same using batch apex ,rigger or some apex coding?
Actually, I have data which is very complex to update outside as I used some macros (other team) to update fields and run some formulas. So , I am looking for ways where
I can update data inside salesforce itself.
Is it something that would require the update of a field in one of the objects once a user updates a record ? If so, then you can do it through a trigger or maybe through a simple Workflow rule, and activate it right after you mass update all the records you need to do. For the mass update, I still would use data loader to do so. I'm sure you might be able to do a sort of trigger, but you'd end up having to touch all the records for the trigger to work.
Data loader should be a lot simpler for the mass update and then, you'd have to write only a trigger or workflow rule to update the fields in either object, based on the user entry.
No Baguiar, It's a mass update. So as you suggested, data loader is the best option.