Fields Units of Measure

[jfreise]

Has anyone added custom units of measure to their database fields? For example, lets say I have a field that is a decimal and it stores the weight of something. I would like to add units to the label or even right next to the displayed value. So it would show up as 2.56 lbs., or 2.56 kg. As an added feature I would like to have a property that says whether the units are standard or metric and convert & display the appropriate amount and unit. Is this even possible? There is a Units table out-of-box, but it is part of Performance Analytics. I'm doing this in the latest Fuji.

[nabilenayet]

Did you ever get a solution for this? I am dealing with the same requirement at the moment, currently handling it using a custom units table & exposing a value + value unit field for the table that uses it, however the two fields feel disjointed on the form (would like to show them side by side as you proposed, not sure if there's a way to do that without creating a custom macro)

[jfreise]

Hi Nabil,

Unfortunately, I have not.

Regards,

Jay

[Yang Lu]

This one is tough.   Since ServiceNow is not an ERP and more focused on triage of work, it hasn't put a lot of focus on UOM fields.   Currency is out of the box, but distance and weight do not show up.   Distance should show up in future releases as Customer Service and Field Service is more of a focus, but this might get outsourced via APIs to Google Maps.   The best suggestion I have is to have the 2 fields as Nabil mentioned -- one for the measured value and another for the unit (choice).   They will be on separate lines unfortunately.   Then drop in a UI macro to convert and popup the measured value in other units.   The typical use case would be a global team working in US/UK and EU where one is Imperial and the other is Metric and a collaboration needs to exist.