I'm creating a custom record type and I want the N...
# administrationj
Josh Godfrey
07/23/2021, 2:59 PMI'm creating a custom record type and I want the Name Field to be a unique value. I'm trying to avoid duplicate records from being created. Is there anyway to do this with Suitebuilder?
Josh Godfrey
07/23/2021, 3:02 PMCorrection; it doesn't even need to be the name field. I'm just finding it hard to believe there isn't anything 'out of the box' that would let me create a new column on this custom record and require new rows to have unique values.
j
James Morris
07/23/2021, 3:50 PMIs there a reason you can’t use External ID? That automatically requires unique entries for that record type and has the added benefit of being a record key for imports, scripting, etc.
j
Josh Godfrey
07/23/2021, 3:52 PMI thought about it, but I think I remember the external id giving me a hard time when I tried adding it to the UI/Form view. Also I want this value to be selected from a dropdown or multi select field.
Josh Godfrey
07/23/2021, 3:52 PMWait, that external ID is going to be used in our integration..
Josh Godfrey
07/23/2021, 3:53 PMI found a few blogs like this: https://blog.prolecto.com/2015/03/13/how-to-enforce-unique-names-on-netsuite-custom-records/
Josh Godfrey
07/23/2021, 3:53 PMMight just go with suitescript. we won't be adding a ton of these custom record instances.
j
James Morris
07/23/2021, 3:54 PMYeah there’s lots of ways to tackle this. I tend to like to plug things into external ID, but if it works for you, then that’s the best solution.
j
Josh Godfrey
07/23/2021, 3:55 PMHave you found a way to add values to the external ID through the UI?
Josh Godfrey
07/23/2021, 3:55 PMI use external id on a few other record types, but I have to import all of my values. It would be nice to give my users the option to add manually without an import.
j
James Morris
07/29/2021, 2:12 PMI think you can create a custom field to store it and then script it in on record creation. That's pretty much the only option as afaik.
17 Views