Ask the Community

I am very new to airtable so excuse me if I misunderstand some things.I am trying to use airtable to create a calendar of my bookings.I have two types of bookings. One that lasts exactly 30 minutes and one that lasts several days and start and end time are customizable.Because its a chore to pick a date and time exactly 30 minutes past the start time for my short bookings Im trying to run an automation so that anytime I create a record with no end date it will set the end date field to exactly 30 minutes past the start date.Is this possible?  

Hi AirTable Community,I’m looking for a simple vocabulary or terminology cheat sheet for Airtable that defines core terms like bases, tables, fields, views, records, interfaces, automations, etc.Does something like this already exist—either from Airtable or from the community? Ideally something that could help new users quickly understand the platform language. Thanks! Rebekah

Hello everyone,I am currently developing a base which will allow one of our departments to plan employee trainings (which will be conducted via Microsoft Teams).  Tranings can be planned and employees can be linked to events (via a Employee_Training table).Part of this solution should be, that after the event has happened, the business department wants to track, which of the invited collegues took part in the Teams meeting.So I would need a way to get the attendance list of a Teams meeting, cross reference this list with employee list in Airtable (propably via email) and then mark them as “show-up” if a match is found.Has anyone ever done something like this or has an idea how to achieve this? I appreciate all the support I can get. Thank you in advance. Best regardsChristopher 

This is really more of a development & workflow request for help. I have around 60k Shopify variants across 8 different vendors. I get the vendors/suppliers produc master data at the UPC level via a CSV file, which I can import into a base. I want the workflow to to use the CSV base to search for matching UPC’s in the supplier/vendor base. If a match is *not* found then the records needs to be added to the supplier base then synced to Shopify. If the UPC *is* found in the supplier base then the records needs to be updated. There will be many deafult values if a new record is added, and mapping rules which would be different for each CSV base.I would appreciate anyone interested in a project of this type. Thanks

Hi,I’m new to airtable and I try to make a script triggered from a button field. I need to get the selected record linked to the button clicked but could not find how to achieve this.I can’t believe there is no way to get the current record id from the script, what am I missing?Thanks.

Hello, I want to build something and need your thoughts on it.We have seventy technicians who need to conduct an inventory of their vehicle contents once a year. I would like to map this using Airtable. I have the data of the technicians in another database, which I sync into the new base. Now the contents from an Excel file (each technician naturally has a different one) must be copied and pasted into Airtable. The inventory should then be able to be conducted. Each technician should only see their own data (this can be done easily via the Airtable ID). The technician should confirm at the end that the inventory is complete and then no longer be able to make changes. I am only missing the basic concept of how to best structure the base. I have an idea, but I am not sure if it is wise. Therefore, I would appreciate brief bullet point input from you. Many thanks! // Update ;) I can answer the first question myself right away. I would filter the view

We use Airtable Interface to match caregivers to clients based on required skills such as Alzheimer’s care, hospice experience, and Hoyer lift. Multi-select fields are the best structure for this type of data because they are clean, scalable, and easy for our team to maintain.In the Interface, we use multi-select dropdowns such as “Skills and Experience” to narrow down caregivers. However, when selecting multiple values in the dropdown, the behavior uses OR logic instead of AND.For example, if we select both “Alzheimer’s Care” and “Hospice Experience,” the results show caregivers who have either skill, not those who have both.In real workflows, we often need to find caregivers who meet multiple required criteria at the same time, such as Alzheimer’s care and hospice. The current dropdown behavior makes this difficult and not intuitive.We understand there are workarounds such as adding multiple conditions or creating helper checkbox or formula fields for e

Hi all I have an automation set-up, that changes the status of a record. This is performed via interface/record picker view. As owner/admin I am able to run this automation when clicking the button, however my colleague who is also an admin, is unable to click this button. It’s greyed out.  I understand there are some limitations if the record is coming from a different base. Does anyone know a workaround please?  Hope I’m making sense here… Thanks!

Buenos días, alguien tiene algún ejemplo de como hacer un control de fichaje de empleados con airtable? 

Hi all, I hope you’re well. I'm building a paid directory and I need to integrate invites link in my IT strategy.However, I'd like people who might stop paying the subscription to no longer have access to the directory (without deleting the invite link).Does someone know if this is possible ?  

The new custom interface feature is incredible, it’s unlocked so much functionality for my organisation but one thing that would take it to the next level is being able to place custom interface blocks inside of standard interface pages.Please add this one to the backlog 🙏

Hello !We have a list of contacts for each entity that we work with. Within this list of people, there are 1-3 people who are designated as authority contacts.I am trying to automate an email to send out periodic reminders to review their information. With a single auth contact, I have a working automation with links personalized to each person.This becomes harder when there are multiple auth contacts. I need the email to be sent to the group of people rather than individually. If I use a token to pull the URL value for the record, it’ll show duplicates of the URL in the email body. Anyone know of a way I can rework this or add to it to make sure that only one of the records’ values displays?

I would like to see the date instead of “5d ago”.  Is that possible? 

Where is the problem please ?4 Devise numbers. 3 differents formats  Same configuration for all the numbersHave a good day 

Am I missing something? Tell me there is a secret. Right now the Interfaces can show the record’s Activity Feed but not the Revision History ? The only place I can show it is if I use the side panel to open a linked record, those you can have the revision history at the bottom but that is it!! As far as I know.

Hi!I am building an activity planner for an organisation and trying to achieve an interface page that shows a timeline view, but with dates running along the vertical (Y) axis rather than the standard horizontal layout. The idea is that users can scroll up and down to see multiple records (activities) lined up side by side against a shared time axis.Has anyone managed to:Replicate this with a different interface element or creative field/layout setup? Use an embedded chart or third-party tool to achieve this? Build something similar using a custom page or external embed?Any workarounds, extensions, or even "close enough" solutions would be really appreciated. Thanks!

I absolutely hate not being able to see the column title name unless i want to make the column width 2084985 feet. While it seems simple in nature, this is why i prefer Smartsheet. I want to be able to have columns sized appropriately with legible column headers and not have to scroll over to view.

Hi there! I’m using Airtable to plan out the scenes of a story, and I love having the gallery/kanban view to be able to rearrange scenes within chapters. Right now I’m using a short description of the scene as the “title” for my kanban/gallery cards. However, many are getting cut off and making it hard for me to get a truly “at a glance” view of the scenes I’m working with. (I would post an image, but the interface won’t let me submit my question with one!) Is there any way to force the cards to display all cell contents on cards? Thanks!

We have a large volume of data in two tables (Facilities and Users) that we’ve imported via a HyperDB. We want to make routine updates from our company data lake into these two Airtable tables. There is linked data between our two tables (Facilities, Users). The updates don’t have to be instant - once daily or even a little less frequently is ok. It looks like this won’t be able to be done via a script - that it will require manual intervention via the browser tools, is this correct? Thanks in advance. Trying to point our development team in the right direction and are also open to help. 

Hello, I have built a table with links to spotify, Instagram, twitter and tik tok and I also include the number of followers of each of the artists in the table. I update this data by hand and I would like to know if there is a way to automate this update or to do it on demand for a previously selected group of artists. Thank you!

Field agents are currently not available in forms. Does anyone know if this is in the product roadmap?

I am learning Airtable and am with a new company as of November. I’ve taken many of the online classes to learn the system but am still encountering issues with a few things. I believe part of it is the way the current data and forms are designed. I don’t think they were too far off during the creation process. However, I’d love some assistance reviewing a few small items. I’m unable to change some forms and a few other oddities. The only person who knew the system has left the company. Perhaps a 15–30-minute call. I’m sure I’m overcomplicating things. Anyone with 30 minutes willing to help me out?

I’ve seen this has been requested for a long time now, but those feature haven't still seen the light. My team struggles a lot for the current interface limitations:Not being able to see the full text entered in a cell. This happens both in table and lists views. There is no current solution for this, unless people manually open the record, which is not always the possible solution when you're reviewing big tables that are text-intensive No font colors: this is something I do not understand. Why it is not possible to have font colors? There are rich text fields, with headings, bold, italics… You can event set a link that will color the text in blue. But no way to change the font color.Those limitations are embarassing when we look at how many powerful things we can do with Airtable. It would be great to hear from the Airtable team about those features, at least knowing if this is something that is being considered since I

En los botones de búsqueda dentro de la interfaz, actualmente solo se puede buscar por el campo principal de esa tabla. Por ejemplo, si tengo en la tabla cliente: como primer campo ; “ Teléfono ” . Como segundo campo; “ Nombre ”. Actualmente solo puedo  buscar por Teléfono, porque está establecido u  ordenado  como campo principal. No puedo buscar por nombre o otra categoría , aunque la vista previa si lo contiene. Sería posible de alguna otra manera, que no se unifique estos campos. ¿?Podrías hacer algo para que sea posible. 

I reviewed the following related topic but would like to do a quick check to make sure I’m on the right track…I work in natural resources but essentially have an inventory type question. I have locations (preserves) with sub-locations that I am tracking inventory from (both receiving and outgoing). I am still building my base and recently realized that I should probably move the locations into its own because multiple tables/records are related to the location AND it’s a bit more complex than a short list of 5 items. As I started building the location (preserve) table, the problem of sub locations came up. I’ve included a couple screenshots of how I have it setup at the moment. Does this look okay from a design/structure standpoint? Ultimately I will have seeds coming from these locations and plants going back to the same or different locations.