Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

Number fiield with unit

Topic Labels: Formulas
Solved
Jump to Solution
1260 2
cancel
Showing results for 
Search instead for 
Did you mean: 
swanlike
5 - Automation Enthusiast
5 - Automation Enthusiast

Hi!

Is there any easy way to add a unit to the number field?
I have a lot of tables with dimensions. Some of them are metric, some imperial.

I want to show them as:
0,234 => 0,234 mm
or
0,234 => 0,234"

Of course without changing numbers to texts - because I do a few calculations on them. Let's say "just view"

Thanks for the help,
if this is something easy and obvious  - sorry I'm a newbie 🙂

regards
tomek

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Hi @swanlike,

Unfortunately, Airtable has no way to display units at the end of a string while keeping the number type.
If you need units, you will need both a display field (strings) with units added and a numeric values field.

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

Hi @swanlike,

Unfortunately, Airtable has no way to display units at the end of a string while keeping the number type.
If you need units, you will need both a display field (strings) with units added and a numeric values field.

swanlike
5 - Automation Enthusiast
5 - Automation Enthusiast

This is what I thought! And, at the end, my table has columns to look nice and other columns that are just for proper calculation.

Thanks for answer Sho!