I got really confused just now. If I have a custom record with say, 10 entries. Does each entry have it's own internalid ? If so, I'm trying to create a search on my script trying to get the internalid field but I get a SSS_INVALID_SRCH_COL error. I'm confused now.
s
Sandii
04/16/2021, 9:32 PM
yes each record has its own internalid, sounds like you are probably doing so small syntax error
m
Mr_Tib
04/16/2021, 9:34 PM
This custom record has a field labeled as ID but its id is 'name'
Mr_Tib
04/16/2021, 9:35 PM
If I use the Netsuite Field Explorer chrome extension I see there's a field with the name of 'id' not 'internalid'. I've tried using both on my search to no avail.
Mr_Tib
04/16/2021, 9:36 PM
Oh, forgot to say the field label as ID but with id 'name', displays an actual string set by a script on record creation, not the actual numeric internalid assigned by NS
b
battk
04/16/2021, 11:58 PM
the internal id and the id fields are different things
battk
04/17/2021, 12:00 AM
for searches, Result.id is usually a pretty easy way to get the internal id
m
Mr_Tib
04/17/2021, 7:42 PM
As a follow-up, it turned out I was trying to get the "internalid " column not the "internalid"