Ask the Community

I have someone who is set as an editor, but she doesn’t have the ability to edit the form associated with the base and can’t delete columns from the base.  These seem like some basic functions and editor should have and I’m trying to figure out if I did something wrong or if creators/admin would be the only ones to be able to do those sorts of edits.  It may have been this way all along and I just never realized it until yesterday.

Table 1 is a database of completed projects, table 2 is a list of invoices. How do I have the linked field in table 1 link to the next available invoice # in table 2? The invoice #s cannot be duplicated and I’d like them to stay chronological. All of this is currently set up, but it’s done manually. First, by searching what invoice # is next then in table 1 under the invoices field, create a new record with the next invoice # in line. Is there a simpler way to do this? Table 1 Table 2

Hi All, I have a field of type multi select option in airtable form. I would like to prefill that using Prefilling form feature of airtable. I have referred below airtable documentation for the same. But, this option didn’t work out for me. Airtable Support

Hello - I just upgraded to the Pro-plan because it said the org chart allows you to “view hierarchical links between linked records” - but what I didn’t realize until now is that only works for fields within the same table. I’m trying to view how I’ve linked my tables (which I built in the “free” version) - I need to see this visually with connector lines showing the relationships (one to one, one to many, etc) between the tables - can someone help me figure out how to view all of these relationships at once on the page with connector lines? I’ve scoured the help resources and cannot find it. I’m worried this doesn’t exist?!!

What is the calculation behind the Timeline Utilization summary?  I am trying to create a formula column that displays a resources utilization in the Resources table, to be used as a metric on a landing page.I tried ((({Task Count} * 8) * {% Commitment} ) / (40 * {% Availability)) , but it does not match what AirTable is showing on the Timeline view.  The task count is the number of tasks for the current day. Is there a way to simply access the calculated value? Thank you,

I am trying to understand how Airtable API Rate limits work. It says The API is limited to 5 requests per second per base. If you exceed this rate, you will receive a 429 status code and will need to wait 30 seconds before subsequent requests will succeed. Is the limit per base per API key or per base per IP address?. Saw an answer in the forum but it is 4 years old and mentions airtable plans to change how it works. I ran a simple code to try and trigger rate limiting but airtable api was able to successfully respond to more than 20 api requests per second without running into api throttling

Is the API Rate Limit tied to an API Key? Or to an APP ID? Or a combination of both? I have developed several websites that pull and/or sync data with Airtable, and while none of them individually will generate more than 5 requests per second, I’m now concerned that (since they’re all using the same API Key) they will collectively generate more than 5 requests per second. However, if the Rate Limit is tied to the API Key and APP ID, I have nothing to worry about as each application is built using a different Airtable Base. Please advise! Thanks!

Hi, in order to consent my bank service platform to receive api requests from airtable, I need to put on his whitelist the ip address from which API Requests comes.Reading documentation I found they should be 52.44.24.118 and 3.215.151.50but not working...Any suggestions?ThanksPeppe 

Hi everyone,I’m working on a workflow where I’d like to bring live job costing data from QuickBooks Online into Airtable, specifically linked to Projects (i.e. QBO “Customers” with IsProject=true).The goal is to have Airtable show income and costs by project, so that project profitability and job cost tracking are always up to date. Ideally this would cover both accrual (Invoices, Bills, etc.) and cash-basis (Payments, BillPayments, Expenses, Checks, etc.) transactions — pulling the amounts tied to each project’s CustomerRef and syncing them into Airtable tables for Projects and Job Cost Lines.Has anyone here implemented something like this — a live sync or near real-time integration between QuickBooks and Airtable for job costing by project?

Hi everyone,I'm looking for advice on implementing a nightly data sync workflow.My Setup:CSV file with 25,000 records that needs to sync to an Airtable table Currently using the Sync API, which has a 10,000 record limit Need to perform a complete refresh (delete all + re-sync) every nightThe Challenge: Since my dataset is 2.5x larger than the sync limit, I need to send the data in 3 batches. However, I'm struggling to find the right approach to:Clear the entire table before syncing Successfully sync all 25,000 records in multiple batchesWhat I've Tried:Various sync configuration settings Setting up a webhook-triggered automation to delete all records before syncing Different batching strategiesMy Question: Has anyone successfully implemented a nightly sync workflow for CSV data that e

Dear Airtable community I need your help, please. We’re currently using Pipedrive (PD) to track our customers throughout the sales process and I’d really like to automate adding information to Airtable (AT). Does anyone know if there is a way that, when an orders is WON on PD that this customer record can automatically be created in AT? We have broadly similar fields, but from looking at Zapier, I can only see this linked to all activity updates/ creation of records, but not specifically something that ‘runs’ when an order is WON. Really hope you can help…! If I’m missing something that would help answer the question, do please ask and hopefully this is something that I can get up and running. Thanks in advance, Mark

My Team plan has reached its API Public rate limit, evidently.It’s never happened before.How do I see my usage?Is there anything I can do-- can I get some more for this period?

We would like to keep the permissions of two bases (one a clone of the other) in sync.In order to do this, is it possible to manage permissions via the Airtable API?Specifically: field-level, table-level, and base-level permissions.Thank you

Hi, I am pretty new to this and not a developer. We are using Airtable for our product database for our Shopify store, and have Airpower as the sync between them. This works pretty good, but there is one major thing we need that Airpower does not support.We need the number of "committed" inventory of the products to sync from Shopify into Airtable in real-time. Right now, the Airpower Inventory sync only brings the "available" number through, but both are required for us, and we need the data to by syncing constantly so it's up to date.Is this something we could use a webhook for? Or is there a simpler process?

Is there a way to use Airtable sync to conditionally sync data from one base to another? I need to only sync specific records and not all of the records in table.If it is not possible using Airtable sync, is there any other way of accomplishing this?

When creating a PRD or similar and I want to copy a User into the file so they are aware of the update I have always used the @ sign and selected the email from the dropdown list. When I then come out of this the email has automatically been sent. Do I also need to set up an automation? I have not done this previously as it is not always to the same person / group. 

Am I overcomplicating this?I have an automation to create a time stamp in a Date Completed field when a Status single-select field is changed to Done. The Date Completed field is populated with the full date and time, but I need to utilize this information in a Reporting interface for my management so I’d like to be able to have them select the month from a Dropdown Filter. To that end, I’ve created Month Completed field that uses a simple formula to just show the 3-letter code for the month, based on the Date Completed field.The issue I’m having now is that I’m not able to use that 3-letter code (because it’s a formula field?) as a filter on the Dashboard.I could create another automation that’ll convert the formula field into plain text or even a single-select field, but I feel like I’ve now created a whole bunch of steps to do something that might be accomplished in a simpler method. Note that the Month Completed info isn’t being used anywhere else. Th

I have a few collaborators that have editor access, but keep getting an error message stating “You are not permitted to perform this operation” when trying to submit a form that creates a record. They can update records without any issue, but I can’t seem to get it so they can create new records.   This is through a form in an interface, but I can’t find anything that would prevent them from submitting the form. There are no restrictions within the form itself that I see. I’ve checked that they have Editor access to the specific interface, there is nothing on the interface page with the form that would allow me to make any restrictions, and I’ve confirmed the table where the record is being create allows for collaborators with editor access to create new records.  I then created it as a separate form, not within the interface and the only way we could get it to work was to open the access to anyone, which we don’t want.  Can someone point me

I have an Airtable base that includes a Form View in a particular Table. I would like to be able to create a new Record in that Table and fill in some, but not all, of the fields for that Record. I’d like for the remaining fields for that record to be filled in by someone else. Can I send a URL that is unique to that record for that person to go to and fill in the remaining fields?

Hi all! I have a problem that I feel should have an obvious solution: I’d like to set up an Automation that normalizes a string value after input by base collaborators. However, the Automation appears to run too early, catching only parts of the input string. (This behavior is not consistent, though: From time to time the Automation will catch the whole string.) I selected When record updated as trigger and configured it to watch only for changes in a specific field (in my case: Keyword). Example from the screenshot: The entered text is “Aldi Angebote”, but the Automations appears to run already after the first letters are typed in, so only “Ald” is used as Automation input. What’s the best way to solve this problem? Is there a better trigger for this use case that I am missing?

NEVERMIND - I filtered out the empty ratings. Thanks!

I have an Airtable that is populated from Jotform submissions. The Jotform has a configurable list that for someone to fill in their schedule for the week. The configurable list can’t be split in Jotform so I’m trying to split information in Airtable. I want all of the days of the week listed in the configurable list cell to be extracted in a Days Open column but can only figure out how to extract the first instance using regexextract.  For example the configurable list will come in as:Day Open: Monday, Opening Date: 2025-06-16, Closing Date: 2025-10-27, Start Time: 09:00 AM, End Time: 02:00 PMDay Open: Saturday, Opening Date: 2025-08-09, Closing Date: 2025-08-30, Start Time: 10:00 AM, End Time: 04:00 PM and I want Monday, Saturday to show up in the days they are open. 

Hi everyone! 😄I’m trying to create a script for Airtable Automation that limits the number of records a user can create per page in Softr + Airtable. The idea is: Table: Projects Field that identifies the logged-in user: Criado por Field that identifies the originating page: Página Acesso Limit of records per user per page: defined in the script (e.g., 3) Desired behavior: if the user tries to create more than the limit, the extra record should be automatically deleted. So far, I’ve tried using Find records + Delete record in the automation, but it didn’t work as expected. I’m looking for a ready-to-use script or example that does the following: Count how many records already exist in the Projects table for the s

ObjectiveI would like to automatically import files (PDF or other formats) into Airtable, from either: a local directory, or a Google Drive folder. ContextI currently have a CSV file containing the drawing numbers.However, since it’s not possible to include file attachments directly in a CSV, the corresponding files (PDF drawings, images, etc.) are stored separately in a folder.RequirementI would like each file to be automatically matched with the correct record in Airtable, based on the drawing number, in order to consolidate all data and files into a single, centralized table. Thank you in advance for your help.

Hello,I am creating a management system for tracking the required materials for projects. In each project, there will be predefined material quantities needed to complete the project. When the work on a project starts, the user will generate a Purchase Order (PO) (third table) and add multiple materials through the interface. I need some help in creating this interface.The base design is as follows:I have two base tables. The first one is called the Master Material Base, and the second base is called Jupiter Castle.The structure for the Master Material Base consists of one table called the Master Material Table, which contains four fields: code, description, type, and unit. I have granted permission to share and sync this table with other basesIn the second base, Jupiter Castle, I have the following design:(First table): I have synced the Master Material Table into this base.