Ask the Community

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

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

Hello! I’m having more difficulty than I’d like to replace text with a newline.In the Airtable Find & Replace extension script, I’ve modified it to support RegExp find and special character replace. However, when I replace the text with a special character like a newline, it always comes out in a literal text format.Here’s a real basic example of what I’m doing:let originalValue = record.getCellValue(field);let findText = "<br>";let replaceText = "\n";let newValue = originalValue.replace(findText, replaceText);Every time I view the replaced results, there is always a \n in the output: Is it possible to ensure that Airtable treats \n (I’m even doing \u{005C} to try to get around it and it doesn’t

I hate to make my first post a complaint, but I am at my wits' end.Two days ago, after extensive research, I decided Airtable would work for me and signed up for a year's subscription to the $20 USD a month plan.After logging into both the web interface and app, I find I am still on a FREE plan.I tried seeking help through the chat system; it was a complete waste of energy—nothing happened other than being told to contact sales.I messaged sales, but got no response.I emailed support and received a prompt reply: "Yes, we will investigate."Two days later, I'm still not upgraded and have received no further support other than "We are looking into this."This is unacceptable and unworkable—I don't want to risk my business on this type of “support.”I asked for a refund.Ignored.I am about to start a chargeback/fraud report with my bank.If anyone has the king's ear, tell them to sort their support team out.

I’m currently editing a list interface, and under “appearance” there is the normal record coloring, and then there is something called “field text color:” Does anyone know what this is and how to use it?I’ve attached a photo of what I’m talking about 

Having a few issues with new dashboards...Is there a way to not use a list, but instead use a grid layout for data on a dashboard? List view, especially here where you can not do levels, is useless.Is there a way to edit records in-line in the dashboard? no matter what I do, I can't seem to make it editable and have to expand each record individually. Not really working for our flow. ps... any news of Record List moving to the new upgraded interface versions?

Hi guysThis community is great by the way. Thanks for everyone here! I have a record list but all the groups need to be collapsed manually, and given that I have >200 groups this is not practical. I can’t right click on it (that’s perhaps only in “list” interfaces -- I’m in the “Record List”) Thanks for your help - I’m happy to sign a petition to implement this as Record List is a nice view Soeren

I’m building a self-referencing task dependency system in Airtable. Each task can list its Predecessors, the tasks that must be completed before it,  and I want Airtable to automatically display the corresponding Successors, the tasks that depend on it, without any code or automation.In short, I’m creating a two-way view of task relationships so that linking one side (Predecessors) automatically reveals the other side (Successors). So in the image attached, “Conduct internal briefing meeting” should show up as a successor in “Project set-up”. If anyone can help this would be amazing!

I have an automation that invokes an API taht requires authentication credentials. What is the best way to store those credentials so they cannot be read outside of the automation? Does the input.config do anything to obfuscate them?

Hi. Thank you in advance, I am wondering if there is a way to show numbers with thousand/comma separator if you combine it with a text in a formula field using concatenate. My Amount field is in currency format. Current Formula: CONCATENATE(Amount, " ", {asking-currency})Much appreciated.   

Hi everyone,I’m building a List Interface in Airtable and would like to know if it’s possible to freeze (or lock) the first column, similar to how you can freeze columns in grid views.When scrolling horizontally through fields in the List layout, the first column (which usually contains key identifiers like names or IDs) scrolls out of view, making it difficult to track which record I’m looking at.Is there a built-in way to freeze the first column in a List Interface, or any workaround that others have found helpful?Thanks in advance for any insights or suggestions!— Sean

We have many projects that we want to export or save in an Excel file so we can import them into another platform we’re using. Is there an option to download all the project tabs at once into a single file, so we don’t have to manually download each tab separately?

An error has occurredRefresh the pageIf you continue to experience this error, please contact us.Error: pglCNX2zYBkDmW4gr  

I’m an event promotor. I’ve been using AT for a while to keep track of community member applications, event details, and general ticket sales. I want to get a better sense of real time income via sale so I’d like to update the base.Right now, I have 3 tables in the base:Member List - Record for each member with personal info Events - Record for each event (Party A, Party B, Party C, etc) Ticket Types - Record for each type of ticket (Full price, 25% off, 50% off, comped, etc)None of these include price of the ticket and I would like to start tracking that.Thinking the tables should be this, but I’m not sure:Member List - Same as above Events - Same as above, but add in pricing columns for different ticket types — Tier 1 = $90, Tier 2 = $100, Tier 3 = $110, etc. The pricing can change from event to event so the amounts cannot be a universal across all events. Disco

Hello,I work for a print company and want to send Airtable data through API to make what's called a JDF ticket which Esko’s Automation Engine can then use.Does anyone have any experience with this?Our main label database software does this, but I want to replace it with Airtable because it is heaps better. Thanks!

Hello,I'm experiencing a critical issue with my Airtable automation connected to Make that stopped working yesterday, and I urgently need assistance as this is putting a client contract at risk.The Problem: My automation was functioning perfectly until yesterday. Now, when triggered from my Interface button, I'm receiving this error from Make: The operation failed with an error.Error: Validation failed for 1 parameter(s).- Missing value of required parameter 'id'.My Setup: I'm using a script in my Airtable automation that sends data to Make via webhook:javascriptconst { recordID } = input.config();await fetch('https://hook.us2.make.com/2eto4rtkvo8js15rcg05e69ntn5vceqe', { method: 'POST', headers: { 'Content-Type': 'application/json' }, body: JSON.stringify({ rid: recordID }) });The recordID input is map

Hi! I’m trying to embed a calendar view, but the data view isn’t matching the embed view:Data view (the one I want): Embedded view (no bueno): Normally I’d just set the view in the embedded version, but this will be on a TV with a refresh/animation every half an hour, so that’s not really feasible. Any way to fix this? Thanks!