Ask the Community

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

Hi everyone,We’re a creative/production agency and over the last few years we’ve progressively evolved from using Airtable as a simple operational tool into building a much deeper internal management system.Today we have an ERP-style workflow in Airtable for Purchase Orders: Purchase Orders (POs) Invoice receptions Payment tracking Approval/payment status flows Linked operational and financial information The system is working well operationally, but now we’re trying to solve the next layer:connecting our Airtable PO system with the Google Sheets budget file of each project.Each project has its own Google Sheets budget where production teams manage budget allocations and spending. What we want is to create a bridge between: structured financial/operational data in Airtable and the budgeting workflow inside Google Sheets Our goal is:when someone imputes/allocates an expense in the budget sheet, that expense should always be linked to an existing PO from Airtable.We’re currentl

Hello all,I was looking in the forum, I didn’t find anything really matching this query, so here I am.Idea: have a single dropdown menu to choose an option and once it is selected the user clicks on a button to display a form (form associated to the option selected on the drop down menu).Notes: initially, no intention to use anything outside portals interface, I know there are tools out there, really good ones, with a lot of interesting features, but right now I want to know if I am hitting a portals UI limit or if there is a solution or kind of solution available within the AT platform.I am just asking if someone got hit by the same idea/issue and found a solution. It is also valid if I hear feedback like… “I tried everything, omni, script… nothing worked, ended up with fillouts”. That’s also a valuable info and I really appreciate it.Alternatively, I was thinking on play around with forms/add record pages and play with conditional visibility to adjust the form fields based on initial

We use Page Designer to generate a short price list (30 to 50 pages). This doc has images and text and, until few months ago (Sept 2025), the file size was less than 2MB.We recently added some procuts and we added some rows to this price list: the file size bloated to 30MB!We follow the same process of printing with “good” (not “best”) image quality before exporting a pdf. We also tried removing the images, printing black and white or rededesegning from scratch the document.I fear something changed in the back-end...If that was the case, it’ìd make page designer useless to us. Anybody else with the same experience? Or ideas on how to fix it? Thank you

There have been a couple of issues reported like this with no answer and are now closed for replies, so I’m making a new one. Airtable is great, love using it, but this very basic interaction of scrolling is quite frustrating. The scroll seems hard-coded to move a fixed number of rows. Currently on a normal 16:9 screen for me, this means what used to be the bottom row is then off-screen up above after I scroll, and that’s with rows that are just 2 lines tall. The simplest fix seems like it would be to decrease the hard-coded number of fixed rows that move with each scroll. Less simple but probably more adaptive would be to adjust the number of rows per scroll based on row height and how many are visible on screen, to ensure that the bottom one becomes the top one.I’ll take even the simple fix!

I have a problem when i try to download media files (videos) from my data sheet on my phone(pixel with GrapheneOS) i can’t i don’t get a popup and i don’t get any information why. I gave all the permissions to the app and it still doesn’t work. When i click share i get a popup with a name of the file and a progress bar that is half full and it never moves. Can someone please help i need to move media files across multiple pixel devices and from multiple people contributing so this would really help but just doesn’t work?

I’m having an issue getting a hold of sales/support. I’m on a team account right now but was planning to possibly upgrade to incorporate Airtable fully into my business but I can’t seem to get a hold of anyone real. I’ve emailed the sales department twice and I get confirmation emails from what I thought was a real person but I’m assuming it’s AI because they never respond once I email back my availability for a call. I’ve also tried the support chat function but it seems like that button does nothing for me.  

I have created a base for cataloguing books/manga. The problem I’m having is with audiobook narrators. When a book is logged, they sometimes have two different narrators. They log the narrators names and the strengths and weaknesses of each narrator. For a specific example, lets say there are two narrators. Narrator 1 is Julia Whelan and Narrator 2 is Will Damron. Narrator 1 strengths (a multi select field)  “Distinct Character Voices” and “Emotional Resonance”. Narrator 2 strengths are “Good Articulation/Pronunciation” and “Good Rhythm and Pacing”. Then the information is supposed to go to a narrator table where it logs this information. Because they narrate multiple books, these strengths can be added to with other books. The issue is that as far as I can figure, a lookup field won’t work because they need to apply to only the correct narrator. A rollup has the same issue. I can do it via automation but that gets really messy and complicated because it will create extra little bubble

I have an editable linked field in a record detail. How can I set the display order when selecting the record to link to?

We need comments to remain. Is there a way of either turning off ‘resolve’ comments capability, or, displaying resolved comments? 

Hi all,Currently thinking of getting an Enterprise Scale licensing for the organization and interested in using the Enterprise SSO to integrate with our Entra ID tenants.I have read the documentation, and the configuration looks straight forward but have a question when it comes to multiple Entra ID tenants.With one Airtable organization (If this is the right term to use), can I have 2 Entra ID tenants connect to it with SSO? (Example: I want OrganizationA Entra ID tenant and OrganizationB Entra ID tenant be able to log into the same Airtable organization. Or do I need to use Enterprise Hub in Airtable overview ?Thank you for your assistance and help.

So far, I haven’t had any trouble entering text and currency into Airtable bases, but I’d like to calculate simple overall percentages from my data. I’ve looked everywhere and can’t figure out how to do it in Airtable.I know how to do it at the row level, but I don’t know how to calculate it for the total data. For example, I have values in Column 1 and Column 2, and I need to sum all the data from Column 1 and all the data from Column 2, then divide them to get the overall percentage. Im trying to do this in the interface view too, but its imposible.I’m starting to think that it’s not possible to calculate simple total percentages in Airtable. Or am I missing something?Thanks very much in advance for any help with this.

I’m having an issue with a formula that rounds up incorrectly, i’ve browsed the forums and can’t seem to find a solution.I have a simple math equation x * y = zI suspect that the issues is stemming from a formula that contains four decimal points:I’m not able to round up this number, however, it needs to remain as is.  I’m not sure how to get a correct calculation using airtable. 

Hello all.I’m looking to have a column (field) of field agents run/process once a week on a Monday morning. FYI these agents a prompted to go out to the internet and retrieve x information. There are no automation options specifically to do this - am I missing something or how else can this be achieved?Currently I’m thinking about having an automation that changes a field in each record (say make it today’s date), and that is something the field agent is monitoring to kick it off and run. Feels a bit hacky, but if anyone has better ideas please let me know. 

I have setup an automation so when someone emails a purchase request, it makes a record and notifies me in Airtable, however it doesn’t look like there is away to email an attachment and have it populate the attachment field. Is this possible?

Does anyone have or know of this?  I would love a quick reference to consult when  building an interface page so I dont have to realize halfway through Ive used the wrong layout and have to start over.  If no one has one, Ill create it and post it-Thanks!

Hello,I am currently setting up an automation to send an email when a form is submitted. I had also created an extension page that is a confirmation sheet of sorts for clients that auto-fills information based on what information is submitted via the form in question. I was wondering if it is possible to attach this extension to an email automation. Or even automate this sheet to send on it’s own without an attached email message.Thanks!

Someone on my team ran into an issue on a form where their selection on a rating field is not being retained visually on dark mode. See example of dark vs light: Thankfully the value is still being retained by the form on the backend, so this isn’t a game breaking bug, but it is definitely an annoyance for the people on my team. While this is probably a known issue, I figured I’d report just in case. Hopefully this is a simple fix. Thanks!Josh

Hi everyone,My workspace is on the Business plan and the latest invoice was successfully paid after a prior failed payment.The workspace billing page shows:Plan: Business Invoice status: Paid Invoice amount: $54 Subscription status: Active Automation run limit: 100,000 per invoice periodHowever, the Usage page still shows 100,000 / 100,000 automation runs, and automations remain blocked.It looks like the billing entitlement was refreshed, but the automation usage/block state may still be stuck after the failed payment.Has anyone experienced this before?Does Airtable automatically refresh this after some time, or does Support need to manually reset/remove the automation block?I already contacted Airtable Support, but I’m asking here to see if anyone has seen the same issue and how it was resolved.Thanks.

Hi! I'm a newer Airtable builder working on a CRM for a small business client. They’d like to automatically extract action items from emails. Gmail integration — pulling the email body directly into a record and using AI to parse out action items » Seems like extra work for the client to copy and paste email body. PDF attachment — client saves the email as a PDF, attaches it to the opportunity record, and Airtable parses the action items from there. » Can airtable do this? How well does it work?Has anyone done either of these? What actually works well in practice? Open to native Airtable features, automations, or third-party tools. Thanks in advance!

Hi all,I am having trouble with a nested “IF” formula which I believe is correct because when I enter it into the formula field, it is accepted and saved. However, when I then click on “Edit field” to view the formula, it has “self-changed” the formula to something else. This is my original formula which the formula field is accepting:IF({Transaction Status} = "Order Filled", IF({Transaction Type} = "Sell", ({Total Cryptocurrency Value USDT}-({Value per Buy Cryptocurrency USDT (from Linked Buy Transaction (From field: Linked Sell Transactions))} * {Amount of Cryptocurrency})) * 0.35), IF({Transaction Type} = "Buy", IF({Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} = {Total Cryptocurrency Value USDT}, ({Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)})-{Total Cryptocurrency Value USDT}) * 0.35, IF({Total Sell Transaction Values USDT (from Linked Sell Transactions from Transactions)} < {Total Cryptocurrency V

Hi, we need to set up an attendance tracker (I know how to do the student and class dataset) for teachers to track students attendance in three activities each afternoon (same teacher tracks all three, and there are 6 teachers / classrooms). I know how I could do this in the form but are limited to each student with the three activities. I want to give the teachers a form to fill it that looks like a excel table, with all the students names on the left, and the three activities on the right for them to mark as present, absent, or partial. We do not want to use a portal as those are expensive. Will I need to use another application on top of this to do it? If so, which one if we want one place that the teachers go to for a drop down list of their classrooms, and then to fill out the matrix. In addition, how would you set up the attendance data table in airtable. Thanks!

Hi,I’m pondering how to build an automation’s “Find records” step when the “contains” direction is seemingly wrong. Apologies for the perhaps convoluted question, this was difficult to write :).I trigger the automation from a Project with a button and want to find the Contact linked to that Project, using linked RecordIDs. One Contact can have many Projects, but one Project only one Contact.The Find step now has “Contacts” as its table, I think obviously. But then the order of my conditions is that the first variable refers to “Contacts”, and the second to “Projects” where the trigger button is.I wanted to look for the Contact that would contain the Project’s RecordID (I have linked that data), but instead I can only look for the Project which contains (or “is”) the Contact’s RecordID. But since there may be many Projects to one Contact, “contain” would not work I guess.I want to reverse this logic or somehow look for the Contact that contains the given Projects ID.How could I go about

Context: I am using the Forms interface, not form view. I previously published this form, then we redesigned it and removed a field. I am getting this error, while in editing mode, that says “The form cannot be submitted because some of the fields have been deleted.” The field was deleted from this table, how do I remove this from my form so it can accept submissions?   

I have a lovely interface page where my engineers can view their project statuses and review and request PTO and work from home days.  We work limited hours on fridays in the summer, but one person stays until 5pm for department coverage.  We rotate who stays late every week, and I want to display who’s turn it is on their interface (using a formula field, week# of {scheduled date} = week# of this week) .  Is there an element to achieve this?  The number element can already display a field value based on filtering conditions.  I’d love for it to display a text value as well.  I don’t want to eat up screen real estate with a grid element just to display 1 person’s name.  Surely there’s a way to do this...