Apex Code Development You need to sign in to do that
Don't have an account?
Ignore Populated Fields on DataUpload/Upsert
Hello Brilliant People,
This may be a simple question with a complex answer.
Is there a way to update fields that are ONLY blank/null on update or upsert?
I am uploading a set of Contact records and I only want to update the field if it is blank or null. I dont want it to overwrite it if a value exists, if it is a blank value I want it to populate. If the Contact doesnt exist, I want it to create the record with all metadata.
And I dont think this matters, but I dont have the ContactID's so will be keying off of the email address.
Thank you as always for the help!
This may be a simple question with a complex answer.
Is there a way to update fields that are ONLY blank/null on update or upsert?
I am uploading a set of Contact records and I only want to update the field if it is blank or null. I dont want it to overwrite it if a value exists, if it is a blank value I want it to populate. If the Contact doesnt exist, I want it to create the record with all metadata.
And I dont think this matters, but I dont have the ContactID's so will be keying off of the email address.
Thank you as always for the help!
I think the easiest solution is probably to export all Contact records and do your record matching and field population using Excel. Then you can do the upsert by email (make sure there is no duplicate email).
Another solution is to dump the data to a custom object (or use the external object, if you can set it up). Then write an Apex script in Developer Console to upsert the data. This is more complicated.