Ask the Community

I want to look up certain related Procedure Records in my “PNP” table, then I want to add all the related Procedure Records to one field in every Work Record in another table. SO: Triggers: Possibly every time a Work record is created? or on a time schedule? A button?Step 1: Look up all related Procedures records based on a Work Record category fieldStep 2: For every Work Record, add all the related Procedures records to a “PNP” fieldShould be easy right? Just some ideas here but it didn't work at all.. 

Hello everyone,I am trying to make a nested IF/AND formula to do the following:IF the ‘Date First Contacted’ = blank, status = ‘Not Contacted.” IF the ‘Date First Contacted ‘= not blank and ‘Follow-Up Date’ = not blank, status = “Followed up.”Is it possible to write this into a formula given that ‘Date First Contacted’ and ‘Follow-Up Date’ are separate fields?  Thank you! 

Is there a way to have them receive an email receipt of some sort so they know the submission went through?  I think I have it set up to tell them Submission Received, at the end, but they are missing it and then filling it out again.  I’m not sure if it’s a easy fix and I’m just not seeing it or if it’s not there.   And, I guess if it is there and I’m missing it, is it only for paid memberships or free as well.  I have a personal account that is a free account, but had the same issue there as I do with the other.

Is there a way to automate the following scenario using any of the automation tools (like Make, Zapier)A change in a field in airtable triggers a 'create a campaign' on mailchimpThe campaign is reviewed and sent manually.The sent campaign triggers a 'change in status column' in the airtable.Is this kind of two-way sync possible?Thanks!

Hi all,I have 2 connected fillout quizzes.The first is set to create a record, which is working fine.In the end screen, I have a URL button linking to the next quiz.The second quiz is set to update a record, but in the results, it creates a new record.I add an ID in the URL parameter for both quizzes.Where do I go wrong, or what am I missing in the process?

Hello everyone!How can I manage user-level access in Airtable so that each role only sees specific tables or fields? Does Airtable support row-level or column-level permissions?Details:I’m building a structure where I have multiple tables (Operational, Manager, Admin), and each user role should only see the data that belongs to them. For example:Operational users should only see the Operational tableManagers should see both Operational and Manager tablesAdmin should see everythingInterfaces solve part of the problem, because I can show or hide tables and fields, but I want to confirm:Is there any way to implement real column-level permissions?Is there any way to implement true row-level permissions?Are interfaces the only recommended approach to hide fields and restrict access?I want to be sure I am building the structure correctly. Thank you!

I’m trying to enable users filling out a form to create a new contact. For context, I’m building a repository of companies and their points of contact. Currently, the “Add Contact” button only allows selecting from existing contacts already in the repository. Since this form is meant for intake, I want users to be able to create new contacts directly from the form and have them automatically linked to the company. When I reached out to support, they said when using Airtable's form builder, you can only link to existing records in a linked record field. Users won't be able to create a new linked records directly through the form. Are there workarounds or unique solutions to this limitation?

Hey Guys, i wanted to ask if a guest user via Airtable Portals has the possibility to actively work in interfaces and set for example a drop down menuitem to an different value or add comments in a single line text field, which then is updated in the base. Or is the guest user via Portals a read-only access and changes made are only visible for the guest user session? 

Hello,I’m new to Airtable and in trouble with airtable forms. For example, here is the situation.I collect weekly requests from my school friends through a Form.In the Form, they write how many of each drink they need and submit it.I then store all of this data in a database.Let’s assume my friend wants to fill out the Form like this: Cola: 5 bottles Water: 154 bottles Orange juice: 30 bottles Wine: 2 bottles Beer: 15 bottles I already have a base where each drink—Cola, Water, Orange Juice, Wine, Beer—is listed.However, it seems that the Form does not allow submitting multiple quantities for a single drink. Since I’ve only been using Airtable for a few days, I may be misunderstanding something.Could you please let me know if my understanding is correct?Or is there something that I can try? Thank you fo

Hi I'm working with Airtable Forms and using a single-select field for a Sample ID (which is a number). I'd like users to be able to add a new Sample ID directly from the form if it doesn't already exist, instead of being limited to the existing options.Is there any way to enable this "Add new option" behavior for single-select fields in Airtable Forms? Or would I need a workaround—like using a linked record or setting up an automation—to allow new Sample IDs to be created automatically?Appreciate any guidance

I am doing a hiring and searching for jobs database. I have made the form for everyone involved but would like for them to be able to change their availability status after having submitted the form. Is that possible? I haven‘t upgraded my subscription, I am still using the free version. I am new in airtable, still trying to figure it out if it is the answer for what I am looking for before I start paying. 

Hi!I’m close to reaching my storage limit on the “Team Plan” (20 GB). I’ve been deleting data to free up space, but I’m not making progress fast enough. Here’s my question:If I have a base with images in X number of rows, and another base with a “lookup” field that mirrors those images from the first base, will the images count twice toward my storage limit?

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.

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}

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} & " - $" &a