[Derek Howard]

Are the tables for State and country on the odbc link? My custom record types just give me the id. What is the best practice for pulling this?
This is a cached copy. Click here to see the original post.

[hhernandez]

Hello Derek,

ODBC table for states/provinces/countries is currently under Enhancement # 193701.

If you just want to get the equivalent text value of the ID, you could probably try:

Add another custom field (‘custrecord_country_text’) on your custom record that would store the equivalent text value of your custom Country/State field (‘custrecord_country’).

This can be done by before submit script running on your custom record. The script will set the equivalent text using nlapiSetFieldValue(‘custrecord_country_text’, nlapiGetFieldText(‘custrecord_country’));

[Author]

Posts