Ask the Community

Hi all, I am trying to create an automation such that when a person creates a new record in the projects table, a view is automatically created in the tasks table such that any records with that record are filtered to be the only records shown. I figured that this could be done with scripting, but I’m not sure how to create a view in the tasks table with a specific filter applied.

Hello everyone,I’m a beginner in Airtable.I created liked to another records in my database but it doesn’t goes out automatically. A helper said that I have to enter the link manually by clicking in the box and selecting the correct link to establish. He corrected the field books to show me an exemple. But I don’t see what’s wrong. Here is the link to my database :https://airtable.com/invite/l?inviteId=invaGndItH1AMLc6T&inviteToken=397c73d5eb028ef680e8e173e4a730b416c544f294d7c3917f344bbb0d0fe1c1&utm_medium=email&utm_source=product_team&utm_content=transactional-alerts 

I have noted several small but recurring limitations and ideas related to Airtable. I would like to understand whether these are on the product roadmap and, if not, whether practical workarounds exist. Enforcing a true unique key constraint on a table’s primary field Right-aligning numeric and currency values in the list interface Rolling up values in a self-linked table currently requires separate rollup fields per level and an additional formula to consolidate them into a single field Gantt chart dependencies only support day-level granularity; hour-level dependencies are needed A native delete-trigger mechanism Could you advise whether any of these are planned for future implementation, and what recommended workarounds exist today?

Hello everyone,I’m a junior data analyst and recently I was asked at work to integrate new data that is external to our management system. This data consists of Excel spreadsheets stored in Airtable. While researching, I noticed that there are several ways to integrate this data.For example, one could use “bridge” solutions like OneDrive or SharePoint, or connect directly to Airtable via its API.I was able to connect directly using the API (after creating a Personal Access Token), performing a blank query and using an M script to retrieve over 20,000 records. However, I would like to hear from more experienced people whether this could be the best approach compared to using a bridge solution. I personally think it is, but I would appreciate the opinion of experts.I have tested this with free accounts and demo Excel files with over 20,000 records, and I can retrieve them both directly via API and using OneDrive or SharePoint.Additionally, I understa

Is there any word on a feature to allow users to change the day of the week that you use for the first day of the week? I know a lot of US calendars will use Sunday for some reason, but I don’t actually know any businesses that run on a Sunday start. I’ve always used a Monday start to the week. And I’m pretty sure most of the rest of the world uses Monday to start the week.I noticed people have been asking this for almost 8 years according to the help center. And it seems like the easiest change.People were trying to suggest that we change our browser settings to some part of the world that does Monday start, and others were reporting that that doesn’t actually change the user experience. And making that change messes up every other application I use, so it doesn’t make sense. Just about all my productivity applications let you set this as a personal preference, and I’m kind of stunned this is still out there.How can this be escalated, or is there a way to see i

Should i sort it in  notion?] 

When I choose Blank Layout on Create Interface and add grid element manually, my right panel looks like this. When I choose List Layout to start, my right panel looks like this : How can I have this second option when I add grid element manually.

I have an automation that copies fields from one table to another once the checkbox is selected. One of the field is “Marketing, Communications & PR”. When the automation runs, it splits it into two items “Marketing”, “Communications & PR”. I want to have it as one sector when it is copied to the 2nd table. I tried some of the ideas mentioned previously but got confused. I can try “Marketing Communications & PR” which might solve the problem but don’t like it.Is it possible to solve this issue? Thanks a lot.

I'm working on a project where we use:- Postgres for our production app database - Airtable for our internal team (support, ops) The challenge: keeping them in sync without writing fragile scripts.Curious what others in this situation are doing:1. Are you using Zapier? (I find it too slow)2. Custom scripts with webhooks? (maintenance nightmare for us)3. Some other tool I haven't discovered?4. Did you just pick one and stick with it?We're syncing about 5K records and need changes to propagate in under a minute ideally. Any experiences or recommendations appreciated!

I am trying to figure out what is the best way to track tasks that have multiple layers and steps in Airtable. Let’s use an example here to explain: There is a task at my company where we track the payment for assets we purchased from a third party source which...Step 1 - requires sending an LOD (Letter of Direction) and making sure the LOD is acceptedStep 2 - tracking the payment is made to my companyStep 3, if applicable - tracking the pass through of a payment that was made to the prior payee rather than our company (which happens when the LOD is not accepted in time before the next payment cycle) So I would name each task (1) LOD, (2) Payment, and (Pass Through). Each task would have the following statuses to track:(1) LOD - Need to Send; Sent and Awaiting Confirmation; Revising LOD; LOD Accepted.(2) Payment - Waiting for Payment; Missed Payment; Paid.(3) Pass Through - Need to Request Pass Through, Requested,

We use a standardized setup of multiple Airtable bases per project, with one base acting as a central master.Example:For project P1, Workspace 1 contains three bases: A1 (master), B1, and C1.There are one-directional syncs from A1 → B1 and A1 → C1.We want to duplicate this setup for a new project (P2) into a new workspace, resulting in bases A2, B2, and C2, while: retaining the same sync structure (A2 → B2 and A2 → C2), keeping all interfaces intact, and minimizing manual setup or reconfiguration. Achieving this would allow us to deploy a reusable, project-based Airtable application with minimal effort.

Once a project is created. How do I link phase/ category that is linked to another project but not have task also link to new project 

Hi everyone,I am using Airtable to manage our Recruitment process, and I need some advice on how to handle user permissions and data privacy.I have two specific challenges I'm trying to solve: Field-Level Security: I have a "Salary" column in my base that is highly confidential. I want to ensure that certain team members cannot see this specific field. Historical Data Restriction: When a new staff member joins the team, I want them to only be able to view records created from their start date onwards. I need to find a way to hide all "historical" records that were created before they joined the base. What is the best way to achieve this?Many thanks.

I have a list of names in the format John Smith MD or John Smith, MD (some with commas, some without) and I’d like them to be in the format Dr. Smith. Is there a formula that can do that for me?

Hello all,I'm working on an automation that was working prior. Now when i changed fields on other tables (added lookups and notes that are not in automation) that were affecting it stopped working.I was working on a backup and I restored it back to normal and still not working.After running some test I see that the first step that is create record its not populating, therefore when I link back to that record it doesn't recognize it. None of those fields were changed but I did add lookups to that table and deleted a few fields that weren't necessary.I went back to revision history to see if I'm missing something but everything seems to be the same and now I cant link records. don't know what to do.Also the webpage asked me to refresh several times.The testing was working on the main CRM and when it stopped working on the backup it stopped working on the main as well (where I wasn't working at the moment)

Disregard...no way to delete

Hi all,We currently use Airtable as an HR Management solution. It contains tables and data to store all sort of sensitive information regarding the employees.This leads to a big problem: whoever has the right to build the Airtable app, sees data that he should not have access to.I know that if we are talking about end users, it’s possible to mask specific information in the interfaces. But here I’m in front of a different requirement:Somebody who has the right to design and build the solution should not have access to the underlying data, or at least to part of itI believe there’s no way to achieve this? Anybody else is facing the same problem?

I built a small site using Softr + Airtable (Free plan, working as a data sourcing). My site reaches Airtable API calls litmit very soon every month. Just a few days, the limit of 1000 calls has run out. I don’t think there are so many visitors to my site. I want to know whether one API call is counted when one visit to my site? My site is https://www.petfairsea.com/ can anyone help point out the reason of this issue. If there are really so many visitors, I’d have to upgrade to team plan. Thank you in advance. 

I’m tentatively looking for a freelancer to help another department in my business get their Airtable database off the ground - Creative team to manage projects.This is a fairly simple, and short, job that I’d do myself but simply lack the time, and the department has no capacity themselves to be trained up to do the work themselves, so this is very much a capacity issue. Interest?

Hi, I used to be able to download CSV files, but without changing anything, I can’t do it anymore.When I select “Download CSV”, I don’t have the option to name the CSV and that made me choose the file where to save it.I tried with different browsers, private windows, different laptops, cleaning the cache and cookies. I'm not sure what to do. Any ideas? Thanks for your help!

Hello,I’m curious if anyone here has connected Airtable to Lightspeed restaurant U Series POS?  Either directly from Airtable to Lightspeed or indirectly with a third party like Zapier.   I’m trying to pull daily sales and labor data from my POS into Airtable.  We are working on creating better internal tools that our managers can have access to.  Tools that would track our main expenses like labor and COGS.   I’m having a hard time getting the connection done.  Airtable is not currently an integration partner with Lightspeed U Series.  Neither is Zapier or something like Make.com.  So I’m looking for someone with experience with these specific platforms. The people at Lightspeed have not been super helpful.  I know I can’t be the first person to try to pull data to Airtable (or even something like Google Sheets).   Thanks

I have three Tables. - Commit Items, Invoice Header, and Invoice Detail. Lets assume that For Commit No ACB001 there are 4 Records in Commit Items Table with many records for other Commit Nos.. When the invoice is received for Commit No ABC001 and entered on Invoice Header table with Invoice No and Commit No ABC001, I would like automation to grab four records from Commit Items table and create those 4 records + Invoice number in Invoice Detail table. How do I achieve this? Just a reminder, I am new to AirTable.

Hello all,  I want to update a record and use the famous trick to have another table and submit form.In the form a field contains the record_id of the line I want to update in the original table.When I submit the form, the automation fail, when I copy/past content of the cells in another line, the automation works.Here is a screencast to see the problem : https://youtu.be/DSfKKBnmfe0 And exemple of the lines (line 16 works well, line 15 breaks) : 16    rec4CbEaxD0FOSwWL    rec4CbEaxD0FOSwWL        Screenshot 2026-01-14 122852.png (https://airtable.com/appNAdRee7AIuvFLH/tblvVVZzS2tZ1btmg/recKXwRxIfZIWB847/fldD1Py2VRj2AtySo/attJtOQ7i1jcZtgKR)    Devis signé    checked    checked        15    rec4CbEaxD0FOSwWL    rec4CbEaxD0FOSwWL        Screenshot 2026-01-14 122852.png (https://airtable.com/appNAdRee7AIuvFLH/tblvVVZzS2tZ1btmg/rec16w5uCNmtP2gXq/fldD1Py2VRj2AtySo/attyeeGMrStyZYyDk)    Devis signé    checked    checked

I’m building an integration that needs to sync ~6,600 records from an external API to Airtable, ideally in under 1 minute.Currently I’m hitting the standard REST API limits (10 records/request, 5 requests/second = ~2-3 minutes minimum, but in practice it’s taking 10-13 minutes due to network latency).I’ve looked into: ∙ Sync API (CSV) - but the table becomes read-only, and I’m seeing significant processing delays after the request completes ∙ REST API with performUpsert - works but slow at scaleHas anyone found a faster approach to bulk insert/update thousands of records? Any workarounds or techniques I’m missing?For context: manual CSV import through the UI takes ~5 minutes for the same data.

Good day.I was tasked to give the following:“Ideally I would like to see the top 15 and the bottom 15 courses delivered per year. So maybe all courses that have a number of time delivered and then a section with all the courses that had no delivery in 2025.” Below, I’ve grouped a grid element by first the year, and the times a course delivered, to at least sort it out.  How, would you all suggest a “pretty” way of achieving the request?