- Cómo empezar a usar Airtable
- Introducción a los aspectos básicos de Airtable
- Cómo comunicarse con el equipo de soporte de Airtable
- Pantalla de inicio de Airtable
- Glosario de terminología de Airtable
- Airtable technical requirements
- Diferencias entre las funciones de Airtable para escritorio y para móvil
- Atajos de teclado de Airtable
- Cómo usar Markdown en Airtable
- Adding descriptions in Airtable
- Finding Airtable IDs
- Automatizaciones de Airtable
- Descripción general de automatizaciones
- Guías de automatizaciones
- Guías de automatizaciones integradas
- Guías de automatizaciones en Airtable
- Linking existing records using automations
- Conditional groups of automation actions
- Repeating groups of Airtable automation actions
- Creating recurring records using automations
- How to delay Airtable automation runs
- Prevent automations from triggering by mistake
- Use automations to timestamp status updates
- Desencadenantes de automatizaciones
- Desencadenantes de Airtable
- Airtable automation trigger: When record matches conditions
- Airtable automation trigger: When a form is submitted
- Airtable automation trigger: When record created
- Desencadenante de automatización de Airtable: cuando se actualiza un registro
- Airtable automation trigger: When record enters view
- Desencadenante de automatización de Airtable: a una hora programada
- Airtable automation trigger: When webhook received
- Airtable automation trigger: When a button is clicked
- Airtable automation trigger: When email received
- Desencadenantes integrados
- Desencadenantes de Airtable
- Acciones de automatización
- Acciones en Airtable
- Acción de automatización de Airtable: enviar correo electrónico
- Airtable automation action: Create record
- Airtable automation action: Update record
- Airtable automation action: Find records
- Airtable automation action: Sort list
- Acción de automatización de Airtable: ejecutar un script
- Airtable automation action: Generate with AI
- Acciones integradas
- Airtable automation actions: Slack
- Airtable automation actions: Google Workspace
- Airtable automation action: Send MS Teams message
- Airtable automation actions: Outlook
- Airtable automation actions: Jira Cloud
- Airtable automation actions: Jira Server / Data Center
- Airtable automation actions: Salesforce
- Airtable automation action: Create post in Facebook Pages
- Airtable automation actions: GitHub Issues
- Airtable automation action: Hootsuite post
- Airtable automation action: Send Twilio SMS
- Acciones en Airtable
- Bases de Airtable
- Using Airtable Cobuilder
- Descripción general de las bases de Airtable
- Creating and duplicating bases in Airtable
- Structuring your Airtable bases effectively
- Moving Airtable bases between workspaces
- Tables in Airtable
- Crear enlaces para compartir bases de Airtable
- Importing third-party data into Airtable
- Uso de las perspectivas
- Troubleshooting Airtable base performance
- Versiones beta de Airtable
- Colaboración en Airtable
- Asistencia de Airtable Enterprise
- Información general
- External badging in Airtable
- Creating and using Airtable components
- Ask an Expert beta overview
- Data residency at Airtable
- Descripción general de los grupos de usuarios en Airtable
- API de Enterprise de Airtable
- Creating and managing data retention policies in Airtable
- eDiscovery APIs in Airtable
- Airtable and data loss prevention
- Acceder a los registros de auditoría de Enterprise en Airtable
- Configuración de Jira Server/Data Center para conectarse con Airtable
- Panel de Administración de Enterprise
- Descripción general del panel de administración de Enterprise
- Usuarios: panel de administración de Enterprise en Airtable
- Detalles del usuario en el panel de administración de Airtable
- Grupos: panel de administración de Airtable
- Espacios de trabajos: panel de administración de Enterprise de Airtable
- Bases: panel de administración de Enterprise en Airtable
- Interfaces: Panel de administración de Enterprise en Airtable
- Data sets - Airtable admin panel
- Managed apps - Airtable admin panel
- Components - Airtable admin panel
- Informes: panel de administración de Enterprise en Airtable
- Airtable admin panel settings
- Guía práctica de Enterprise
- Gestionar a los admins de Enterprise en el panel de administración
- Uso de organizaciones
- Organizational branding for apps in Airtable
- Enterprise Hub in Airtable
- Enterprise Hub : Org unit assignment with user groups
- Desactivar, retirar el acceso y reactivar usuarios desde el panel de administración
- Gestionar el acceso de usuario a espacios de trabajo y bases
- Airtable Enterprise Key Management
- Custom terms of use
- SSO en Enterprise
- Información general
- Extensiones de Airtable
- Descripción general de las extensiones
- Extensiones por Airtable
- Extensiones integradas
- Campos de Airtable
- Descripción general de los campos
- Archivo adjunto
- Campos basados en fecha
- Fórmula
- Empezar a usar fórmulas
- Fundamentos de fórmulas
- Soluciones frecuentes: principiante
- Soluciones habituales: intermedias
- Soluciones habituales: avanzado
- Campo de texto largo
- Campos de registros vinculados
- Campos con números
- Otros campos
- Campos de compilación, búsqueda y recuento
- Campos de selección y colaborador
- Integración con Airtable
- API
- Getting started with Airtable's Web API
- Crear tokens de acceso personal
- Airtable Webhooks API Overview
- Service accounts overview
- API web de Airtable: usar filterByFormula o parámetros para ordenar
- Airtable API Deprecation Guidelines
- Airtable API: Common troubleshooting
- Managing API call limits in Airtable
- Enforcement of URL length limit for Web API requests
- Servicios de integración
- Third-party integrations via OAuth overview
- Troubleshooting disconnected OAuth integrations in Airtable
- Options for integrating with Airtable
- Third-party integrations - Common troubleshooting
- Low-code integrations - Common troubleshooting
- Integrating Airtable with external calendar applications
- Visualizing records from Airtable in Tableau
- Visualizing Airtable records in Microsoft Power BI & Power Query
- Integrating HubSpot with Airtable
- Using Zapier to integrate Airtable with other services
- Using Zapier's Multi-Step Zaps to find and update records
- Using IFTTT to integrate Airtable with other services
- Integrating with AWS Lambda & DynamoDB
- Herramientas para desarrolladores
- API
- Diseñador de Interfaces de Airtable
- Descripción general
- Diseños de página
- Elementos
- Adding and removing elements in interfaces
- Adding layouts to interfaces
- Formatting elements in interfaces
- Interface element: Button
- Interface element: Calendar
- Interface element: Chart
- Interface element: Filter
- Interface element: Gallery
- Interface element: Grid
- Interface element: Kanban
- Interface element: Number
- Interface element: Record picker
- Interface element: Text
- Interface element: Timeline
- Aprendizaje y recursos
- Gestión de Airtable
- Política de Airtable
- Registros de Airtable
- Sincronización de Airtable
- Vistas de Airtable
- Espacios de trabajo de Airtable
- Impresión
- Compartir
- OscuroLigero
- PDF
Number-based fields in Airtable
- Actualizado en 02 Dec 2024
- 4 Minutos para leer
- Impresión
- Compartir
- OscuroLigero
- PDF
All plan types | |
Platform(s) | Web/Browser, Mac app, and Windows app |
Related reading | |
Airtable terminology | Field type - A field type specifies the kind or format of data stored in a given field — for example, long text, date, multiple select, or attachment. |
Note
Numbers with 15+ digits are not recommended for storing in Airtable records because they are automatically rounded up.
We recommend using a text field in these cases, as it is not possible to use the ROUNDDOWN or other formula functions to return the initially entered number.
Autonumber fields
Autonumber fields automatically generate unique and incremented numbers for each record. Autonumbers can be helpful when you need a unique identifier for each record or when using a formula in the primary field.
Note
Autonumber fields are not designed to count the number of records in a table. When a record is deleted, the remaining records are not re-numbered—leaving gaps in the numbering. To re-number an autonumber field, either delete and re-create an autonumber field or convert it to a different field type and then revert it to an autonumber field.
Check out our Airtable Community for more info and suggestions for conditional auto-numbering.
Adding autonumber fields
Visit your Airtable homepage.
Create or open your preferred base.
Add or edit a field.
Search for and select Autonumber, then click Create field.
Currency fields
A currency field is a specific type of number field that formats the number as a currency amount. You can specify a currency symbol (the default symbol is $), the number of significant digits, and whether or not to allow negative currency amounts.
Note
Airtable doesn't support using multiple currencies within the same currency field.
Adding currency fields
Visit your Airtable homepage.
Create or open your preferred base.
Add or edit a field.
Search for and select Currency, then create Create field.
You can optionally update the default settings by clicking Formatting.
Lastly, you can set a default field value for every new record created within the table by clicking Default and entering your preferred number.
Percent fields
The percentage field type hosts numerical values formatted as percentages. The values in a percent field are shown as fractions of 100 with the percent symbol. For example, .75 in a percent field is represented as 75%.
Note
For a more general-purpose numeric field type, try a number field to represent integers or decimals.
Percent fields created before May 2019 were stored using a format are now converted to number fields. Read more about this change in the number legacy section of the Number field type article.
Adding percent fields
Visit your Airtable homepage.
Create or open your preferred base.
Add or edit a field.
Search for and select Percent, then click Create field.
Number fields
The number field type is a field type designed to hold numbers. The number field type is a general-purpose field type for most numerical values, like the number of chairs of a particular type your furniture business has in stock, or the distance from one city to another.
Adding number fields
Visit your Airtable homepage.
Create or open your preferred base.
Add or edit a field.
Search for and select Number, then click Create field.
You can optionally update the default settings by clicking Formatting.
Legacy default values in fields
Legacy field values
Single line text, number, currency, and percent fields in bases created before January 31, 2024, offer the option to toggle on/off "Apply default value for all actions."
Any fields displaying "Apply default value for all actions" rely on a legacy default value used inconsistently. You can toggle "Upgrade to consistent default value behavior" on to address the previous inconsistencies.
The following scenarios did not use the default value for legacy fields but will after enabling "Upgrade to consistent default value behavior:"
Using the Airtable automation action: Create record without specifying a field value.
Using public APIs to create a record without specifying a field value.
Submitting a form without a legacy field.
Importing a CSV without specifying field mapping for the related field.
Rating fields
The rating field allows you to rate your records for ranking or quality assessment.
Note
Users on paid Airtable plans can update the style of the field's rating symbol from the default yellow star.
Adding ratings fields
Visit your Airtable homepage.
Create or open your preferred base.
Add or edit a field.
Search for and select Rating, then click Create field.
Note
Hover your cursor over a record in a rating field to show the maximum number of symbols in gray. To give or change a rating, click the appropriate number of symbols.
Formatting number-based fields
To access formatting options in number-based fields:
Click the ⌄ icon next to the name of the number-based field you want to format.
Then, click Edit field.
Next, click on the Formatting tab.
From the formatting tab, you have a variety of options to choose from: Format, Presets, Decimal places, Thousands and decimal separators, the option to toggle whether to Show thousands separators, and Large number abbreviation.
After configuring the format of the field, you'll see the option to "Preview" the output at the bottom of the field configuration window.
FAQs
What is the max date that can be stored in a date field?
The max date for a date field is 12/31/9999.