Kuovonne's Guide to Airtable
Share
Explore
Kuovonne's Guide to Airtable
Picking a field type

Number vs Text

Sometimes we use a numeric ID to identify things. For example, a zip code is composed of only digits, but it is not really a number. In cases like these, it is better to use a text field instead of a number field.
Number fields cannot have leading or trailing zeros
Number fields do not accurately store very large numbers. If your string of digits has over 15 digits in it, the number will probably be rounded or stored in scientific notation.

Share
 
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.