Ask the Community

 I’ve been building an Airtable app for my team (about 10 people) at a foundation. We make a lot of grants across different programs, and I’ve been trying to create a central hub for all of our work. So much of what we do overlaps that it just made sense to keep everything in one app rather than splitting it up.Right now I’ve got about 15 tables:  organizations, projects, tasks, budgets, inquiries (from email), notes, annual budgets, program budgets, etc. It’s a big base, but I’ve built separate interfaces for each program, so even though the back end is large, the front end feels really clean.Some folks on my team have suggested that each program should have its own app, with a master one where everything rolls up. I’m not sure that’s the best approach. it feels like it would add more work and complexity.Curious what others think.  has anyone else gone through this decision? Does keeping everything in one well-structured app make sense, or is it better t

Hi everyone,I’m trying to create a line chart in Interface Designer that shows interest rates over time. My table structure is simple: Date (date field) Rate (percentage field) Type (single select) In the chart settings: I use Date for the X-axis, Rate for the Y-axis, And I apply a filter so that only records with a certain value in the Type field appear. However, I noticed that Airtable automatically applies an aggregation (e.g., average, sum, etc.) to the Y-axis values, and I can’t find a way to set it to “none.”Since each date in my table corresponds to exactly one record (no duplicates), I’d like the chart to simply plot the rate as-is, without aggregation.Is there a way to disable aggregation or ma

Hello I thought this would be simple to figure out but somehow its not working for me.I have 4 tables.  They are all linked together.  Each field in everyone of these 4 tables has a common Dept Code (this is their link to each other).  Also in each of these fields is a field Associated Program.  At times we may need to edit the data in the Associated Program field.  If we do this I would like that update to appear in all the other tables as well.  I thought if I linked them this would be the case.  But they are linked on the dept code?  How can I create something that would update this other field in each of these tables.   Thank you, hope this makes sense.

Hi, I needed help with airtable, specifically on the fields of our content calendar. We have this added field that says “Updated Verbiage” and this is where we usually attach the Updated Document. We were able to use that before but recently and these past few weeks, we had a hard time using it because the field is not working. We cannot click the field and add the updated document. Has anyone experienced the same dilemma and how were you able to fixed it? 

Just posting this to check if there is some kind of systemic issue happening, or if this s***storm is unique to my Org. Airtable status says fully operational but something is definitely wrong.My Organization has several bases that are currently experiencing a complete collapse in their functionality. At the moment, we have 4 bases that cannot be accessed reliably, and 2 of these can’t be accessed at all. The bases can’t be loaded by any user, on any device, on any network. We have tested access from many locations and this issue persists.These bases do have some syncs set up between them, but nothing outside of what I have built many times for other clients with no issues.This appears to be an extension of an issue I have been working with Airtable support on for months now, but have made no progress:When updating the configuration of a base, updates take 30 plus seconds to occur, and always throw an error saying that the operation fa

I understand there is an Admin panel available on the Business and Enterprise plans that looks like a one-stop-shop for organizing user settings/permissions, but that this is not available on the Teams plan. Isn’t there a way on the Teams plan to see all users in one place to see what they have permission to and at what level with the ability to edit the settings right there? Currently it seems like a disorganized mess as I have to go to each element to see who has what and frankly that’s not very clear. An Admin panel seems like database 101 and should be available to all paid plans. Am I missing the boat here? (I feel like I’m missing something obvious.) A specific question: In our workspace, under the Collaborators tab, it shows three users:Me - Workspace OwnerMy boss - Workspace EditorEmployee - Interface Editor Would this setting allow the employee to interact with the base itself, or do can they only see the interface (which is

Hi Community, does anyone know how to integrate Airtable with Justcall (a dialer)? If anyone can assist i would be humbly grateful

Hi there, I’ve been using Airtable for a while and using Pre-filled form for about 3 years now, but I’m having issue recently with some pre-filled form with linked records. I have 4 pre-filled linked record in this form : https://airtable.com/app3VaYZ9KK6HEimn/pag88B7PDY9L5izzt/form?prefill_Session=70&prefill_Formateur=Camille+Rabineau&prefill_Entreprise=Founders+PledgeAnd only 3 show up and the last one doesn’t. It does appears in the URL though, it’s just nor displaying it. Here is the formula I’m using : SUBSTITUTE(CONCATENATE("https://airtable.com/app3VaYZ9KK6HEimn/pag88B7PDY9L5izzt/form","?prefill_","Session","=",ENCODE_URL_COMPONENT({ID 2026}),"&prefill_","Formateur","=",ENCODE_URL_COMPONENT(Formateur),"&am

I am using airtable to push emails out via my gmail. However gmail says they’re bouncing back but airtable doesn’t seem to track those emails that have bounced in gmail. I want to be able to change the status to “Bounced” and then automate to use another email i have in the airtable.  

I know it ha been discussed MANY times, and I even clicked on the “contact developers” to submit a question/suggestion to see if they ever think this will fully integrate with Airtable…. aka upload the PDF upon a trigger via automations, or just a column that IS the page designer. Can anyone at Airtable make this happen? It seems that Airtable is the developer, and with all the chatter here, this one small thing would make a huge difference to so many. Currently the only options are to use external PDF creation tools, which is beyond frustrating when you’ve created the perfect PDF page and all you need to do is link it to the column. The fact that someone can’t even click a link to view the PDF, ugh. Anyway, maybe if enough people “like” this, it can get to the Developer and they can actually follow though. With all the AI and automation of today, I know this is possible! Please help us get there. 

Hello Community,First post here. I am attempting to connect my Airtable to Power BI.I am receiving the following error message in Power BIExpression.Error: We cannot convert the value null to type Record.Details:Value=Type=[Type]I am following this guidance and using a Personal Access Token. I setup Power BI Parameters successfully but received the error code in the Query. I suspected that it may be the M Code so I followed a link to a GitHub resource for alternate code."If the above script seems to be causing an error, then please refer to this GitHub resource, as the code may have changed.

Does anybody know if it’s possible to copy a Page Designer layout to another base? They are so fiddly & time consuming to set up that this would be extremely welcome.

Has anyone had any success integrating Airtable with MRI Real Estate Software using API keys?  If so what steps did you take?

In another topic, I recently explained how you can instantly sync your Shopify metaobjects to Airtable.The good news is: you can now sync your Shopify metafields with Airtable too (thanks to SyncBase app) 🤩 How does it work?During onboarding, you can choose which metafields you want to sync (Product metafields, Variant metafields, Order metafields, etc.). The app then creates one table per metafield group (e.g. Product metafields) inside a brand-new A

So I’m looking to employ a formula to provide a word count for my SEO keyphrases, which range from 2 to 8 words. Below is the formula that I thought would work, but I’ve had no such luck…does anyone have any thoughts as to what’s going on here? Thank you in advance! IF(({Keyphrase}=BLANK()),0,(LEN({Keyphrase}) - LEN(SUBSTITUTE({Keyphrase},’ ', ‘ ’))+1))

Hi Airtable community,I work for a non-profit and we’ve decided to use Airtable for our operations. I have limited experience with Airtable but need to get this set up.I’m building a dashboard to manage: Employee Dashboard HR Management Employee Onboarding & Offboarding Leave Management Procurement Management Artwork Dashboard Patron Management I’ve prepared a 14-page spec detailing the integrations, workflows, and automations we need.Since I’m on the Team plan, I don’t have access to dedicated consulting. I’m looking for guidance on: How to integrate multiple bases efficiently Automations or workflows that are possible within Team plan limits. I’m happy to share the spec so someone can provide step-by-step advice or examples. I don’t have technical exper

Edit after ~1h of investigation: it turns out these are rate limits that are the culprit. Which raises a new question: if I change the email address in the automation, will it impact the runs that are currently in progress? My guess is no. And so, if no, is there any way to trigger a re-run of the currently stuck runs?  I several automations running that involve sending emails. They have both run over 6k times until yesterday around 8pm many runs are stuck in “pending”. There are several things puzzling about it:There isn’t a clear cut off when the automations started getting stuck. See screenshot below: several still pending from before 9pm on Oct 16, followed by successful runs, then everything after 10.15pm is pending.2.Runs stuck at d

I created a dashboard with interface designer, containing mostly number elements with the % complete of different categories; when I expand this, I get a list of records in the category, as expected. Great ! But this works only as it should be on the desktop client and also on the iPad client. But not on iPhone !? On iPhone, every Number element on the dashboard I expand, I always get the message “No records yet” ?I don’t understand this… is there really such a big functional difference between the iPad client and the iPhone client ? 

Hi, I have a question about some app architecture that I wonder if anyone might have suggestions or opinions about? The short version is: is it better to pull AT data into an outside app, or to instead try and build plugins / overlays within AT (somehow?) ?  Longer version: I am an engineer (not the software kind) and architect (also not the software kind). I LOVE AirTable. We use it religiously in our firm and it works GREAT for managing building data (pumps, fans, windows, glass, materials, rooms, ventilation flow-rates, etc, etc...)., We have built all sorts of tools to pull AT data down into our local Building Information Models (BIM) as we work. I’ve been working on a client-facing app for BIM data display, and so far what I have is a basic React App which pulls in a project’s AT data and displays it in tables for the client. So thats also fine. But NOW I am starting to add ‘creation’ tools to this app,  and I’m wondering if instead

Hi everybody,Our company has 3 x sized boxes - small medium large.We fit the following quantities of our product in each  box:Small - 95Medium - 200Large - 300What I want to do is tell a user how many boxes each order will use. I’ve achieved this with nested IFs:IF({quantity} <= {Small Box (from Link To Products)}, "1 x Small Box", IF({quantity} <= {Medium Box (from Link To Products)}, "1 x Medium Box", IF({quantity} <= {Large Box (from Link To Products)}, "1 x Large Box",ROUND({quantity}/{Large Box (from Link To Products)},2)&" x Large Boxes")))This works well. My only issue is with the last statement when orders exceed 1 x Large Box. With an order larger than the size of 1 x Large Box, it returns a decimal of large boxes e.g. “2.67 x Large Boxes”. My question relates to the deicmal  - I now want my formula to say whether that residual decimal would fir into a small box,

Using Page Designer to create station manifests for events and they look amazing on screen, not so much on paper. Only the first page prints, the rest of the pages are blank. I’ve tried everything I can think of, but still getting blank pages. When I print I see this instruction: “You’ll need to manually enable background images and/or background colors in your print settings in order to make the page print properly.” What does that mean? Where do I change this setting and how do I change it?

Is there a good method where when I apply to a job in LinkedIn that it would trigger or gather the details of the job--company name, position, date applied, etc. and export/import the data into my AirTable base as part of my job search?  

hello,How can I create an interface from an Airtable list view?  

I created a Check-In button that uses a formula, and it was working fine for a couple of weeks. However, it recently stopped pulling and autofilling the “Time Card” field. I also have staff use our interface to check in and log time for hours used on the time card.formula: "https://airtable.com/appLI7NsuW6OZb1VH/pag4DxG1LCOxskSQE/form"& "?prefill_Time%20Card=" & RECORD_ID()& "&prefill_Rental%20Date=" & DATETIME_FORMAT(TODAY(), "YYYY-MM-DD") 

I am on the Free plan for now trying to make sure everything will work …. I’ve got a Find records and no matter what it only returns 10 records, even if I make the only condition where it should catch them all. For example the primary field of “Name” is not empty. Or switching to a View based and still the same result.Is the free account limited on the number of found records? or am I being a major bonehead on my action...