[esullender]

I’ve created a custom record with fields and I am accessing this record and its fields via ODBC queries.

Custom Record -> Table Name

Custom Fields -> Table Columns

Custom Record: Cars (customrecord_cars)

Custom Fields: Manufacturer (customrecord_manufacturer), Year (customrecord_year), etc.

The problem I’m having is that I can only reference the data via the “Labels” of the custom fields (Cars.Manufacturer), not the “ID”s (customrecord_cars.customrecord_manufactuer).

So, if an administrator wants to change the text of a label (Manufacturer -> Make) it breaks the code we have in external systems pulling this data. We need to change all odbc query references to be Cars.Make). It seems like I should be able to access the data via the IDs. Has anyone been able to do this? It seems like a serious shortcoming if it’s not possible.
This is a cached copy. Click here to see the original post.

[DBL]

RE: Accessing Custom Record Fields via ID with ODBC

I’m not aware that this is possible and have encountered the same problem. I guess the secret is to change the label name rather than the field name

You also have to consider that the Netsuite fields can change names as well although this doesn’t happen that often

[brianadkins]

This is just Horrible…. the ODBC column names are tied directly to the GUI names for fields and not the IDs? We change the GUI labels as required to assist our users

I guess we’ll need to completely stop changing the Custom Field Labels and, instead, change the label as it is applied to forms instead. This is a distinction we had previously never made.

[DBL]

“I guess we’ll need to completely stop changing the Custom Field Labels and, instead, change the label as it is applied to forms instead”

I think this is what I was trying to say but reading back my post, I didn’t make it very clear

[Author]

Posts