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

<@USV3W3YB1> There is no way to do that... you need to create an Object/File with the Country Name and CODE.

<@U7A0KGURX> previously wasn't possible but the countries table is exposed to SuiteQL so now it is

<@U29QCJQF3> Do you have any code snippet doing that?

```require(['N/query'], function(query) {
    function getCountryIdFromName(countryName) {
        const sql = `SELECT id FROM country WHERE name = ?`;
        const results = query.runSuiteQL({
            query: sql,
            params: [countryName]
        }).asMappedResults();
        return results.length ? results[0].id : null;
    }

    getCountryIdFromName('Australia');
});```

<@U29QCJQF3> Thanks... appreciate it. :100: