Ask questions, get answers and engage with your peers
New here? This is a great place to start
Get support directly from your peers
Celebrate your Airtable wins
Forge connections with other Airtable users
Explore and RSVP for upcoming events
Read the latest news the Airtable team
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
CONTEXT: I am a Film and TV Producer (on a Pro (Legacy Team) account) with PEOPLE, COMPANIES and INTELLECTUAL PROPERTY bases that I sync (i.e. “push out”) as relevant to seed specific FREE client/project bases so a handful of (<5) different team members (respectively) can update content specific to their projects.EXAMPLE: I maintain box office data on movies, track streaming, broadcast and cable series ratings, statuses and talent (ShowRunners, Actors, Writers, Directors, etc.), actors’ bankability stats, everyone’s credits linked to their IP, who’s moved company-to-company in the relentless musical chairs and vertically integrated morphing and consolidating - it’s A LOT to track! LOL! :-)If I’ve done the deep dive of complicated music licensing research on a specific song - or have an actor’s whole suite of (also constantly evolving) reps’ contact info, I don’t want to have to keep manually updating that across a ton of different project bases. I USED to have this all syncing perfe
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")
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 there is a way to build my app into AT, rather t
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!
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.
The current summary stats for linked record fields are only Empty/Filled/% Empty/% Filled. Would love to be able to calculate Unique (in particular when you cannot link multiple records). A fictionalized use case:I have two tables: a list of contacts and a list of companies. Each contact has a linked record to a single company. I would like to be able to see a count how many companies are represented by a filtered group of contacts -- either in the data view or in an interface. A workaround would be to go to the companies table, and filter to companies that are linked to a contact.However, sometimes I only want to calculate this for a subset of contacts. Currently the best solution (to my knowledge) would be to create a roll-up field in the company table that counts linked contacts who match the relevant criteria and count the number of contacts using this formula.
We’re excited to announce that App Sandbox is now generally available in Airtable! App Sandbox is the best way to build, test, and deploy AI and other changes to your Airtable apps without disrupting your team’s workflows. With App Sandbox, you can:- Experiment with new automations, AI features, interface pages, and app logic in a dedicated sandbox environment.- Safely test changes with a copy of your real data, previewing exactly how they’ll work before rolling them out to your team.- Confidently deploy complex updates to your live base, knowing you’ve already validated everything in a safe space. Key benefits:- No accidental disruptions: Your team keeps working with live data in the main app while you iterate in the sandbox.- Faster innovation: Try out new ideas, integrations, and AI-powered workflows without risk.- Built-in filters: Only deploy what’s ready to go out- Seamless deployment: When you’re ready, publish some or all of your changes directly from the sandbox to production.
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
Hi everyone, Stephen here from the Airtable Product team.Today we’re rolling out AI-Generated Interface Elements to AI Labs. This new capability lets you build bespoke interfaces to visualize and act on your data in completely new ways. Just describe what you want, and Omni creates an interface within minutes. Why we built itOur community of builders is constantly inspiring us with how they push the boundaries of Airtable. Although there are so many possibilities using Airtable’s out-of-the-box components, we’ll never be able to build every possible way to interface with your data as a first-party feature. Now Omni can spin up completely unique elements in seconds from your prompt. What you can createHere are just a few examples of the types of interfaces that builders have already created: A 3D viewer to explore product models and cost breakdowns A heatmap of revenue by region and segment A network diagram showing relationships between members of a community A map of potential store o
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?
Hey all, I noticed that my automations that rely on new rows as triggers on Google Sheets no longer seem to be triggering. I created a new base and a new sheet and tested, just to discard issues on my sheet or AT base, but it looks like this new automation didn’t work either. Is this issue happening to anyone else? I checked the status pages of Google and Airtable, but couldn’t find any info.
I would like a formula that take a blockchain address in string form and converts it to its case-sensitive checksum format. For instance calling this function on ‘0xc02aaa39b223fe8d0a0e5c4f27ead9083c756cc2’ would return ‘0xC02aaA39b223FE8D0A0e5C4F27eAD9083C756Cc2’ The process is fairly simpleConvert the original Ethereum address into lowercase. Compute the SHA-3 hash of the lowercases address. Take the first 40 characters of the hash (which is a 64-character hexadecimal string) and replace the corresponding characters in the original lowercase address. If a character in the hash is a letter (A-F), then the corresponding character in the address should be uppercase. If a character in the hash is a number (0-9), then the corresponding character in the address should be left as lowercase. The final result is the checksummed version of the address. https://www.alchemy.com/docs/how-to-handle-checksum-addresses#what-are-checksum-addresses
An error has occurredRefresh the pageIf you continue to experience this error, please contact us.Error: pglCNX2zYBkDmW4gr
Hello, in my department we use Airtable for people to register when they want to attend any of our workshops. Is there a way to connect Airtable and Outlook and have some sort of automation where when someone registers for one of our workshops they automatically get a calendar invite on their outlook calendar about the event?
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. Discount Codes — This would be a conversion of the above Ticket Types table and apply an actual percentage off of the event — Ful
Accelerate your learning journey with comprehensive learning paths and validate your knowledge with Airtable certifications.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.
