Development & APIs

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.

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”

I am creating a Airtable base for HR recruiting purposes. I use the Airtable form to collect information from potential candidates. I would like to collect only their LinkedIn Profile URL and contact info (email or phone). Using the collected LinkedIn Profile URL, I would like to pull info such as Name, Location, Experience, Education from LinkedIn into Airtable fields. Can this be done by Scripting block or is there a better alternative solution to this? Your help is greatly appreciated. Thanks in advance.

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?

Is there a supported way to update Script Extension code using an API? For example, have scripts stored in a GitHub repository, built using GitHub Actions, and then deployed to Airtable. Currently, my team have just been manually copying and pasting code they build locally onto Airtable, which leaves a pretty large hole for human error (even ignoring the tedium of such a task).I have a horrible workaround that I may use if necessary:/** * Fetches and executes the JavaScript file at the provided `path`. * This can be thought of like: * * ```js * await import(path); * ``` * * Except this bypasses CORS and directly injects the remote code. * Wildly unsafe. * * @param {string} path */async function fetchAndRun(path) { const response = await fetch(path); const text = await response.text(); eval(text);}const myExternalCode = "https://gist.githubusercontent.com/ZacHarroldPartum/fa0f6b6e707c8de3edf725ea0747bba3/raw/2f2fd47a248e8c3954727755ad35ac00193ef113/hello_world.js";await fetc

I’ve built a custom scripting extension that I intend to launch from a record button, send that record’s ID to the extension, and execute my script. I configured the button to launch my extension, which it does, but I can’t seem to get it to register the ID of the record clicked. I’ve tried using both useRecordActionData and registerRecordActionDataCallback, the latter example can be found below:function CheckAvailability() { const [recordActionData, setRecordActionData] = useState(null); const callback = useCallback((data) => { console.log('Record action received', data); setRecordActionData(data); }, []) useEffect(() => { const unsubscribe = registerRecordActionDataCallback((data) => { console.log('Record action received:', data); if (data && data.recordId) { console.log(`Button pressed on record: ${data.recordId}`); // Process data here } else { console.error('No recordId found in actio

Hi community, I recently had to solve the situation where I needed to get URLs from hyperlinks stored in rich text formatted long text fields and put them in another long text field. Essentially, just showing the URL, not the hyperlinked text. I ended up adapting the "Convert attachments to URLs" script (posted by Alex Wolfe). I had found a post here, that used a regex expression but this seemed to only work for visible URLs. I never could get it to work for my use case. I'd love feedback on what I could have done differently/better as I'm sure I haven't thought of everything... or even may have just completely missed something obvious. Thanks!// Script settings - Click the gear icon for the Scripting app to surface these anytime // Surfaces options to select the table, view, and fields needed in the script let config = input.config({ title: '🔗 Extract URLs from hyperlinks', description: 'Extracts URLs from hyperlinks stored in Long Text fields with rich text

Howdy all, I promise I really have looked at exisitng topics but there is information overload. Ideally I would like ot use ODBC driver to connect to AT to Windows via ODBC driver, I found several but they are all expensive subscriptions.  It seems AT may have its own ODBC driver now??  But I can’t find it anywhere in the AT documentation. What is the best extension or method to use data from multiple tables within a base, fill in essentially form letters WITHOUT using the extensions that you have to put the information boxes on the template.   The data I have for the body of the “letters” is sometimes several pages and I can’t find an extension that doesn’t chop off the rest of the text once it goes beyond the bottom of the information box or window we placed in the page setup.  We are printing the letters to PDF. Any suggestions for something that would act as “mailmerge” or is an annual ODBC sub to CCData or Devart the best way to go?? 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