Formula to concatenate the text value of two fields with selected list values

AI generated answer (using internal Slack threads):

Based on the conversations, to concatenate the text value of two fields with selected list values, you can use the

||

operator or the

CONCAT

function in NetSuite. Here are some examples: 1. Using the

||

operator:

{custbody_field1} || ' ' || {custbody_field2}

2. Using the

CONCAT

function:

CONCAT({custbody_field1}, {custbody_field2})

If you want to add some static text before each field, you can do it like this:

'text: ' || {field1} || ' text: ' || {field2}

If the fields are not always guaranteed to have a value, you might need to use the

NVL

function to handle null values. Please note that the field names in the examples are placeholders, you should replace them with your actual field names. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******