Setting a field to display Kilograms and grams

[Deirdre_Morriss]

Hi all, pretty new here! I just want to set up a field to capture grams and kilograms (weight).
Do I set cutomize the field to number? I’d like to to display KG or g like it would if I added a currency $/£/€ etc. Is this possible?

Thanks for any help you can provide!

[Justin_Barrett · Accepted solution]

Airtable currently only offers a few options for customizing the display of a numeric field, and weight options are not among them. If you want, you could show your support for adding more robust formatting options.

In the meantime, the best you can do is have your data entry in one field, and a formula in another to add “KG” or “g”. Here’s a thread that shows how to format numbers in more elaborate ways using formulas.

Number and Currency 'Pretty-Print' Routines Show and tell

tl;dr version: A demonstration base offering three approaches to formatting numbers or numerals while providing ‘pretty-print’ formatting (e.g., currency indicators, thousands and decimal separators, and so on). Allows for non-US separators and decimals, as well. The third table supports parentheses for negative values, right-aligned output with a specified number of columns, and more. A while back, in response to this query, I started on what I thought would be no more than a half-hour’s task…

[Deirdre_Morriss]

Thanks a million Justin, appreciate your time!

[Justin_Barrett]

My pleasure Deirdre! Glad to know that my answer was helpful for you! If you would, please mark my comment above as the solution to your question. This helps others who may be searching with similar questions. Thanks!