Ask the Community

I feel like this might be a Fillout issue but thought I would check here to see if anyone can identify if I'm doing something wrong.  I have a base connected to a form in Fillout.  When I pull up the form and click “integrate” at the top, it shows a connection to the correct table. When I click back on...Edit at the top, Go to the page that contains a field linking to a subform Click the field the subform is attached to,   Open settings on the right Click Edit Record creation form to pull up the form,...it says connected at the top, but when I click the integrate tab on the sub form and look at my connections, I continue to get the following message.  I've updated my API Key in Fillout, updated my PAT Token in Airtable, cleared my cache, confirmed my mapping is correct, I don't have any automations that might cause the problem,  and tried a different browser.   I was connected to a different base and i

The above is a view.The idea is instead of trying to get an automation to trigger by 48 hours prior to the start date of an event, and sending an email, I thought perhaps, the automation being triggered when entered by a view that only displays events that are 48 hours(2 days) prior to an event. However, my view from the settings still shows, all the start dates.   

Hey AT brains trust, I'm at my wits end attempting to get this interface to simply filter to show me my un-approved expenses. This is for our Base to manage all org expenses, which each FY I duplicate, turn old automations off and new ones on, rename to current FY, recolour and a little bit of renaming inbudget areas. An interface we rely heavily on is sending me this error message.The field is single select and has not changed The filter is specific and again very simple, we want to see unapproved expensesI have copied the field and used that, I have duplicated the base, I have reentered the filters and have had no luck and am losing my brain. The previous FY still works but nothing has changed in this area.Please help

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 g

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. 

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.nutr

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 genera

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

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

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 settings

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 Ind

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!