lookupFields working example in netsuite
Hi All,
Many Netsuite developers asked us for working example of lookupFields in Suite Script 2.0,
In this post, We are writing about working example of lookupFields in Suite Script 2.0
In this example , script is looking for fields:
1. entityid
2. phone
3. email
4. state ( Select field)
*** Please note , for Select and Multiselect fields you have to treat it as array and get value.
var employeeDetails = search.lookupFields({
type: search.Type.EMPLOYEE,
id: 121212,
columns: ['entityid', 'phone', 'email', 'state']
});
var entityId = employeeDetails.entityid;
var empPhone = employeeDetails.phone;
var empEmail = employeeDetails.email;
var empState = '';
if(employeeDetails.state)
{
try{
empState = employeeDetails.state[0].value;
}
catch(e)
{
}
}
*** We have noticed that if state field (in our case) is empty , then getting 0th value throw error.
try catch is not that important but used to not effect other part of code.
We hope this will help someone in future , let us know how you deal with Select and Multiselect fields.
Thanks
Team Netsuite Guru
Download Netsuite Guru Android App
Follow Me on Linkedin
Our FB Page
Many Netsuite developers asked us for working example of lookupFields in Suite Script 2.0,
In this post, We are writing about working example of lookupFields in Suite Script 2.0
In this example , script is looking for fields:
1. entityid
2. phone
3. email
4. state ( Select field)
*** Please note , for Select and Multiselect fields you have to treat it as array and get value.
var employeeDetails = search.lookupFields({
type: search.Type.EMPLOYEE,
id: 121212,
columns: ['entityid', 'phone', 'email', 'state']
});
var entityId = employeeDetails.entityid;
var empPhone = employeeDetails.phone;
var empEmail = employeeDetails.email;
var empState = '';
if(employeeDetails.state)
{
try{
empState = employeeDetails.state[0].value;
}
catch(e)
{
}
}
*** We have noticed that if state field (in our case) is empty , then getting 0th value throw error.
try catch is not that important but used to not effect other part of code.
We hope this will help someone in future , let us know how you deal with Select and Multiselect fields.
Thanks
Team Netsuite Guru
Download Netsuite Guru Android App
Follow Me on Linkedin
Our FB Page
Comments
Post a Comment
Thanks for you message, please join us on Facebook and Linkedin