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 th

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’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.

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 t

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

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!

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 reach

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

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.

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);}cons

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); }, []

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 th

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