Ask the Community

The decision to lock the Visibility function of fields in interfaces to business accounts is unfortunate. Of all the upgrades that going from Teams to Business grants, this is the most arbitrary one. The ability to turn off fields is a simple quality of life function that no one is going to be upgrading to get, it's a punitive measure against those of us who are not as well funded.The poorest organizations using teams are also those that typically will most need the Visibility function in interfaces. They will generally have the lower paid or more transient staff that turning off fields and buttons will prove most crucial for.Case in point, non-profits will often have volunteers who can greatly benefit from not being able to see or interact with functions until other steps have been taken or not taken. Airtable has chosen to doubly hit those organizations by giving no discount to them at the business level and turning off a key feature that they would benefit from in getting them to th

Is there any way to remove the "Download CSV" option from member databases?I wanted to keep the data only in the cloud and not have the option to extract the data this way.

I have a date time difference formula formatted to decimal with 2 places but not returning any values less that one. My formula is as follows: DATETIME_DIFF({End Time},{Start Time},'hours')What am I missing? If I recall correctly this should be able to return hours less than 1 (e.g. 0.5 for half an hour difference)

I'm working on a few projects that are using a gallery view, one of which is a publicly shared interface. I'm excited about the changes, but have a question about one of the new features. My users have noted the change immediately of getting the expanded image rather than going to the record detail. Does anyone know of a way to turn off this feature?Thank you!

Is it possible to add the button on my detail page to the actual interface List view? Rather than having a user click into the record detail page, I’d like them to just be able to click the button and trigger updates within the List View on the interface page.

Here’s the problem in a short loom. Maybe I need to have the event table with the name of the event as the primary field: 

Hello, I'm stuck and need your help.I created a 6-page contract using the Airtable Page Designer extension.The problem is twofold: I succeeded in the first step but not the second.Basically, the Page Designer extension only allows you to edit a single page. I found a way to extend the page height by multiplying it by 6. Except that Airtable doesn't allow you to insert page breaks, and I'm exporting a very long PDF file that I can't split. And no matter how hard I search, I haven't found an acceptable solution for printing this contract correctly.Do you have any solutions or advice?Thanks!

Hi, I’m building a page to track hours — comparing what we’ve budgeted versus the actual hours spent. We’re tracking time in Harvest, and at the moment I’m manually entering that data to match it up, which means there’s no direct link between the two systems. We use the same standard phases for every project (example: B01-B09). Each time a client signs a fee proposal, I want to add these same phases to the new project and allocate the initial budgeted hours. In Excel, I’d simply copy and paste multiple rows, but in this system I can’t duplicate more than one row at a time, which is slowing things down.Ideally, I’d like to be able to duplicate all phases (B01-B09) and assign them to a new project in one go, then input the hours. I also update the actual hours weekly, so it needs to be easy to maintain. I’ve been exploring whether an interface with a button (plus an automation) could do this — so that with one click it would add all the phases for me — but I’m a bit stuck on how to set t

Hi! Do you know if it’s possible to add the text generated for an AI field to an email automation? Everything seems fine in the other fields but not in the AI generarted. I tried copying it with a formula but it is not working.   

Hello!I am a novice with automations and trying to figure this out:I have one table for Projects, each record is a separate project that is then linked to records in another table for Deliverables. When I change the status of a project to Archived, I’d like an automation to trigger all the linked records in Deliverables to also change their status to Archived. What is the best way to set this up? Thanks in advance!

AirTable is not allowing me to upload my CSV file. I click on the + sign, select “CSV file” under “Add from other sources”. I drag in my CSV file under the “Local Files” section and click “Upload 1 file”. It seems to work, I select “Create a new table” under the “Import your file” dropdown. It shows me a beautifully created base with all the column's I’d like.  However when I click “Import” I get an error sign saying “Can’t import CSV file” with the statement “Invalid data” underneath. Does anyone know what might be going on / how I can fix this. The only option airtable gives me is to click a button saying “Okay” and I’m back to the start. 

They are in the same base.

Hi, Many of my automations that worked for months are failing after the recent update. Is anyone else experiencing this?

Is there a way to export the structure of a table to csv, JSON, etc.? Specifically, I’m looking for a way to export information about a table, not the data itself. Some method that will give me an output like field 2 is long text, field 3 is lookup, field 4 is date, field 5 is single select, etc.

Hi Dear community i’m facing a scipting error pleaase help mei need to connect  my ingredients tables to the API open food factsThanks   let tableIngredients = base.getTable("Ingrédients");let tableOFF = base.getTable("Open Food Facts");let ingredients = await tableIngredients.selectRecordsAsync();let offRecords = await tableOFF.selectRecordsAsync();for (let record of ingredients.records) {    let ingredientName = record.getCellValue("Nom ingrédient");    if (!ingredientName) continue;    let response = await fetch(https://world.openfoodfacts.org/cgi/search.pl?search_terms=${encodeURIComponent(ingredientName)}&search_simple=1&action=process&json=1);    let data = await response.json();    let product = data.products && data.products.length > 0 ? data.products[0] : null;    if (!product) continue;    let nutriments = product.nutriments;    let energie = nutriments["energy-kcal_100g"] || null;    let proteines = nutriments["proteins_100g"] ||

Anybody has tips on how to do that? I have a long text field (cca. 1000-2000 characters including spaces). Beside that another field showing keywords, usually not more than 10-15 keywords. These keywords are typed in through Google API and edited by me manually. These can be keywords (or better say key phrases) are separated by comma. These are the words (phrases) I want to make sure I have them in my long text field in sufficient number of times. I am looking for a way to calculate the keyword density, that is how often do the keywords (the words in the keyword field) appear in the long text field. I do not need to see individual count, sufficient is to have summary count - number of times any keyword appears in the long text. The density count will give me a percentage = number of total keywords(phrases) / total words in the long text I looked at this suggestion here but it seems to me Airtable database would explode if I start generating a tag (which seems to me is essentially a

I am an Airtable First-Timer and am having a really hard time understanding how to build what I want. I think Airtable is the solution, but I’m just an idiot. I own a small business and need help creating a Food Ordering and Management System. I have a project scope, our current SOP to share if someone would help me build it or I would happily pay someone to build this for me! Can you please message me back if you’re interested? Thank you!

Hello Airtable Community,I’m working on an integration where we need to detect if someone updates any field in a Form View (e.g., adds/removes/hides fields). I’ve explored the Airtable Metadata API, specifically the endpoint: bashCopyEditGET https://api.airtable.com/v0/meta/bases/{baseId}/views While this API returns the list of views, including forms, it doesn’t seem to provide: A timestamp or audit log of when a form was last modified Information on which specific fields were updated or reordered Any versioning or update tracking for forms Questions: Is there any way (via API or otherwise) to determine if a Form View’s field configuration has been changed (e.g., which fields are visible/required/ordered)? Can we track when a particular Form View was last updated? Is there a webhook or event system available for view updates? Any guidance or workarounds would be greatly appreciated.

Hi Airtable team 👋  I'm building a master fulfilment dashboard using Interface Designer, based on a table (Partner KPI's) where each record represents daily performance data per partner.One of the most important metrics I want to track is:Cost per Scheduled Consultation = Ad Spend / Number of Consultations ScheduledRight now, this is calculated per day via a formula field on each record. ❌ Problem 1: The dashboard shows an average of the per-record ratiosWhen I display this KPI on an interface, Airtable averages the daily cost-per-consultation values instead of calculating:Total Ad Spend for selected period / Total Scheduled Consultations for selected periodThis leads to completely misleading values, especially if some days have very few or zero consultations, which massively skews the average. ❌ Problem 2: No support for weighted averages or cross-record ratio KPIsI need to be able to calculate:SUM(Ad Spend) / SUM(Consultations Scheduled)...for a given partner and time period filter

Hello everyone,I’m trying to replicate a process I set up a year ago that is working well.  I have a formula that opens a form for a responses table that automatically links it to the main table.  The formula uses the form address and prefill, with the record id of the main table record.  When I open one of those links it works perfectly. It is not editable, but shows the linked record information.I’m trying to replicate it on a new base, but the same prefill option isn’t bringing up anything unless I make the group editable and then anyone with the form would be able to see all our records. Here are the differences I can spot, but I don’t know how to make them match:In my working form I see this in the group settingsThe line “some fields are editable...” doesn’t show in my new form. The other difference is that the new form gives me this warning under Rules, which is not present in my working form, but I think that’s because I had create a filter in the past. Any thoughts on what I mi

Hi everyone! I'm looking for advice on the best way to structure Airtable for my program and project management needs. Should I use one base or split it into multiple bases? Are there any training resources or templates you'd recommend instead of building from scratch?What I'm Managing: I oversee a year-long program with multiple projects that launch each quarter. I need to track everything at both the program and project levels.Program-Level Requirements:Annual roadmap showing all projects by quarter OKR tracking that connects to relevant projects Capacity planning across all projects Status reporting with different views for various stakeholders Risk visibility across all projects Intake form for new project requests into the programProject-Level Requirements:Task management and tracking Task-level status reporting Individual project risk tracking Project capacity planningI'm trying to figure out the best way to link everything together so I can roll up project data to the program le

Hi, I would like to copy a table (a specific view) to paste it into a table format into an email, but I can’t seem to figure it out. It seems that if I were to copy the records in an AirTable, it just converts into plain text when I paste it into email, instead of a tabular format. I tried a bunch of different ways, but the only way that ended up working was downloading into csv, applying borders to my table in csv, and then pasting it into Gmail. Surely there is a better/faster way to do this? Hoping someone could help here!

When working with building automation systems outside of Airtable, a lot of use cases involve taking actions on Airtable data. These are currently done via custom Airtable API calls and actions that require a lot of configuration. They’re difficult to set up, maintain, get right, and scale.It would be a huge advancement if, instead of hooking up all those API calls and configurations ourselves, we could just provide our base and table and provide our request to Airtable Omni via the API and let it do the agentic work on our data.For example, the automation might look something like:ClickUp trigger > Airtable > Airtable Query: “Look through user feedback data in table X in base Y and provide a summary report of the 3 most important areas of improvement according to Z criteria” > Upload the PDF and upload to Microsoft OneDrive.”The parts in bold is where it would be very helpful to simply provide that as a query to Airtable’s AI/Omni via API.If not via the API, is it possible to

bonjour la communauté, la nouvelle mise à jour des champs de formule permet des sorties à sélection unique pour les champs de formule. J'ai un champs ou est concaténé plusieurs informations incluant une sélection unique. J'ai testé cette nouvelle fonctionnalité et apparaît la sélection unique en couleur, mais les autres informations concaténer n'apparaissent plus.merci de votre retour 😉

I have an email automation set up so that when an attachment is added to a field, an email is triggered to a project manager with a copy of that attachment.Currently, we delete the old attachments before dropping a new one in so you do not receive multiple attachments with the email that gets triggered.Now with the new Versions feature, I want to keep the old attachments in the field but only have the latest attachment added to the email. Is there any way to limit the attachment field in the email automation to only the latest one that was added?