Ask the Community

I've created a table where I have a multiselect field, and then grouped the data by that field.The effect in my table is that each unique combination of selected fields from the multiselect column has it's own group. So for example, if one record has "A" in that field, and another has "A" and "B", I have one group that JUST has the record with "A", and separate group for the records that have ONLY BOTH "A" and "B" (so the first record with ONLY "A" is not included in that group).I know some people don't like this but I actually want it this way - and what's frustrating is that now when I'm creating a List Interface, it works the opposite! So my list of records is grouped in the interface by that same multiselect field, but now the records are duplicated across groups.So, the record with only "A" is showing up in the group that is labeled "A" only, AND in the group that is labeled for both "A" and "B".Is there a setting I'm missing to get the list view to behave the same as my table, or

I created a very mobile-friendly app using AirTable, had participants download the AirTable mobile app, and attempted to showcase the mobile interface with about 80 participants in a room. Participants complained of seeing completely blank screens or only partial amounts of data showing up.Is the Teams Edition insufficient for this use case, and do I need the business or enterprise version to handle this type of traffic? *P.S. The wifi was not the issue. 

So I’m a real estate agent and I use Airtable to keep track of all my deals. I have one block for rentals. In rentals it’s very common for a prospective tenant to want to see all my current active listings. I typically have 40-60+ rentals at any given time, some times more. Right now, when people ask for my list, I ask for their search parameters, go through the entire list myself, then respond back with a few listings. The problem is I have 25-75 people reaching out a day and 40-60 listings, plus an entire buy/sell side of the business. It’s becoming impossibly time consuming. So when I heard about the ability to create a shareable link to my up-to-date database, I got really excited. Especially when I realized I could hide fields that are for internal use only and I do not want prospects to see. But then I realized the primary field is the address of the unit and there is no way to hide this (but it’s really important to hide addresses for a lot of use cases I won’t get into right no

I’m currently selling my airtable base as a product. How to do that? Is there a way to create a user base that will be able to view the database? Collaborators would work best, but I don’t want them to see my changes and emails of other collaborators

I have been getting this very annoying bug where when I start editing on any interface page, the logo and header images on all of the overview pages across all of the interfaces in that base are automatically removed. Nearly every time I publish after making changes to one interface page, I have to reupload headers and logos to all overview pages. I hope developers can fix this soon!

Hi guys, I current have a button that opens a url that is a Make Web Hook, I was wondering is there anyway for the same button to also update the record.My plan is to open url to send email in sengrid, aswell as update status from Open > Sent. Has anyone done this before? Any assistance would be really helpful Thank you!  

I am testing a simple base approach which has three tables: Clients, Contacts and Jobs.The clients table has linked records to contacts to denote all the contacts that we work with at that client. And linked records to jobs to denote all the jobs we are working on with that client. A client can have multiple linked contacts and multiple jobs, but contacts and jobs can only be linked to one client.When I'm creating a new job record, I'd like to select the specific contact at the client who represents the lead contact for that particular project.I realise this can be achieved by a simple linked record field to the contacts table. However, when selecting from the contacts table, this shows all contacts regardless of which client they are at. Which theoretically means it would be possible to assign a contact from a different client than the job is for.What I was hoping was that there was a way to filter or add conditions to the linked record options so that when I go to select the contact,

I have Airtable views embedded on a google site page, and when you open a record detail you can see the attachment thumbnails in the attachments field, but then when you click on one of the attachments to view full-size, there is an error message "this page is blocked by browser". I have tried with both Chrome and Edge, and get the same error with both browsers.Attachment thumbnails in record detail:Error Message in Edge:Error message in Chrome:  

I'm building a project management platform. In my current configuration, there is a table for Projects, and another for Tasks. When a Project is created, an automation runs to add corresponding Tasks. The Project table has a "Status" field, with options for In Progress, On Hold, Canceled, and Done.When a Project status is changed from In Progress to On Hold, I added an automation that also changes the status of the underlying Tasks to On Hold (so the individuals to whom those tasks are assigned now to pause work on them).But how would I create an automation to switch that Task status back to In Progress if the parent Project status is changed back?If I set the trigger to be "when record in Project matches conditions (status = In Progress), it's going to update a lot of tasks that should be updated.Is there a scripting solution for "if a project was On Hold and now is In Progress, change all underlying Tasks statuses that were On Hold to In Progress"?

Hello,I have a base that has many tables that are synced via emailed CSVs. One table was initially set up with multiple emailed files where they were ingested as updates to the table, which resulted in the ~100,000 records needed. for initial setup.Since then, updates are sent through each night with updates (which are much smaller record counts). Some of the records that are updated causes them to fall "out of scope", meaning they aren't needed in the table anymore. I'm aware of the ability to delete records, one by one, that are not in the source data (current emailed CSV), however since the emailed CSVs are a much smaller subset, and at this point there are MANY "out of scope" records, it would result in searching through a list of over 100,000 records, for each record that needs to be deleted.Now, to my question - is there any way to mass delete records, given the circumstances described above? I am able to identify the records that are no longer needed through

What does done look like? (The requirements I collected)My CEO is wanting me to build a base that ties project management and PTO together for better task/project orientation.1. This base should display all projects and tasks as well as the leads and team members associated with them. 2. For PTO, the person's name should be linked with the dates that they will be out of the office.3. The dates for the PTO and Tasks should tie into on single calendar view that will allow my CEO to view everything from one place. 4. Alerts/errors should be displayed when a deadline or start date is set on a day where that lead, or assignee, is taking PTO.5. There should be an automated availability field that displays the persons availability for the week depending on their tasks/PTO assigned.  The base I have accomplishes 1-3, but I am stuck on completing requirements 4-5.Is there a way that this can be done?Have any of you built something similar to this?Any advice is greatly apprec

I am developing software for car appraisers and have structured my database with five tables:Enduser (Appraiser) - Unique identifier: Email of the appraiserClients of the Enduser - Unique identifier: Email of the client (One appraiser can have multiple clients)Vehicles of the Client - Unique identifier: Vehicle registration number of the client (One client can own multiple vehicles)Appraisals of the Vehicle - Unique identifier: Report number of the appraisal of the client (Each vehicle can have multiple appraisals)Payments for the Appraisals - Unique identifier: Payment number of the report number (Each appraisal can involve multiple payments)Is this structure appropriate? One potential drawback is that when importing data into related tables, I can only link one table at a time. Ideally, when I add an appraisal along with the vehicle's registration number, the system should automatically identify the associated client (based on the vehicle

Hi all,I have a really simple script as part of an automation, that is supposed to open the URL of an interface page item that was created earlier in the same automation.I'm aware there's a button to open a URL in the interface designer, but then i can't have that button run the automation... function NewTab() {            window.open(            "https://google.com_blank");        } There are no errors, but the URL won't open.Any ideas? I've searched posts here but all seem to be related to the scripting dashboard and not scripting within automations.Thank you!

I'm creating a platform for project and task management. I have multiple users and multiple interfaces.One of those interfaces is an Admin section where projects would be assigned to users via a dropdown menu. I'd like this Admin interface to only be accessible for select users. But it appears that users who aren't given access to this Admin interface cannot be selected in the project assignment dropdown. For now, I've given those users read-only access to this Admin interface, but I'd prefer that this interface be hidden for them entirely. Is this possible, either on our current Team plan or any of the other account levels?

HeyheyI'm need a dynamic filtering option in the interface so I'm trying to use the built-in filter. For some reason the filterable fields that appear are not all the possible fields but just a random selection. I need to filter by status but status field is not an option to filter with the built in filter. See screenshots. Anyone can help ?

Description:I am looking to create a photo contest application in Airtable for a  pageant where users can view contestant profiles, vote for their favorite contestants, and manage the entire contest flow. SetupContestant Profile Section: Each contestant can upload their photos, provide personal details (name, age, hometown, etc.), and add a bio. This section should display contestants’ information for voters to view.Voting System: A voting mechanism where users can cast their votes for their favorite contestant. Each user can vote once per day, and votes should be tracked and counted in real-time.Voting Results Dashboard: A dashboard for tracking and displaying current vote counts for each contestant, including graphs or charts for quick visualization.Admin Panel: A panel for managing contestant entries, approving photos, and monitoring votes. It should also allow the admin to disqualify contestants or flag suspicious voting activity.Voting Restrictions: Ensure that each user

I would like to use a link from Google Maps in an automatic Emil. every time the connection is rejected. I had previously entered an address in Google Maps and then went to "Share" and copied the link and then stored it in an email in Airtable. every time I get the following message: see attachment

Hello, I have two Date fields that need to show the time remaining (in years/months). My attempts at declaring the correct formula have not been successful. Here’s a screenshot with the field outlined where I want to show the difference. I believe this is the closest I’ve come: DATETIME_DIFF(TODAY(),Rent Commencement,Lease Expiration,‘Years’,‘Months’) Thank you! Anet Gambina

Hello, I am new to airtable My issue is I want to calulate the difference between two dates and calculate the seconds also, but i cant even add the seconds to the date how this could be calculated if it’s not even added. Im using the Datediff formula, is there’s any other solution?

Hey all! I have recently started using Airtable and I have been searching for an answer to this question for too long. I am attempting to track volunteer hours. I have a form that people will complete every time they have a “shift”. This form asks people when they came in and when they left. I want to create a formula that finds the difference of the End time and the Start time in order to find the total time of their shift. I have read through several ask the community questions similar to this and tried several formulas; including DATETIME_DIFF. However, nothing seems to be working. Please help! Thanks in advance.

Hi All, Apologies if this is a question already answered. I want to create a IF formula that reads for a single select sell and alters a formula dependant on what the single select field says. For example- where Delivery Month is my single select cell =IF(OR(Delivery Month = "MARCH",Delivery Month = "APRIL",Delivery Month = "MAY"), (Cost*2*4)+8), IF(Delivery Month = "FEB", (Cost*2*6)+8, ))When i place above in, the cell accepts it, but no calculation is done and cell is left blank. I am unsure why as i have checked spelling and spaces in my single select cell Thanks in advance for your help

I have a table Formation 1 in Airtable that contains various information, including a field named Status with values such as "refused", "accepted", and "pack". I also have another table, Formation 2, which contains different information and is synchronized with the first table. I would like to set up an automation such that if an email in Formation 1 has a status of "refused", it should be added to Formation 2 with the status set to "pack solo". How can I achieve this?

In Table 1, I have a list of names. In Table 2, I’d like a single select drop down list that comes from the list of names in Table. This way I can add more names to the column in Table 1 and have them show up as options on the list in Table 2. Can anyone tell me if this is possible? I have played around with linked records and can’t figure it out. Thanks, Jim

Hi, I have a Base called “BaseName” table with a checkbox field “Show in filtered view?”, and another view called “Only Filtered Items” of that table showing only checkboxed items. There are 74 total items and 44 of them are checked. And the “Only Filtered Items” view in Airtable itself contains only 44 items, as expected. But, when I export that “Only Filtered Items” view, it still contains all the items. The csv exported file is called “BaseName-Only Filtered Items.csv”. Is there some way to make the csv export only contain the 44 filtered items? Another detail, I filled out the checkbox field by copy-pasting from an excel sheet which was formatting as “Y/N”, but the check boxes look like they were inputted just fine. Lastly, I referenced Export selected records to .csv and I think it should be working based on that. So I’m not sure if I’m encountering a bug or something.

Our project management company is on the pro-plan and has multiple projects schedules in the one base, across many tables. From there, in each table/project we assign different team members, and have multiple different views for agendas etc. Is there a way to sync/combine the tables into one master to-do list for 1 team member? We are open to using automations, integrations, and even software outside of AT (if it can’t be done within AT). However, we don’t have much tech knowledge (we don’t know how to use automations well). If anyone knows of a way, that would be great. Thank you.