How can I show a different field than the ID when I have a field that is associated to a List/Custom record?

AI generated answer (using internal Slack threads):

In NetSuite, when you have a field that is associated with a List/Record, the default behavior is to display the record's ID. However, if you want to display a different field, you can use a workaround by creating a custom field and sourcing the desired value into it. Here's a step-by-step guide: 1. Create a new custom field of type 'Free-Text'. 2. Uncheck the 'Store Value' option on the field. This allows the field to dynamically source its value from another field. 3. In the 'Defaulting' tab, put the ID of the field you want to display in brackets. For example, if you want to display the 'companyname' field, you would put

{companyname}

in the 'Defaulting' tab. This will check the 'Formula' box. Please note that this workaround will not change the values displayed in the dropdown list when the user is selecting a value for the field. The dropdown list will still display the record's ID, as this is a limitation of NetSuite's validation to ensure unique values in the list. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******