Development & APIs

https://airtable.com/invite/l?inviteId=invuYBzw8FmryWGPT&inviteToken=3e8b535eecb350617997aaa9c9e0c49b3be2d1c99a73fb32aed8f54c4befe51b&utm_medium=email&utm_source=product_team&utm_content=transactional-alerts

Hi all! I’m looking for an app that will allow, either via direct integration or Zapier, for the dynamic creation of a pre-filled document for e-signature. There are tons of options (too many) out there, but I’ve yet to find something which meets all of my requirements: Create a pre-filled, yet still editable, document with data from Airtable (likely triggered by Zapier) Get the URL to that document BEFORE sending it to the signer. I do not want to send the document to a signer from the app itself. Rather, I want to retain the link in Airtable, and send it off to an individual in an email, based on a separate trigger. Trigger Zapier upon receipt of the signed doc I’ve tried many apps… I had high hopes for Formstack Documents and the new block, but upon sending the created document to Formstack Sign, the document is flattened and the signer can no longer edit any fields. PandaDoc doesn’t give you a URL to the document until after all parties have signed. If I could just grab bits and

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?

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

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.

I am so happy and excited about the abilities for Omni to code a custom interface page and to make a custom extension and host as a page.  but I am having a ton of difficulties and challenges in figuring out how to do what I want to do—even with cursor help.  I want to create a custom interface page with the extensions that act like a normal list view but has an improved/optimized record detail view that includes the flexibility features I want for building interfaces pages.  here is what I want to do, and I am hoping to have some guidance or help for record viewer Floating/static Header control + adding a “status field” to the right of the header that also floats Making groups able to collapse and expand on title  Pagination or tabs that I can custom organize, name and assign groups and/or fields to to make long record detail pages, shorter I have tried and tried again. But all the Omni produced pages are incredibly buggy and impossible to tweak and don’t have the functionality. and I

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 :)

How to export Table into MYSQL table file or CSV?Can be synced table from Google Sheet into MYSQL?

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.

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!

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!

Is there any option to integrate Adobe e-signature with Airtable? If yes, can someone please guide me through it?Based on the data entered in the Airtable, I want to create a PDF file which would be mailed to 4 different people to sign it. I also want to know that how can I create a PDF based on the data entered and automate to send it to all the people in the list and get it signed one by one with first in the list as first and so on. 

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!

We are a small manufacturing company, and have moved most of our inventory into Airtable for our current build and possibly will continue to use for future buildsIs there a script I can use to stop duplicates from happening within a table? Is there a way to move about parts from one ”location” (which is already a table in the base) to another without physically having to continuously go into the data base?  continue question from above - is there a way to have 1 part but with multiple locations? We have parts that are stored in multiple staes (eg: flat parts and then folded parts but both are the same part) what is the best way to show this other than having multiple part numbers or prefixes for the same part.Hope that all makes sense…..

Hi there, I have IFTTT applet that creates a new Airtable record when a Google calendar event begins. The description for the event comes in as HTML. I’ve been looking for a script that could convert the HTML to rich text so that it is more human readable in the base. I know about the Marked Preview app, but I don’t think that’ll be the best solution, since I will be embedding this base and I currently cannot embed apps. Any help is greatly appreciated.

So while updating my table coffee shops, I accidentally removed trading hours from MANY shops.I easily fixed this with Ctrl+Z, but now even though the data looks correct, the data is not being pulled from airtable to my website. If I duplicate the entry, same issue. But if I remake the entry EXACTLY the same, then it works. How can I resolve this? The issue is that airtable is showing me data that looks correct, but is syncing incorrect data.

We recently added the ability to create tables, create fields, and update field options from the scripting app. The methods to perform each of these actions are the same as in the Blocks SDK. base.createTableAsync table.createFieldAsync field.updateOptionsAsync Refer to the Field Options documentation to see which options are supported for each field type The field types that are allowed to be created via base.createTableAsync and table.createFieldAsync are: barcode checkbox currency date dateTime duration email multilineText multipleAttachments multipleCollaborators multipleRecordLinks multipleSelects number percent phoneNumber rating richText singleCollaborator singleLineText singleSelect url The field types which cannot be created are: autoNumber button count createdBy createdTime externalSyncSource formula lastModifiedBy lastModifiedTime multipleLookupValues rollup These three new methods are currently only supported in the scripting app, not in automation “Run a script”