Discussions
Join the NetSuite community to innovate, connect, and discover what’s next.
SuiteWorld brings thousands of innovators, builders, and leaders together to learn, connect, and shape what’s next. This October, explore how to build a stronger foundation for growth through inspiring keynotes, major product reveals, hands-on sessions, and unforgettable moments—all in one place for our biggest event of the year. Register now
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.