We have a need to store units of measure on custom records. We are currently doing this in a Free-Form Text field, but would like to convert this to a type list/record for increased consistency.
I am writing a script that will automate this conversion as we have over 1,000,000 active records that need to be updated and CSV is not feasible with this large a data set.
I have ran into an issue, it would appear as though the search filters on a Free-Form Text field are case IN-sensitive, and I need for them to be case SENSITIVE.
Here is an example:
While building a filter expression I am using:
['custrecord_uom', 'is', 'nm']
This unfortunately returns the same results as:
['custrecord_uom', 'is', 'Nm']
This is a problem for me:
nm is the abbreviation for nanometer.
Nm is the abbreviation for Newton meter.
I cannot get these two confused or my data will be incorrect.
Any help is greatly appreciated.
Thank you.