Ask the Community

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 understand that the client has a paid Airtable

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 if it’s on the roadmap?

unfortunately there is no way for 3rd party clients to update an existing record ussing forms. it creates a new one upon submission. it would be great if users can click on a link which opens up a partially filled in form > they fill it in even further and hit ‘ update’. updates existing record rather than creating another.

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 had Omni build a Form for users to collect new record information. It has two levels: Claims and Claim Details. I wanted it to allow a user to create a new “Claim” and the continue to add each new “Claim detail record” from this same form. It works in the regular interface, but as a form it only allows the user to select from existing “Claim Details.” Is there a setting for that field that I need to change in order to adds new detail records?

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, Paid. I don’t want to create a Single Select option for Tasks and Status

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.

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)Please help me!This project is really important to me since this will be the backbon

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

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        And in automation the condition which doesn’t work : 16 RECORD_ID

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? 

I’ve seen similar questions asked, but I can’t quite find the solution I’m looking for.I manage a fairly large (~2000 item) equipment inventory. I have a system to check items in and out to different people, projects and locations. Basically, I have a table of inventory items, and a table of in/out transactions that links to the inventory table and includes quantity checked out, destination, program, etc. I also have a form for various users in the company to create a transaction record, and dynamic fields in the inventory table to keep track of how much inventory is available, and how much is checked out and to whom. Screenshots below:Inventory TableTransaction TableCheckout FormOutstanding Inventory interface viewThis is fine for checking out a single inventory item, but it’s rather slow and cumbersome for checking out multiple items at once. Think someone loading a truck with a barcode scanner. I’ve seen Fillout recommended multiple times here and gave that a shot, but wasn’t very h

Hi all!I'm trying to make something in Airtable which I think should be possible, but I haven't quite wrapped my head around how to make it do what I want.Here's the situation:I want a team to fill out a form with information which can apply to specific regions and/or date ranges. If one or both of the regions does not have an entry for today, I want to send them an automated email reminding them to submit an entry.I've got a base structure which looks something like this:The form part is easy, I have no worries there. Also, I was already able to set up formulas in the last 2 columns which determine if today or tomorrow is between the start and end dates.I thought I could then use logic in Automations to send an email if it encounters entries where:“Today within range” = not ticked anywhere “Today within range” = ticked in one or more entries, but Region 1 is not ticked in any of these entries “Today within range” = ticked in one or more entries, but Region 2 is not ticked in any of th

Hey everyone!I built Sheet Wizard - a Chrome extension that lets you bulk update Airtable records using natural language commands instead of manually clicking through rows.For example: "Set all records where Status is 'Done' to Priority 'Low'" or “Update Due Date to 2026-01-10 for all Marketing Campaign records in Project"It's live on the Chrome Web Store with a 7-day free trial. Would love feedback from the community!Happy to answer any questions!https://chromewebstore.google.com/detail/sheet-wizard-for-airtable/ofhnpikabgcaihpaohanedkodjfgboiahttps://www.getsheetwizard.com/

Hello, We have went over the automations rate for airtable on business plan 100k. However, there appears no easy way to upgrade and a base that runs an app stuck with no ability to resolve. We’ve sent support email but no response yet.  Any solutions or way to get in touch with airtable so we can resolve this issue. This is costing us big. No response from their sales form either yet.