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

I'm trying to map some data from one field to another in a workflow, so I wrote a Set Field Value action with a formula that has `CASE {fieldname} WHEN ...` which works great except that there's too many values to map and I've exceeded the maximum length of the formula field. Is there a workaround and/or alternate way to do this?

As a workaround, I used the `DECODE()` function instead of a `CASE`; since this takes fewer characters it now fits in the formula field. I'd still like to know if it's possible to look up the address by label, though.

Under Value can you use the From Field and select the record you source field is coming from and then in the drop down select the source field?

<@UC8TCGH2A> What do you mean by 'record your source field is coming from'? It's just a text field on the sales order.

<@UCBRT48KA> in the workflow use the 'Set Field Value' action - specify the field you are setting and then in the value column use 'From Field' to point to source field

<@UC8TCGH2A> The data I'm mapping is from a text field *to* a ship-to address; there's no record available to join on.

<@UCBRT48KA> I apologize, I misunderstood