Is there a generic way to get the name of a record...
# suitescriptj
jen
04/05/2023, 8:51 PMIs there a generic way to get the name of a record, e.g. for Contact/Employee/Customer it would be ‘entityid’, for transactions it would be ‘tranid’, for Cases it is ‘casenumber’? Basically the name that appears in bold text in the UI, the name that appears in Global Search, or would be the BUILTIN.DF value in a SuiteQL foreign key.
d
David B
04/05/2023, 8:55 PMthere's some articles about this, let me see if I can find them
David B
04/05/2023, 8:59 PMmaybe this article from Chidi? ("CustomRecordType" table using SQL)
Learn How to Programmatically Attach a User Note to a Custom Record Without Hardcoding the Record ID - NetSuite Insights
David B
04/05/2023, 8:59 PMNot the article I was remembering though
j
jen
04/05/2023, 9:01 PMhmm
jen
04/05/2023, 9:02 PMthat’s fine for customrecords but doesn’t help for standard records
👀 1
d
David B
04/05/2023, 9:55 PMTo be honest, I don't think I understand what you're after. I can't reconcile your examples
David B
04/05/2023, 9:56 PMDon't think I understand this properly, hoping someone else in #C29HQS63G can help
n
NElliott
04/06/2023, 1:00 PMAh you mean the field that contains the document number effectively? Sounded like you wanted the base record type at first read.
j
jen
04/06/2023, 6:22 PMI mean the field that stores the “name” of each individual record e.g. each individual salesorder in our system, each support case, etc. In transactions, this is
tranidcasenumberentityid👍 1
jen
04/06/2023, 6:23 PMthe value of this field shows in bold at the top of the record in the User Interface
jen
04/06/2023, 6:23 PMfor custom records where “use name field” is ticked, this would be
name👍 1
7 Views