RE: Export Fields & Field IDs related to a Record
Hi,
I would like to create a list of all Fields relating to a record (e.g., Projects). I can do this with a Saved Search by adding all the fields. However, in addition to the fields I would also like to include each Field’s internal ID. Can this be done with a Saved Search?
Do you have a solution in mind?
Have you tried to load the record in the console/dev tools and get all the IDs in there as well?
nlapiLoadRecord(‘record’, id#)
I’m not familiar with the console/dev tools. Could you walk me through how to do this?
Absolutely! so NetSuite runs plain javascript in the backend and a lot of the records, fields and information in netsuite can be invoked through an API using internal IDs. This can also be used to manipulate fields on records. SSP 1.0 and 2.0 use these a lot. For Example to Load a Record, let’s say a Sales Order in the console you’d write something like this: nlapiLoadRecord(‘salesorder’, interalid#); That would load the sales order record and would allow you to see all the fields associated to that same record. After that you can run commands like nlapiGetFieldValue() which gets values or set values by nlapiSetFieldValue() Check this out for more information: https://system.netsuite.com/core/media/media.nl?id=51416823&c=NLCORP&h=c7cecd8e1180e6076aca&_xt=.pdf
Thanks for the detailed response. I get the idea but I think I’m still stuck on “console”. Is that the browser’s console? – I did some googling and that’s what I’m assuming you mean by console. So I typed “nlapiLoadRecord(‘project’,29757);” (w/o “) into the web console and got back an error:
Sorry. Also called Developer Tools. look at aghari’s reply below as well. Chrome ext works like a charm
If you are looking for to load a project with that function the type parameter should be ‘job’ as anthe list of parameter values is at: https://[deleted].app.netsuite.com/app/help/helpcenter.nl?fid=chapter_N3170023.html&whence=
Open Chrome Dev Tools (Ctrl+Shift+I) while logged in and in the Console enter:
nlapiLoadRecord('job', '<IID>').fieldnames.forEach((e)=>{ console.log(e); });
Which will dump all of the fieldnames to the console.
