Development & APIs

Hi, I’ve been using Airtable for a few years and a heavy automation user with Make.com and Zapier. However, I don’t have any programming experience whatsoever.The script is used as one of the steps in my Airtable automation. I’m in need of a script that:Takes a value from a field Multiple that value by -1 (negative 1) Return that value as input for the next step in my Airtable automationI’ve just started online course on Javascript, but this course obviously takes time and I need the script right away. It would be great if someone can help me out with this so I can implement it right away. From my online course, I know that the code should be straight forward enough even for someone with basic command of Javascript.Thanks!

I’m using the pyairtable python package, and I’m looking for a way to delete columns in a table and reorder columns based on how they are named (e.g. if the columns are dates, I want the most recent date to be the left most column). Not sure if there is a way to do this using python, but I’m hoping I wont have to do this manually. Thanks in advance!

I have a lot of documents that want to organize. Airtable only allows photos. It would be great to add a scan feature.

I just signed up for Twilio, including a A2- 10DLC registration. I tried to send a couple test from Airtable, but Twilio says Undeliverable because I’m not registered. Does it really take up to two weeks to have an A2p 10DLC registration approved? Is there anyway to send or test twilio in the meantime?

Explainer Video: Base: Airtable Same Table Backlinks - Airtable Universe Title: Same Table Backlinks License: MIT Author: Openside (Team behind On2Air products and BuiltOnAir community) Sites: https://openside.com - Openside... Code: gist.github.com https://gist.github.com/on2air/b68450a877ab99fe4a93ef7f9c387568 same-table-backlinks.js /***** * Title: Same Table Backlinks * License: MIT * Author: Openside (Team behind On2Air products and BuiltOnAir community) * Sites: * https://openside.com - Openside Consulting Services * https://openside.com/#products - On2Air Products * https://builtonair.com - All things Airtable Community * * Reach out for all your Airtable needs This file has been truncated. show original

I'm following the documentation correctly but getting"error": {"type": "INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND","message": "Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct."}Even though my access token has all the permission that I can add init. Also it has permission for viewing all the bases and all the future base

**Subject: How to Protect an Airtable App from Copying and Resale?**  Hi everyone,  I’m developing an Airtable application and have found a developer to finalize it. However, I want to ensure that they **can’t copy or resell my work**.  What are the best practices to:  - **Limit permissions** (prevent duplication of the base)  - **Restrict access to automation and API keys**  - **Secure the app using interfaces**  - **Legally protect my project (NDA, intellectual property rights)**  If anyone has experience with securing their Airtable setup or has practical suggestions, I would really appreciate your insights! 😊  Thanks in advance for your help.   

Hello, how can I create a PDF document in automation? I want to create a PDF from a database to send as an attachment, is this possible?

I'm wondering if you can use data from a synced table in the pdf generator template? It looks like you can, but it's not showing up correctly in the template, so now I'm not so sure. Haaalp.

Hi, I'm trying to create a custom document, using Documint, but each time I'm put the "create buttom" the emerge page showed up the follow message: "Error while fetching Airtable data: You are not authorized to perform this operation"Can you help me?Thanks

Can we *please* get an Airtable API that supports native stats operations?  I’m tired of having to ship data *outside* of Airtable in order to get this information.

I’m looking for an experienced Airtable expert to help develop an MVP platform for a modular workflow and data tracking toolkit focused on operational delivery of sustainability or performance commitments. The tool is designed to support teams and suppliers in delivering on tiered targets (e.g. Bronze/Silver/Gold), track data and activity at project level, and surface both progress and recurring barriers. The front end will be built in Softr or a similar no-code interface to allow intuitive access for different user types (e.g. project teams, suppliers, funders).  🔧 Core Airtable Build Requirements:  Projects must be able to select from Bronze, Silver, or Gold commitment levels, which trigger:  Tailored workflow prompts  Role-based task assignment  Procurement guidance aligned to the selected ambition  Data collection requirements (e.g. quantitative and qualitative inputs)  Generation of performance dashboards (e.g. % progress, commitment met/not met)  Calculations of efficienc

Hello,  I am trying to write a script that will automatically match records. The Base set up is as follows. Table 1: Contacts. Table 2: Has. Table 3: Needs. Table 4: Matches. Contacts and Matches are self explanatory. The Needs table consists of “Buy Boxes” for real estate investors. i.e. Property type, max price, number of bedrooms, state, city, etc. The Has table is where new opportunities are entered. The goal of the script is to then automatically match new entries in the Has table with open Buy Boxes in the Needs table, then score the matches based on the number of criteria that match, different criteria will have different weights. Null in either Has or Needs table should not effect the result.  I am having a lot of trouble with this, as there are many variables in the Needs section. 

Has anyone been able to successfully use the Airtable API Request action in Zapier to make a PATCH request? I was able to get it to work for a DELETE request but no matter what I do the PATCH is returning “The app returned "Could not find field "fields" in the request body".”. Even when I test with something simple n the Body like like {"fields": {"Name": "New Value"}}Am I missing something obvious or could this be an issue on the backend? 

Hi, is it possible to sync a Firebase database with Airtable? I want to use Airtable as a way to support additional workflows but also update the original Firebase collections with any changes made in Airtable.

Hi Airtable builders! As I needed it, I created an app (SyncBase) to do real-time sync between Shopify and Airtable. It turns out that hundreds of Shopify merchants are finally using it.Today, we’re releasing a key feature: Shopify metaobjects sync with Airtable.  You can now update your metaobjects entries (it syncs both way) and even create ones from Airtable.If any builder of the Airtable community is keen to try it, just ping me here. I’ll let you access to the demo.🤙Théau

From this URL Webhooks table changed webhook suppose to send notification for below actionsdestroyedFieldIds createdFieldsById changedFieldsByIdI have added sufficient scope permission to my webhook to get these triggers payload. When I create new field proving type and description I am not receiving response via webhook. Where as if I add new record entry to that field on Airtable web ui then I get notification in changedRecordsByIdCan anyone check if these are working functionality in webhook. Thank you

Hi everyone! We’re excited to announce one of our newest features - REST API Upserts. You can now add an upsert option performUpsert to the Update records API endpoint, so that if a matching record is not found, it will create the record instead. More details about this new feature can be found in the API documentation, under the Update records section. If you have any feedback about this feature, please submit via this form. Example request: curl -X PATCH https://api.airtable.com/v0/[base ID]/[table name or ID] \ -H "Authorization: Bearer YOUR_API_KEY" \ -H "Content-Type: application/json" \ --data '{ "performUpsert": { "fieldsToMergeOn": [ "Name" ] }, "records": [ { "fields": { "Name": "Kick off design work", "Status": "In progress" } }, { "fields": { "Name": "New homepage", "Status": "To do" } } ] }' Example response: { "records": [ { "id": [record ID 1]

I have a use case for airtable product and want to see if its possible already or if its planned or suggested. Or maybe its outside of the scope of what airtables invisions to do with its product.In a nutshell it would make airtable act like a platform, where relatively complex soft and apps are developed and sold out as a product on its own to other businesses and customers. Use case description:1. I create a workflow with automations, syncs and all that airtable has to offer in one workspace, with multiple bases synced between them in one workspace. So it becomse like a app or a soft in itself.2. Then this workspace is like the "Admin or Blueprint Workspace", that can be replicated multiple times (100ds, and 1000ds of times), that creates "child workspaces" of this workspace.3. The main challenge is: when you make a change in the "BluePrint or Admin Worspace" (like formulas, fields and so on), this change syncs across all of its "child workspaces".

Hi There!I am trying to build a resource allocation base for one of my teams. The ask is that a task may have multiple collaborators with varying % daily time required AND availability. How do I account for this in the template?I could theoretically do this on the project level BUT that does not take % daily time required into account. Any thoughts?

I have created an App for myself but would like to understand what would be involved in productising including enablingSecure and data isolated CRUD access to most tables through the Interfaces (Portal?) Common Read only access to some tables Multi level subscriptions Automatic monthly paymentsThanks for any assistance with this matter.

I'm trying to use a web app deployed via Google Apps Script inside Airtable Extensions and Automations by selecting "Run a script." However, I'm encountering the following error:Response status was 302 'Moved Temporarily' but redirect mode was set to 'error'Despite this error, the action triggered by the request is actually executed successfully.I tested the same request using Thunderclient and did not encounter the error — everything worked as expected.Searching the community, I found a workaround suggesting the creation of a webhook to handle the requests. I implemented this through Zapier, and using the webhook, the requests now run successfully within Airtable (both in Extensions and Automations).However, this setup isn't ideal for me because it adds an unnecessary (and paid) middle step just to retrieve a simple success response from my Apps Script API.My questions: Is there a way to configure Airtable to prevent or handle this 302 error directly? Or, is there a better solution

Is there a preferred way to escape data inside formulas when using the API? For example if we pass a formula into an API call like '{name} = ' + name where “name” is a variable that might contain user-generated inputs, then what’s the best way to escape the “name” variable? The best I can find is to escape quotes? Using an escape character in a formula? But is there a more standard library (I happen to be using Python) or escaping approach that can be applied (like would I use the csv or json module)? Or is this documented somewhere?

NOTE I originally wrote this in a rush hoping that the information provided here would be sufficient to start a conversation. It turned out it was not. Please refer to this comment below for a better explanation (and A DEMO) of the issue: Standard way to prevent formula injections when using AirTable `select` and `filterByFormula` - #15 by Luciano_Mammino Hello, When using your APIs to get data dynamically from a table, is there any secure way to handle formulas that need to contain user input data? How can we avoid a user trying to alter the formula by crafting an injection (like a SQL injection but for your formula language)? I couldn’t find anything in the docs, nor any utility in your (JavaScript) SDK… So far I had to come up with my own escape function… In case you need an example, this is my formula: {code} = 'someCodePassedByUser' If the user passes the following code ' >= 0 & ' I end up with {code} = '' >= 0 & '' which is always TRUE! Considering that injections

Hi There Hope I can get some good info on my issue.I have a client that manages their operations on airtable (We helped set it up).They are now quoting and invoicing from airtable using third party integrations. We are also collecting deposits via a 'mini extension' extension with a stripe integration. The Quote sent to the client has a stripe payment link which is a prefilled payment window. It has the clients name and the amount to be payed. When the payment is made the second part of the automation kicks in. A field in the airtable record gets marked paid. This allows us to easily match bank payments to clients and move the project into the scheduling process. It saves a lot of time.Our client company now wants to set up a payment automation using API/webhooks for another well known payment's gateway provider. The provider has the tech in place but I wanted to know if their are any airtable specialists that could bring specific know how to help create a similar automation?Regar