How to source free-form text field from list/record field
Hello all, I am working with an integrator that needs me to pass them the value, not the internal ID, of an item chosen from a custom list.
First, we created a custom list, then a custom list/record field and set its source to the custom list. This works fine in NetSuite, but when we export the sales order to the integrator, the list/record field contains the internal ID of the chosen list item instead of its value (“10” not “apple”).
My thought is to create a free-form text field that stores the value of the list item selected but so far, I have had no luck getting the free-form text field to source correctly from the list/record field. According to the documentation the two fields must be the same type for the sourcing to work.
So, is this approach possible? If so, any ideas how to make it happen?
You can set the text field from the list by using a workflow. Set Field Value action. set the text field using the current record list field.
You could also set the field to not store value and add the list field in the formula section. I’m not sure that value would be available for the integration though.