- 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
Grouping records in Airtable
- Actualizado en 07 Mar 2024
- 5 Minutos para leer
- Impresión
- Compartir
- OscuroLigero
- PDF
All plan types | |
Owners/Creators/Editors | |
Platform(s) | Web/Browser, Mac app, Windows app, and mobile apps |
Grouping records in Airtable overview
Grouping records in Airtable allows creators to build a set of one or more conditions that will help to categorize the dataset that is being presented within a particular view.
Common examples include grouping by:
User field (Enterprise plan only)
Multiple conditions create deeper categorization by adding collapsible subgroups within each group of records. When combined with other options such as record filtering or sorting, this allows you to create hyper-specific organization and insight into the records contained within a set of data.
To create a group in a view:
To group your records, open up a view and click Group located between the filter and sort buttons. Select from the suggested fields or click See all fields to choose from all available fields.
![](http://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/grouping_find_menu_03092023.png)
To add record subgroups:
Once you've selected the field you want to group by, groups will automatically be created based on the unique values in that field. New groups will similarly be added automatically whenever a new, unique value is entered in the designated field. You can also group your records by multiple fields by clicking the Add subgroup option.
![](http://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/group_add_subgroup_03092023.png)
Additional group configuration options:
Collapse or expand all of the groups in the view
Change the field referenced in the group or subgroup by selecting from the dropdown options
Change the sorting order of a group or subgroup by selecting from the dropdown options
Choose whether to show or hide groups with no records
Delete a particular group or subgroup
Drag a subgroup to move its order of grouping
![](http://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/groups_options_walkthrough_03092023.png)
Dragging between groups to reassign values:
You can change the values on a record in a group by clicking and dragging the record to a different group using the drag handle on the left side of the record. For example, you could drag a task assigned to one person to another person's group, and that task would automatically be re-assigned to the new person.
Note that you cannot add new records to a grouping that is based on a computed field type (like a lookup, rollup, or formula field).
Grouped records and the summary bar
There is a summary bar at the top of every group which can summarize the cell values in numerical fields by each group. These summary bars let you see the subtotals of each grouping. Every grouping will also have a count of the number of records in each grouping.
Much like the summary bar for the whole table, the summary bar for each group can provide different summary functions.
Grouping records within a date range
To group records within a date range:
If you want to group your records within a date range—for example, to see every transaction record that was made by week, or every deal by the quarter in which it occurred—you can create a formula field with DATETIME_FORMAT() and group on that formula field.
By using different format specifiers in your DATETIME_FORMAT() formula, you can group by day of the week, week of the year, month, quarter, and more.
Alternatively, instead of using the DATETIME_FORMAT(), you can also use the preset YEAR(), MONTH(), WEEKDAY(), or WEEKNUM() functions. You can read more about these functions in the formula field reference article.
NOTE
If you choose to group on a date field that includes a time field, you will group by both the date and time. If you aren't looking to include the time in your grouping, we recommend creating a separate formula field to parse just the date and grouping by that field instead.
Example 1: Grouping records by week
Let's say that you have a table of sales conversations, and you want to be able to group the outreach records by week in order to get a sense of how much outreach you've done each week for the past few weeks.
If you try to group on the Date field, only conversations that occurred on the same day will get grouped together. To group on the week instead, you'll need to make a formula field using DATETIME_FORMAT(). DATETIME_FORMAT() requires you to specify a date field (which we already have) and a format specifier, which determines the output of the formula. ( You can find a full list of our supported format specifiers on this page.)
Since you want to group on the week of the year, and the format specifier for the week of the year is 'w', you write this formula:
DATETIME_FORMAT(Date,'w')
Now, you can group on the newly created Week No. field to see all the outreach events grouped by the week in which they happened:
Example 2: Grouping records by year and quarter
Let's suppose that you have a table of closed deals spanning multiple years, and you want to have some way to see the total size of the deals made by quarter AND year.
To create a DATETIME_FORMAT() formula field that groups on quarter, use this formula:
DATETIME_FORMAT(Date,'Q')
However, if you just group on this new field, records from different years (but the same quarters) will get grouped together. The solution is to create a second formula field for the year:
DATETIME_FORMAT(Date,'YYYY')
If you create two layers of grouping (first grouping on Year, then grouping on Quarter), you can take advantage of the grouped record summary bar to get valuable data insights.
Using grouped records to create record reports
Sales pipeline example:
You can use the grouped records feature to create reports in Airtable. For example: suppose you have a sales pipeline in Airtable.
![115017111548ScreenShot2017-07-11at11421PM.png](http://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/115017111548ScreenShot2017-07-11at11421PM.png)
If you use the group records feature, you can group by which sales opportunities closed successfully, by lead type, or any number of other criteria (depending on what your table looks like, of course).
![115017020407ScreenShot2017-07-11at11520PM.png](http://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/115017020407ScreenShot2017-07-11at11520PM.png)
Notice that when the records are grouped, the summary bar shows separate summaries for each of the groups and sub-groups. You can pick from a variety of different possible summary functions (e.g. median, range, standard deviation) depending on the type of field.
In this example, the summary bar shows us the total number of successfully closed deals, the average amount of those closed deals in dollars, the earliest date of last contact for closed deals, and the median number of licenses sold in each successfully closed deal.
![115017111808ScreenShot2017-07-11at11944PM.png](http://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/115017111808ScreenShot2017-07-11at11944PM.png)
These summary functions will show for all of the different groups of records, so you can compare and contrast between groups. Looks like we failed to close some pretty big deals...
![115017020587ScreenShot2017-07-11at11704PM.png](http://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/115017020587ScreenShot2017-07-11at11704PM.png)
You can drill down even further by adding another grouping (and another, and another...).
For many reports, grouping on a date range is particularly useful—for example, if you want to group records by the month, year, or quarter in which they occurred. If you're interested in learning more about groups based on a time range, then consult the section above.