Connect, collaborate, and solve questions about using Airtable in Ask the Community.
Recently active
Hello guysI am reaching out to clarify a question regarding your licensing model. I would like to know whether users who will only access and view bases and databases created under a paid account are required to have a paid license as well.In other words: if I have a workspace under a paid plan, do additional users who will only view or consult information (without editing or modifying data) need a paid license, or can they access it for free?Thankyou!
Any way to Isolate or hide data in the base via access or other means?If I create an inteface with linked data from another base, will the base data be visible by those who have base access? This is relevant when attempting to report on the status of legal work where the repoting dashboard interface needs the metrics however not everyone needs to have access to the back-end data related to the specific cases. I hope I am explaining this so it’s understandable.
I have three tables.One has business information.One has Employee information.One has information about the workshops the business have signed up for. I want to create a table that tracks employee attendance for all workshops at all businesses. All employees attend all the workshops the businesses sign up for.I don’t know how to do this without a left table join. It seems like it should be simple, but it is not.
I am new to Airtable and need help or confidence about the process. I have created two interfaces, an intake form and a directory to organize the data collected from the form. I am unsure of how the form data populates the directory. Am I missing something?Thank you to all who reply.
I’m trying to filter using linked records but i must have a mental block. Table A is People Records. it is linked to: Table B: Service Records (multi records) Table C: Congregation (one record) Table C is Congregation. It is linked to: Table D: Districts (one record) Note: it is NOT linked to Service Records, but does have a lookup field to Service Records (from People). Table D has lookup fields for: Service Records (from Congregations) I want to report the number of Districts that had at least one Congregation that has a Service Record that meets the following criteria:Service contains “2025 11” {Service is the “Name field”} Service does not contain “Cancelled” {Service is the “Name field”}I also want to report the number of Congregations that have a People Record with a Service Record that meets the same criteria.Service contains “2025 11” {Service is the “Name field”} Service does not contain “Cancelled” {Service is the “Name field”} The problem i’m running into is that some Pe
Hello! I am banging my head against a wall trying to figure this out--maybe someone here can help! I want to update an Airtable record based on receiving a new email. The emails are automatically logged by subject line in Google Sheets. The subject line contains the same “Name” that matches the Airtable record, but it also contains other information--so the information in the Google Sheets cell does not match the Airtable field exactly. I would like to search the Google Sheet and find the Airtable record based on the information in the cell, but it seems like I can only locate the Airtable record if the information in the Sheet matches exactly. Basically, is there a way to swap these two fields, so that the automation is searching for the “Name” field in Airtable from the Google Sheet?
Hi,I'm building a Kanban-style interface that needs to display data from two separate sources.Goal: The first column of the Kanban should list Job Listings (Source 1). The subsequent columns should display relevant Candidate Profiles (Source 2). A single candidate would be able to be placed more than once in the Kanban with different Job listing. Essentially, I want to map multiple candidates to a single job listing within the Kanban view.Currently, I'm struggling to set up this dual-source data structure in the interface.Is there a standard or recommended method for achieving this job-to-candidate grouping functionality?
I click the + below.The form opens.I click "Save" but nothing is saved.
Hello, we have an issue with the urls of the records on the interfaces.We have basically 2 interfaces 1 for our project manager and one for our dev team.The issue is when we try to share a record url from the interface to our dev team they can’t access the url because they have their own interface even if the record is basically the same.So how to solve this issue? Any idea or workaround?We need to have different interfaces for different teams and is a pity we could not cross share records url. Thanks a lot!
I want to create a formula to select the SECOND-LARGEST value among five different categories. I’ve already created one to select the LARGEST value (called “Category 1), and then my thought was to exclude that category and return the max of the remaining four fields. With the help of Airtable’s AI, I got this formula:IF( {Category 1} = "Connections", SWITCH( MAX({Events}, {Programs}, {Support}, {Marketing}), {Events}, "Events", {Programs}, "Programs", {Support}, "Support", {Marketing}, "Marketing" ), IF( {Category 1} = "Events", SWITCH( MAX({Connections}, {Programs}, {Support}, {Marketing}), {Connections}, "Connections", {Programs}, "Programs", {Support}, "Support", {Marketing}, "Marketing" ), IF( {Category 1} = "Programs", SWITCH( MAX({Connections}, {Events}, {Support}, {Marketing}), {Connections}, "Connections", {Events}, "Events", {Support}, "Support", {Market
We’ve embedded Airtable to a knowledge base article on Zendesk. When accessing the article on your laptop or desktop, you’ll see all the features that you would normally have like filter, group, etc. at the top of your Airtable base. However, on mobile, those features do not show up, making it difficult for us to support our mobile users. Even selecting the “view larger version” link doesn’t help. Is there a way for us to default it to show the web version of the Airtable base in the embed? Or is this a known bug or product gap?
I have added some new views and a form in the production view, but they are not appearing in the sandbox view, so I am unable to create any automation specifically around the form I created.How do I sync back to the sandbox?
Hi all, I import CSV files with salary ranges.There are two fields from CSV: “Salary Min” & “Salary Max”. Their format is $75,000.00. I want to have them in one field ($75,000 - $100,000), so created a third field with the formula IF( AND({Salary Min}, {Salary Max}), "$" & {Salary Min} & " - $" & {Salary Max} & "/yr", "") However, I get “$75000 - $100000/yr”.I looked around and tried AT’s AI but so far luck.Is there a way I can resolve this? Thanks a lot
no one in our company is receiving a notification when using the @mentions feature in the comments section. Until two days ago this was working flawlessly. I have tested several variations to ensure the issue is not limited to a single user or group. Is anyone else experiencing this problem (12/05/25)
I have some domain data that updates daily, and I need the data to be aggregated by domain as new entries are created each day. I tried using Rollup, but it only links one set of domain records. I have data for the same domain across two more days, but it’s not being summed. How can I automate this? Is there a better approach?
I have a table with a linked field to another table. The linked field refers back to the primary key of the table I am linking back to (eg a unique project number) but that is just numbers and it doesn’t mean anything to most users when searching. Is there any way I can have the linked field search for the name of the project rather than typing in the unique primary key to the record I want to link back to? I have added a lookup field but this only pulls in the project name field once I have linked back using the link field by entering the corresponding unique job number,
Hello, I have a table where all records are auto populated by a Webflow form submission through Zapier. Everything works fine except one small thing. Every time a user sends a form and the main text field has commas in it Airtable splits this record in multiple records. Example: Form Submission: Watchmen #12 "A Clock at Midnight, Its Face Running with Blood, Cover Original Art" Airtable Records: 1st Record: Watchmen #12 "A Clock at Midnight, Its Face Running with Blood, Cover Original Art 2nd Record:Watchmen #12 "A Clock at Midnight 3rd Record:Its Face Running with Blood 4th Record:Cover Original Art Is there any way to avoid this? I just want the first record not the second, third or fourth. Thanks
HI everyone,I have an interface setup for my iPhone and iPad. If I open the interface do some work and leave it open to come back to. When I do come back to it, say 5mins later, the app will reset and request I sign back in. I’m on an iPhone 14 and iOS is up to date. I’ve deleted the Airtable app and reinstalled.Is this common issue? Did I miss something on the Interface setup? Should I access the Interface differently?
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 have a base setup for a check in system. When a user checks in through the airtable form that triggers a notification to slack. Within the form users can upload an image file which I am able to see on airtable. The form is updating on slack but the image shows up as a url that when clicked it gives this error: “The link you're trying to visit is not available. Please visit our support center for more information.” Any ideas for how to troubleshoot this?
Hello and thanks in advance for reading and for your help ! :) I have a table called Modeles_de_mails where I store email templates.One field, Objet_du_mail, contains a subject with a placeholder that look like this :Nouvelle demande d’intervention {{Ressource}} In another table, Locations_ressources, I have a field named Ressource that contains the actual value I want to insert (for example: Planétarium). My goal is to automatically update the subject line so it becomes:Nouvelle demande d’intervention Planétarium based on the linked record’s Ressource value. I want to know: What is the correct way to replace a placeholder like {{Ressource}} with the value coming from a linked table? Do I have to use a Lookup field to bring the value into the template table, or is there any cleaner method? I saw some database good practice that tell to avoid as much as possible lookups and formulas inside database to avoid calcul and loading time. Is there a recommended pattern for managing email
I’m not sure if this is possible with AirTable, but I’m hoping someone more savvy can help me brainstorm a solution. BACKGROUND: I’m a lawyer, and I’d like to create a database of cases that are cited in briefing, so that I can go back and reference my notes / summaries of each case when they are cited again in a new case. The thing I’m struggling with right now is whether there is a way to associate each case with its Jurisdiction (the court that decided the case) and its Reporter (the publication where the case appears). There is a limited universe of Jurisdictions and Reporters, most of which I have pulled into separate tables already. Cases come from one of the following: The U.S. Supreme Court One of the state supreme courts One of the U.S. Courts of Appeal One of the state appellate courts One of the U.S. District Courts One of the state trial courts Each case from an appellate or trial court has a similar citation structure that goes like this: [Volume] [Reporter] [Page] ([Jur
Are there plans to have the ability to create more than three heirachy levels? The use case is as follows: I would like to be able to create a hierachy that includes: InitiativesEpicsProjects/FeaturesStoriesTasksCurrently I can only link the bottom three
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 have found some posts on printing mailing labels via Page Designer, but they were from 2018. Since it is 2023, I was hoping if there was a way to print on Avery labels with Airtable. I don't have an actual label printer, just a regular old printer and some Avery sheet labels. Be aware that every label would be unique.Example:
Already have an account? Login
No account yet? Create an account
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.