function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion

Inserting New Records Using Data Loader - One Field Being a Custom Lookup Data Type Field

Hi All,


I have created a custom field on a custom object as a lookup data type for our Product Codes.  This way we can enter a Product Code and the Product Name field will autofill.  We use the Data Loader to insert new records for all our samples that get shipped on a daily basis and I keep getting an error that the Product Code is invalid and I know that it is in our lookup.  Does the Data Loader not work on lookup fields when inserting new records or do I need to do some additional work?




Greg HGreg H

You need to use the Id of the record where the product code is stored, not the product code itself.



Could you please provide more information on how this is performed?  Do you update the csv file?  I have been trying to resolve this issue all day.  I would like to load all case data for existing contact but have problems associating with contact due to lookup field.