Connect, collaborate, and solve questions about using Airtable in Ask the Community.
Recently active
Hello! Is there a setting you can do on AT so that videos buffer when trying to watch them on the app? Rather than piecemeal as you watch them. It makes watching videos in AT pretty painful. You have to let the video basically stutter and buffer. There's no way to let the whole video buffer and then watch it
Hi guys, I am on the business plan of airtable and it shows that i can add 125,000 records in airtable.But when i try to upload the cvs file containing 95k records, it shows me only 45k.I tried to divide it into chunks and add it but still nothing, deleted the base and tried again, still nothing.Whatever i do, it shows me 45k records only.
I’ve been experiencing glitches/slowness whenever I try to work with the Find Records step within an automation. I try to insert a dynamic value (blue plus icon) for either Record ID or as value for the selected field, and the page freezes, and I have to check back in later for it to sometimes work. I’ve been experiencing this for many months, and across different bases, and I was wondering if this is something that others have also faced with the Find Records action within the Automations tab!
Hello,I linked Table A.field5 to Table B. Table B contains several fields: field1, field2, field3, etc.I changed Table B.field3 to make it the primary field and hid all the other fields. Unfortunately, in the dropdown menu for Table A.field5, all the fields from Table B still appear.I also tried creating a view, but I get the same result.My question is: is it possible to limit which fields from Table B are displayed in the dropdown?Thank you for your help ( i am a beginner)
Overview: I have a base that tracks Email Build requests for our developers with users that work across multiple time zones. I’m looking to add reporting on lead time, comparing ‘Created Date & Time’ to ‘Due Date’.Base Setup: Tickets are submitted via form, which captures Due Date on a calendar - this doesn’t ask for a time, so Airtable seems to default to covertly storing the time as the moment that selection was made, in GMT. All other times are currently set to show in the users’ own time zone, but I can standardize that to Pacific if needed. An automation populates the Created Date & Time of the ticket.Need: I’m looking to report on the lead time, but the Due Date should not be counted as a workable day, so I would like that date to always default to 12:00 am (or 00:00:01). The output should be shown in Hours, not Days, as the SLA is 72 hours and that’s not being adhered to. I first worked through this with ChatGPT and I wound up creating a formula field called Due Date Mid
Hi everyone,I’m using Airtable to manage a large inventory with lots of photos attached to records. When I ry to share pictures.I have two questions:Permanent URLs: Is there a way to get a permanent/public URL for each photo that won’t expire? I’d like to use the photo URLs in Google Sheets/Excel and potentially share them with others. Bulk download: Is there a simple way to download all the photos from an Airtable table at once, ideally preserving the original filenames and/or linking each photo back to its Airtable record?I’m looking for a solution that doesn’t require downloading each photo manually.Thanks!
Hi there, We created a view for a dashboard that is a calendar that populates who is ending on what date throughout the month. However, now we would like to add an additional button where we could click it, and an automated email will go to the trainee and the mentor 30 days before the end date is to make sure they are actually departing on that date. How would we start building that?
There are many many frustrations since we’ve upgraded our Airtable, there are seemingly low level tasks that Airtable and Omni is unable to do, yet it boasts being able to build an entire base. Extremely annoying. I just wanted to list a few here.Why can we restrict record selection on an interface for clients on a linked file but not on a single or multiple selection? Why can’t we put a prompt into Omni to hide or show columns? This is very helpful if we need to add a same view to other like bases but it’s not able to hide or show columns? Why can’t we copy an interface and then change where the linked data is coming from? This is a HUGE problem that was misrepresented by Airtable. We thought we could make a linked base, and link the views so that all our clients could use this linked base. Only to find out I’d have to manually set up each interface one by one, over and over again because Omni does not work, and the option to change where the data is pulled form is greyed out PORTAL
Hi there,Long text fields can - as the name says - have a lot of text in them. In an interface, the field just extends to the full amount of text. This is very difficult to scroll then. Could there be a scroll bar added?The AI long text field does already have the scroll bar, great!Happy to see it on the “normal” long text field soon!Best, Chris
In the “Grid View” in the app (on Ipad), where the submitted data is displayed, I don’t seem to be able to control font size. It makes the app relatively useless for my intended purpose (see screenshot below).System-wide font size adjustment on the device makes no difference in the Airtable app (same problem on Iphone). Is there any way to adjust font size?I noticed i don’t have this issue on Android, where system-wide font size adjustment works in the Airtable app!
I have been struggling for two weeks to set up a portfolio of projects in Airtable. I have a product that has multiple features. Those features have several projects each.I’ve completed all the training videos. None of them addressed this. I attempted to use the Project Portfolio Management template but it seems to be driven by the project goals which aren’t important for my team as we are not the product/project owners so have no need to track. I also don’t need to track at the task level--just the overall projects status, when sign-off and hand-off occur and, if possible, the status of Jira stories associated w/ each. Read an Airtable article regarding one or multiple bases. Didn’t really get me any closer. Any recommendations on how I should proceed?
My goal is to set up Airtable for other people to use.Not all of these people will have the same information in their tables They’re not tech savvy, so I’d like to be able to set up a table for them on my account, and allow them to access and alter the data of their own table via a client portal. If in the future they’d like to move everything to their own Airtable account, I’d like to be able to export the table somehow.I looked online for tutorials about client portals, but they seem to focus on filtering the same types of information for different clients to see. That won’t work for me, because the purpose of each table is different.For example, Person A needs an Airtable database of employees. Person B needs a database of equipment. Person A doesn’t have equipment and Person B doesn’t have employees. I need both persons to be able to access their tables and add/remove information as needed.Is there a way to accomplish this? Thanks in advance!
Why is there not an “is any of” when looking up an array. id assume it's not possible?
Hello, Our leadership uses reporting dashboards for visibility on projects happening amongst their teams. There has been a request to send these in an email - however, we want to avoid any links that need to be clicked and would rather the interface images themselves populate in the email. Is this something that can be done? Is it possible to do it without a third-party application? Thank you!
How far can Omni go?That's the question I set out to test. Why bother, when Claude working through Airtable's MCP server already does so well? It's great, and I'm a fan. But not every organization can allow a connected outside LLM for security reasons. If you work under those limits and still want an LLM helping with your design and dev work, Omni is the one you'll be using.What I testedOne of my most requested builds is what I call a Sync Method: a script that takes data from several sources and combines it into one operating table. For each source, rules decide whether a row creates a new record or updates an existing one, and every load is logged.I gave Omni a real change request for one of these builds. Certain records are manually flagged with a status. When a later load overwrites a key field on a flagged record, the status should reset, and the old value should be appended to a history log so repeat events build up over time.The tricky part is that once the new value is written,
Hi everyone, I have been stuck for over 6 hours trying to get my Airtable "Update Record" node (Node 4) to write data back into my base. The workflow executes completely successfully with 100% green lights, but the rows in Airtable remain completely blank. Here is my exact configuration for Node 4:1. Base & Table: Correctly connected to my target base and table.2. Mapping Column Mode: Set to "Map Each Column Manually".3. Columns to match on: Kept completely empty/cleared out.4. Values to Update: - id (using to match): {{ $json.id }} - Article_Status: Done - AI_Response: {{ $node["Basic LLM Chain"].json.text }} Both the schema names ("Article_Status" and "AI_Response") match my Airtable column headers exactly with the correct underscores. When I click "Execute step" or run the full workflow, n8n shows a successful run, but nothing updates in rows 15 or 16 of my Airtable sheet. Since n8n isn't throwing an error code, I am unable to trace why the data payload is silently droppi
Hi,Just a small lifehack - how to get PRODUCT function with Rollup field,using LN(A*B*C)=LnA+LnB+LnC, and SUM( ) as aggregate functionYou need to add LOG(Number, EXP(1)) field in Source table and EXP(Sum) in result You can use base 10 as well, LOG(Number), and POWER(10,Sum) with the same result
Column freezing is about as core to a table as sorting or filtering. Every spreadsheet tool has it. Grid View has it. List View... somehow... does not.I only found out the hard way: built out a List View exactly how I wanted it, only to discover afterward that I couldn't freeze a column.I unfortunately can’t "just switch to Grid View". I use List View specifically because it replaces the bulky, ugly default card for linked-record lookups with a clean Select field instead. So the assumption that column freezing/pinning is a Grid View specific need doesn't hold up. Anyone with a wide List View is going to want to keep key columns in view while scrolling, same as they would anywhere else.If you've hit this too, drop a 👍 and a reply with your own use case. The more visibility this gets, the better the odds it actually gets prioritized.
Hey everyone, I’m at a bit of a stand still with moving forward on an email request. Essentially, projects are being reported as incomplete when a link isn’t generated in the records interface. However, some projects don’t require URLs. We don’t want to encourage people to put “N/A” in the field (for fear they’ll default to that versus best practice), but it’s been difficult to figure out a workaround for generating the automation email while not have validation opportunities to say “in the case that this request is a certain type of request it doesn’t need the url”. It’s possible my brain has just become fried but I’m not super sure how to accomplish this - any help would be appreciated! Thank you!
I’d like to add an action at the very end of my automation that sends me an email once the repeated action block is done running. Is there a workaround way to do this?
When calling the Airtable MCP server (https://mcp.airtable.com/mcp) over Streamable HTTP with OAuth 2.0, the tool calls list_workspaces and list_bases succeed (isError = false), but the CallToolResult carries the payload only in structuredContent. The standard content array is returned empty.What I observe:- list_workspaces: content is empty, while structuredContent contains the actual workspaces.- list_bases: content is empty, while structuredContent contains the actual bases.- The OAuth access token is valid; the calls are not errors.Why this is a problem: per the MCP spec, when a tool returns structuredContent it should also return a functionally-equivalent text block in the content array (a serialized/text form of the same result), for backward compatibility. Any MCP client or model that reads the standard content array sees nothing and concludes the tool returned an empty result, even though the workspaces/bases were actually returned in structuredContent.Request: please also popu
I am creating an Airtable database integrated with a Fillout inquiry form, for a sole proprietor advising business. My objective was straightforward:When an Inquiry contains a Contact and an Organization, update that Contact's Organization field with the Organization associated with the Inquiry.The current interface required interpreting Record ID as the specific Contact to update, selecting an Inquiry Contact field to supply that record, and then understanding that another Organization field represented the value to place into the Contact's Organization field. The repeated use of field names while the instructions referred to records made the workflow unnecessarily ambiguous.Recommendation: Use Task-Oriented Language in the “Update Record” AutomationThe Update Record automation interface relies heavily on database terminology such as Record ID, Fields, and dynamic field tokens. While technically accurate, the terminology does not clearly communicate the sequence of decisions a user mu
Anyone heading to Airspace London next month? I’m looking forward to meeting those that can make it. If last year is anything to go by then it should be a good event!
Today I faced the following problem. Omni widget blocks the page. Pressing Back to Omni button doesn’t help. Is anybody experiencing a similar problem?
I am using a Pivot table to summarize student attendance records by month. The pivot table pulls from an ‘attendance’ table in which each record is a class session, and the students present are listed in a linked field. The pivot table has rows of student names, and columns of class session dates. (screenshot attached). “1” indicates that student was present. Grey bar indicates absent. I’m using these settings not exactly as intended, but this way makes the formatting most legible for staffmembers who aren’t versed in AirTable. Is it possible to display a total # students in each class session? When I select ‘show totals’ in the pivot table settings, it shows the total # records, which doesn’t always equal the total # students present (See screenshot) I’ve created a rollup field which calculates this number, but I can’t integrate that field into the pivot table. Any solutionsmuch appreciated.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.