Discussions
Custom unique identifier on custom records
Maybe this question belongs in the Customization section...
Short Version:
If I create a field on a custom record, can I specify that that field is unique so that I can match on it in CSV Imports?
Long Version:
Here is my scenario. I have a custom record type called Shipment Items. Records get created via a CSV import, and then later must be updated with additional information, again by CSV import. My problem is about how to associate the second import with the correct records.
The most obvious answer is to use the record's Netsuite-assigned ID. However, I am creating this process for others, and for the people that will actually be using it, finding and associating the record IDs with the correct lines in the CSV file is too time consuming / too difficult for them. Instead, it would be easier to use the existing fields to "create" a unique identifier to associate from.