This site was built to compliment the existing NetSuite Professionals Slack Community by adding a means for members to easily find answers to common questions and to create a searchable database of those questions and answers.

NetSuite Professionals

Hi all, is there any way to get the `List/Record` (id: `selectedrecordtype`) data for any field?

`record.getField` doesn’t provide much information

use a <https://system.netsuite.com/app/recordscatalog/rcbrowser.nl?whence=#/record_ss/CustomField|Custom Field Definition> query

Thanks <@U5TF1GQ20>
Can this be used only for custom records or for custom fields on any kind of record?

Currently, with NetSuite search and JS map/filter, I have a list of custom fields present in vendor bills record type. From there, I am having hard time making the query you mentioned as I don’t see vendor bills/transaction in the join for that record.

I’m new to query/suiteql/workbook, so I might be be missing something here.

Finally was able to get results.
Sample code:
```const resultSet = query.runSuiteQL({
            query: "SELECT * FROM CustomField where scriptid = '" + billFields[2].id.toUpperCase() + "'",
        });```
I needed that `toUpperCase()` to make it work

Thanks again <@U5TF1GQ20>, appreciate your help as always!

there’s a good plugin that provides this data right in the help when you click on the label. I think it is Advanced Field Help - look in Chrome Extensions

I need it in the SuiteScript not in the UI :slightly_smiling_face: