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.
In this sample scenario, a user needs a field that will display the Full Name of an Employee in a single field. To achieve this, the value of the First Name and Last Name of an Employee needs to be combined in a Custom Field. Users may use the following formula under Validation & Defaulting of the Custom Field:
CONCAT(CONCAT((firstname),' '), (lastname))
Another formula that we can use is by using || symbol which is the string concatenation symbol of SQL. The formula that we can use for our sample scenario is:
({firstname})||' '||({lastname})
Do you have any tips or tricks that you can share with us? Let us know in the comments!