NetSuite Admin Tip: Combining Values of Fields in Custom Field

When adding integer values from Standard or Custom Fields in NetSuite, users tend to use the formula {customfield1} + {customfield2} to generate the sum of the fields. But using this formula when we are dealing with a field that is not Integer or Decimal will generate an incorrect result.

In order to display a correct output, users may use the CONCAT function of SQL in the Formula of the Custom Field to add or combine the values of the fields. This can be helpful for users that needs to combine certain values from the Standard or Custom Fields of a certain record, such as the Employee's First Name and Last name, different values of a custom field and much more.