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?

how are you exporting the data

They installed a bundle and created a integration.

probably want to figure out which integration technology they are using

Yeah, I’m going to reach out for their help, I was just hoping to quickly solve this with a custom field.

You could for sure with a quick script that gets and sets the text value of that field if thats all you want to do.

the shot in the dark is a formula field

I was hoping a formula field might work. Any thoughts on what to try?

a formula with an expression representing your custom field