Connect, collaborate, and solve questions about using Airtable in Ask the Community.
Recently active
Can I add our Company Logo to Interface pages and add it to printed documents from the interface page?
Hi Everyone, I have a weird issue with Airtable Forms that I’ve been kicking around for quite some time and wanted to see if anyone else might have a similar experience. I have 2 different forms that I have for our Leadership team that allow them to submit the following content:Multiple photos or video, potentially bigger files (50MB - 1GB) Long Text field Questionnaire that require 4-6 paragraph responses 90% of the time, everything is received without issue, but more notably with the photo submissions, sometimes it doesn’t submit or create the record. I originally assumed it’s user error, where maybe they’re not waiting until they get the confirmation message, but I have Leads insisting that they submitted and saw the confirmation, yet nothing gets recorded. Quick note, I’ve had reports of this happening with both public-access users and Airtable users. This is not a new issue; I’ve been receiving these reports for ~2 years, but it never occurs often enough to be a big issue, and I
I manage a monthly image competition for a professional photography group that is presently managed in spreadsheets. I’ve created four tables and I think I’ve linked them, but the look up fields don’t always populate from the linked tables. Can I invite someone to look at my workspace and help me figure out what I’m doing wrong? Any guidance would be greatly appreciated!
Does anyone have a trick for generating consistent images with a field agent? I have a few collections that need to follow a template. Eg. Headshots on the same gradient background. What tends to work is what feels like a big bandaid: creating a table of ‘reference images’ and linking all the records in the collection to a template in the Reference table, looking up the file, and mapping it into the collection image field agent prompt. I have another collection where Im generating claymation style images, no template, but the output has drifted over time. I haven’t changed my configuration. Before I do the reference table setup, I wanted to see if anyone has a better solve.
Hi everyone, I hope you can help.I have an create record automation that enters the full name from the ‘sender’ field in email headers. I then have a formula field to display their firstname only. The formula looks like this:LEFT(TRIM({FullName}), FIND(" ", TRIM({FullName})) - 1) This is great when the ‘sender’ name field has the format:“Joe Bloggs” (Firstname[space]Lastname). However, some emails have the ‘sender’ name as “Bloggs, Joe”(Surname[comma][space]Lastname)or ... “Bloggs, Joe (Acme Ltd)”Surname[comma][space]Lastname[space][open-bracket)Company[closed-bracket]” I’m wondering if there is an IF formula (or similar) that would be able to deal with these specific differences, allowing me to extract only the first name?Very many thanks in advance. 🙏🏼
¡Hola a todos! Soy la fundadora de Crisla, una agencia de diseño web, automatización e IA. ¡Hoy mismo acabo de terminar la ruta de Introducción a Airtable en la Academia! Mi objetivo es usar Airtable en la base central de datos central de mi agencia. La estoy conectado con n8n y modelos de IA para automatizar los procesos internos de mis asistentes virtuales. ¡Un Saludo!
Hello Airtable Team, First of all, thank you for creating such an amazing platform. I've been building increasingly complex systems in Airtable for several years and I would like to share a few feature requests that, in my opinion, would significantly improve the platform for advanced users.1. Cross-base linked recordsCurrently, linked records work only within the same base.It would be extremely useful if a "Link to another record" field could reference records from another Airtable base.This would allow users to build larger "Life OS" or enterprise systems without duplicating data across multiple bases.It would also reduce duplicated data and improve data consistency across multiple business domains.2. Rollup → Range()A new Rollup aggregation function that returns the minimum and maximum values in a single formatted result.Example: 5–8instead of 58or requiring formulas afterwards.It would be useful for dates, prices, years and many other numeric values.3. Full-screen Record DetailOne
I’ve built out a fairly robust Jira replacement for our Agile team. This base has separate tables for Tasks and Sprints (among others). All Tasks have a Status, ending with ‘Done’ and all Sprints are either ‘Complete’, ‘Active’, or ‘Backlog’. My question is - what’s the best way to move any incomplete stories to the next sprint when I’m closing out the current one? I’d need to 1. Change current Sprint to ‘Complete’, 2. Change next Sprint in the current view to Active, 3. For any Tasks that are not Done but are in a Sprint that’s Complete, change them to the Current Sprint. I feel like that’s too many steps to tie to one button click, or that it would all happen too instantaneously for the stories to get moved correctly. I expect that this has been solved by others - does anyone have a nice solution?
I am looking to get help on structuring my base to track Deals, Tasks, and Subtasks without overcomplicating the fields and inputs. What I am struggling with is that some Tasks don’t have any Subtasks, so I created a separate “status” field for just Tasks. Right now I have Tasks and Subtasks in separate tables with Subtasks linked to their appropriate Tasks. This is fine, but it’s a little awkward and annoying that I have two status fields now at two different levels. Especially in interfaces. Why do I have a status field for Tasks and Subtasks? I want to automate when all the Subtasks are complete, then that parent Task is filtered out and no longer shows on my interface. If a Task doesn’t have Subtasks, then I need to have a separate status field for Tasks so when they are complete, they will also filter out when complete. In short, I imagine there is a solution or more efficient alternative given this is a very basic Project-Tasks-Subtasks structure that thousands of people probab
Well, after going back and forth with Omni for quite a while, I think I've finally reached the point where I need to ask about this specific scenario.I have a table where each record generates a unique 6-character code, something like X8MMA3.Now I'd like to create a public Form where the first field is simply a text input for the user to enter the code they've received separately (for example, by email). This code corresponds to a value in that table. The user doesn't see any other codes—it's not a dropdown or a linked record selector. It's just a plain text field where they type the code they were given.If the code exists, the user should be able to continue filling out the form and submit it. Submitting the form would create a new record in another table containing the user's inputs along with the code they entered.The key requirement is this: if the user enters a code that doesn't exist in the table, the form should immediately display a message informing them that the code is inval
Hi, i’ve tried to remove access on business leavers in the admin panel but users reappear within seconds - even if they are just viewers and have no ownership of workspaces & bases. These are also users whose google account are deactivated. Has anyone else been able to get around this? thanks,Gemma
Does anyone know if its possible to deploy custom interfaces (e.g. built with claude code) via github API. The github connector does not have this capability but wondering if anyone has done this via another route? thanks,Gemma
I have recently updated my iOS app to version 11.3 and since then no longer able to share PDF files via Whatsapp or open in Chrome. Does anyone have the same issue and any solutions around this?
Hello Airtable team,We have submitted our extension for review about 3 months ago and still haven’t heard anything back. We have issued 3 support tickets and tried contacting you but heard nothing back.Could you please share the status of the review progress? Anything we can do on our end to help speed things up?Here is the block submission id: recqvvvEko3vXqEqN
Hi everyone,I'm looking for the best approach for the following use case.We have a read-only Shared View that we share with an external agency. They should be able to update only one field (Status Massnahme), which contains multiple predefined single-select status values.We do not want to give them collaborator access or edit permissions to the base.My initial idea was to include a button or link in the Shared View that would trigger an n8n workflow to update the record. However, since there are many possible status values, I'm wondering if there's a better approach.Has anyone implemented a similar workflow?Some questions: Is it possible to let external users update only one field from a Shared View? Would you recommend n8n, Airtable Portals, Fillout, Interfaces, or another solution? If using n8n, how would you pass the record ID and let the user choose from multiple status values? Are there any limitations with buttons or links in Shared Views that I should be aware of? The goal
Hello - I’d be grateful if someone can help. I’ve started using Pivot tables in Dashboard Interfaces. One problem I have is that the table seems to occupy a default size and this results in the columns being too wide. I’ve put an example of a simple frequency table of fruits below. You’ll see the name of the fruit in each row is a long way from the corresponding count number. Is there a way to reduce the column width (or otherwise reformat) so that the label and number can be right next to each other (as in standard pivot tables in Excel/Sheets)? Thanks for any tips you can share!
I am trying and failing to access tables from Gdevelop’s “Send a request to a webpage” action.The action form looks like this: Naturally I am getting “401 Authentication required”, since I haven’t figured out where to place the PAT. I assume it goes somewhere in the URL, but where and in what format. Any help is much appreciated.
Hey All, I have been working on building an agent in Copilot Studio that can operate within Airtable. I have been able to successfully connect the Airtable MCP into Copilot and most of the tools seem to be working well. However, whenever I attempt to prompt the agent to update or create a record, it will get stuck in a loop where it asks for the fields I wish to update. If you try giving it the fields it will ask again and eventually error out.I am able to modify and create tables, create new fields, and update descriptions, but for whatever reason, I cannot seem to get it to create or update records.I am not sure if anyone else has had success getting this to work. Looking forward to any insight you may have.
Airtable doesn’t allow us to set an attachment size limit in Airtable forms. Why? This is so critical while having an attachment field in public forms especially. You just can’t bear any random person uploading GBs of file.
Hi, I notice that when I key in Chinese in the Search Extensions, the results always come out null, it seems like a bug.
Hi,Using “When a record matches conditions” I want to “Find records” using a result in a previous “Find records”. That result is originally a LookUp, which result I know I can’t use as a dynamic condition in an automation, giving a “Cannot assign list of string to string” error.Hence I created a formula field which CONCATENATEs the LookUp to what I though is a string. Regardless of that, I still get the same error, and cannot use the new formula field in the automation either.The result is a recordID so cannot format these into single selects, they are unique.What have I forgotten about how these work 🤔?Rgds,Björn
Hello all,I am building an online registration form for clients to sign up for a Christmas Hamper program. The information I need to collect is the personal information of the client (i.e. name, address, income etc) and all the personal information of all household members. I created a base with two tables, one is the client table (for all the client data) and another table called HH_Members that holds a record for each member of the family (including name, DOB, gender etc.)Is there a way to publish a form that can collect the client information and all the household members and store it in the respective tables?How does one collect information with a “1 to many” relationship and store it in linked tables?Thanks in advance for your help,Zepppo
ich benutze eine Excell Tabelle mit ca, 20-30 Aktien, die ich täglich im Auge behalten muss um schnell reagieren zu können
Hi guys!If you want to make your email better with dynamic URL, just make it: [Link name](URL) syntax directly in the email body field:Link NameAirtable's email editor renders this as a clickable link automatically.TipThis works with dynamic field values too — if a formula field outputs Link Name as text, insert that field into the email body and it renders as a link when the email sends.Common mistakeJust pasting the raw link (https://long-ugly-url.com) instead of wrapping it in Link Name — the email then shows the ugly raw URL instead of a clean clickable word.
Hi, Wondered if anyone could help with this…I have the following fieldsTitle, Sub Title, Series Title and Series OrderThen I have a full title field where I want to bring those together depending on which of those is filled in. So, if there’s a Sub Title, I want the Full title to show {Title}: {Sub Title}. If there is a series title then I want it to show {Title}: {Series Title} {Series Order} (as an aside, if I could get the series order in brackets that would be amazing, but I suspect impossible because brackets are part of the formula). And if neither Sub Title nor Series Title have an entry then I just want the {Title}. I don’t think there’ll ever be a case where we have a series title and a sub title so I’m not worried about that for now. At the moment I have:IF( {Series Title}, {Title} & ": " & {Series Title} & " " & {Series Order}, IF( {Sub Title}, {Title} & ": " & {Sub Title}, IF({Series Title} = BLANK(), AND({Sub Title} = BLANK(), {Title}
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.