Development & APIs

let twoLettersToNumber = { "ah": 5, "ch": 8, "wh": 16, "tz": 18, "sh": 21, "ta": 22, "th": 22,};let lastLetterToNumber = { "m": 12, "p": 12,};let letterToNumber = { "a": 1, "b": 2, "c": 11, "d": 4, "e": 5, "f": 18, "g": 3, "h": 5, "i": 10, "j": 10, "k": 19, "l": 12, "m": 13, "n": 14, "o": 6, "p": 17, "q": 19, "r": 20, "s": 15, "t": 9, "u": 6, "v": 6, "w": 6, "x": 15, "y": 16, "z": 7,};/** * @param {string} token * @param {{ ah?: number; ch?: number; wh?: number; tz?: number; sh?: number; ta?: number; th?: number; a?: number; b?: number; c?: number; d?: number; e?: number; f?: number; g?: number; h?: number; i?: number; j?: number; k?: number; l?: number; m?: number; n?: number; o?: number; p?: number; q?: number; r?: number; s?: number; t?: number; u?: number; v?: number; w?: number; x?: number; y?: number; z?: number; }} dict * @param {number[]} arr */function tryInsert(token, dict

In my automation script I am running a fetch request. In some cases the fetch requests takes longer than 30 seconds which results in an error. I don't really care about the fetch request result because it is a post request that is doing all it needs to however the error each time it runs is annoying.Does anyone have any suggestions on how I can run the fetch request without waiting for a response? Or perhaps there is a way to handle the error gracefully?

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

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 exceeds the 10,000 record sync limit? I'm open to alternative approaches if the Sync API isn't the right tool for this use case.Any guidance or examples would be greatly appreciated!Thanks in advance!

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

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?

HiI want to be able to generate a barcode/QR code upon approval of incoming goods.Once generated, each packet that has been approved (receipted) from incoming goods needs to be able to be printed in bulk along with the details of each packet.The packet tag will then need to be viewed within Softr interface when scanned via the users mobile camera.Anyone have experience with making this work with Softr as front end (for taking the camera scan) with AT as backend? Or any suggestions?​@ScottWorld  ​@Mike_AutomaticN ​@TheTimeSavingCo ?

Hi Airtable builders!Thanks to SyncBase (my Airtable - Shopify integration), you can now create new Shopify Products and Variants directly from Airtable. How does it work?Once you installed the app (can be found on the Shopify App Store), select “Products & Variants” as data you want to sync.  The app will create for you new synced-tabs into a new base (or an existing one if you’d prefer). In the Products tab you will be able to create new records (blank or with already prefilled data). Each new record creation will trigger a product creation in Shopify (draft status, no stress :D). => And of course, you will then be able to edit all this Product data from Airtable too.  Happy to get your feedback and to help if needed :)   

Hello. Am developing an app using Flutter. Would like to find if I can use Airtable as my database. Is there an API that I can use to integrate Airtable with Flutter? Will need to be able to do all CRUD operations. If so, is there any documentation that I can refer to? Thank you!

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

let table = base.getTable("Copy-Orders");for (let record of resulttxt['Data']) {    let recordId = await table.createRecordAsync({        "Order": Number(record['orderNumber']),        "Due Date": record['dueDate'],        "Order Total": record['orderTotal'],        //...        "Quote Number": [{id: '24229'}],    });}output.text("Created orders records OK!"); //tips:The field name is "Quote Number", the associated table name is "Quotes", the associated field is "Quote", and record['quoteNumber'] is the value to be inserted. how to deal with the  "Quote Number": [{id: '24229'}], for example,the value of Quote Numbe is  '24229'. thank you.

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?

I’ve been banging my head against a wall here. `block run` appears to run successfully but the webserver isn’t returning content and instead is returning a 404. A `block release` works successfully and I can see the `Hello World` in my extension. It’s running on port 9000 and it’s listening cause I get a response, it just doesn’t have any content.Any ideas?

I am using airtable to dynamic my website content and erliear it was working but now because of i have free version and too many request are there in the website so it shows me “429” error code and data doesnot fetched.

Hi, I see that Airtable doesn't list a php sdk, but I found 2 and saw another user on here mention another.  So, what's the most current, works with the current and near future api?  I’d like to get started but don't want to spin my wheels on a dead sdk.  Thanks :)

Hi everyone! Hoping someone here can give me a hand 🙂ContextI’m building an automation with n8n + Airtable to generate training plans and workouts.Airtable structureI have two tables: Training Plans Each record corresponds to one person (with their athletic info). This record is the input for generating workouts. Workouts This is where the sessions created by OpenAI through n8n are stored (workout type, description, etc.). It has a field “Link to another record” pointing to Training Plans, so each workout can be linked back to its plan. Desired relationship: One plan (1) → many workouts (N). Every workout should be linked to the correct training plan for that person. What I needI want the automation in n8n to not only create the workout records in Workouts but also automatically link them to the corresponding Training Plan (via the Link to another record field).Where I’m stuckThe workouts are being created fine (with type, description, etc.), but the link to the

Hi everyone,My company has ~100–150 employees with a small dev team of 2–3 developers. Our developers are looking to start building custom Interface Extensions for Airtable, while still allowing some of our more technical team members to continue using Omni to build simple bases themselves. I’d like to set up proper version control in GitHub so the dev team can collaborate effectively. My main questions: Do you use GitHub (or another system) for version control with Airtable custom extensions? If so, do you manage everything in a monorepo(shared libs + extensions for multiple bases) or separate repos per base? Any best practices for balancing developer workflows with contributions from more technical, but non-developer, teammates? Would love to hear how others are approaching this. Thanks!

Does anyone know if there is a special developer account or registration method that allows us to use the features of Enterprise as developers so we can showcase things for our clients? For example, I am currently hitting the 125k record limit in a mission critical base located in our primary Business tier workspace. I have no business upgrade path as I am not on Enterprise myself and yet I need to be able to support our client at the Enterprise level without joining their organization.

If anyone is interested we created an Airtable Shopify Integration (SyncBase) as we needed it.It instantly syncs your store data both way so you can update your products catalog, received orders to follow your raw materials stocks and do a lot of others importants operations.We planned to create our custom ERP on Airtable and then use this app to received and send data to Shopify.Happy to get your feedbacks in order to improve it!

Hi, I’m trying to follow the extension first tutorial and I have an issue when I load the “http://localhost:9000” website : “Cannot GET /”. Any idea for this issue? Best,

Hi there! I have an automation currently setup in Airtable that sends a slack anytime a tag is updated when an order comes through our system. The automation sends the customer name and total in the order and a link to the image. I am trying to find a way for it to send an actual attachment of the image, as currently I have an employee going in and manually sending it. This is what Airtable support said below. And attached is an image of what the automation looks like.  Let me know if anyone can help guide me through this. Thanks!  “As a workaround, this could be achieved by setting up a custom script in your automation that uploads the file directly to Slack. That path does require some scripting knowledge and familiarity with Slack’s API.If that’s of interest, you might consider reaching out to our community or one of our Airtable Partners for help with implementation.”

Hi,here is the solution to this frequently asked question. Just replace the value in delay( ) to change the time of delay. The maximum delay you can give is 30 Sec per action or automation will fail. For adding more delay the work way around is to add two scripts actions one below the other (See Image).function delay(ms) { var limit = new Date(); limit = limit.setMilliseconds(limit.getMilliseconds() + ms); while ((new Date()) < limit) { // do nothing ; } } delay(20000); //delay 20 second

Hello!I have a question regarding the batch_upsert method in the pyairtable library.Does batch_upsert update records even if the incoming data is identical to what's already stored in Airtable? Specifically, will the “Last Modified Time” column be updated in such cases?Example usage (python):table.batch_upsert(records=batch, key_fields=key_fields, typecast=True) From my testing, it seems like some records are not showing an updated timestamp, even though they were included in the batch. I'd like to confirm if this is expected behavior.Thanks in advance!