I'm trying to setup a custom field in a Custom Record Type that will show a list of items using the 'label' (an internal title for the record) of the item, not the NetSuite assigned internal ID.
e.g. my first Custom Record Type is called "Communities", and it has the following Custom Fields:
1) Label (type: free-form-text)
2) MyID (type: integer)
My second Custom Record Type, called "Community Subscriptions" has 4 fields:
1) Contact (type: list/record - List/Record: Contact)
2) Member_ID* (type: integer)
3) Community (type: list/record - List/Record: Communities)
4) Community_ID* (type: integer)
* hidden in data entry form for this Custom Record Type
When I create a new record in "Community Subscriptions" I'm shown two fields in the form: Contact and Community. Selecting the "Contact" field shows a list of all the current contacts.
However, when I select the "Community" list, it shows the NetSuite assigned ID of the records within the Communities Custom Record Type. What I want is for it to show the "Label" field here, as sale reps won't know one ID from another, but still know the labels.
i.e. if My data were:
MyID: 51, Label: Users USA
MyID: 62, Label: Users UK
MyID: 23, Label: Partners
when I view the dropdown list in my form I just see "1", "2", "3", (the NetSuite assigned internal IDs for each record) but I want to see "Users USA", "Users UK", "Partners"
Possible?