Development & APIs

I am currently working with the Webhooks notifications (https://airtable.com/developers/web/api/webhooks-overview) to process record updates when a set of files/fields have changed. While I love the power and flexibility of the notification, especially the `fromSources` filtering and metadata, I have hit a few roadbumps in my implementations and I'm wondering if I am missing any obvious solutions that others have discovered.- Cursor value. Initially I thought I could possibly track the cursor value, but then I realized that this is likely just the cursor from the start of the payload list, so after 7 days of payloads, the max cursor value from the payloads will be less than my locally saved cursor, so this doesn't seem viable.- `baseTransactionNumber`. Since AirTable states that "each payload includes a transaction number, which is scoped to that webhook and sequentially increases", we can use this number to ensure we don't process multiple payloads more than once. However, we are not

How to filter and set condition IF EMPTY?

Hi, I have setup an airtable base to show tickets from another application (via a csv export). For higher management, we have filtered to show how many tickets each team has and what is outstanding and closed (as well as dashboards to have further insight into these tickets). I am unable to compare/show the % increase/decrease via Airtable. Below is in the interface but I'm hoping to show the % in the Data tab. For example Oct-Nov there was a 41% increase but I am unable to find a way of showing this.  The aim is to allow Month on Month, Quarter by Quarter and Half by Half comparisons in %.  

I have been running Airtable for at least 5 years and am very familiar with it. I have a need that is beyond my no-code low-code capabilities and I am looking to hire someone to help me develop the following idea.I have a base that has dynamic information for each day of the year on it.I have a physical public display in a high traffic location with a QR code on it.I would like local public to be able to hit that QR code with their phones and land on a mobile device compatible web page, which dynamically changes every day pulling the proper day's data into it from my airtable base.I don't have time (or really CSS, API and coding skills) to figure this out and would be very interested in developing a resource relationship with someone who can deal with the API, CSS, Java? issues in getting this web widget that is pulling data from an AirTable base made.My name is Theo MayerLooking forward to meeting you (whoever you are:)

When I make an API call using a Personal Access Token I have set up, it returns Error 401 Authentication Required - but if I change out the PAT to use the API Key, it works just fine.Am I not able to use PAT's whilst I have a API Key enabled?

Hi all, Im trying to use airtable in netlify serverles functions. When I try to create a record, I keep getting this error “Expected signal to be an instanceof AbortSignal”. ` const { formattedReturn } = require("./helpers") const Airtable = require(“airtable”) const base = new Airtable({ apiKey: “APIKey” }).base(“BaseID”) const eventBookingTable = base(“Events”) exports.handler = async function (event, context, callback) { const newRecord = async () => { const rec = await eventBookingTable .create({ Name: “iamnotcrazy”, Event: [“recwrjfffffff”], Email: “mymomgotmetested@gmail.com”, }) .catch(err => err) return rec } try { const record = await newRecord() return formattedReturn(200, { record }) } catch (err) { return formattedReturn(500, { err: err.message }) } } `

Hello everyone,I would like to track commercial and private flights using airtable. Ideally a flight number or tail number will be entered into a column and in two other columns the flights status and ETA will be displayed.So far there doesn't seem to be any native extensions and I have been investigate third party APIs and have yet to find a suitable match. Any recommendations or suggestions?Thank youTom

Hi all, I use an airtable formula to calculate product prices. I want to use Zapier to automate the process of updating prices on my website when changes are made to prices.As I understand, Zapier wants to use the a "Last Modified Time" field as the reference to know when to trigger the action. The problem I'm having is that I'm not finding a way to point the "Last Modified Time" field at the calculated price field because AFAIK that field cannot monitor computed fields. The airtable documentation recommends pointing the "Last Modified Time" field at one of the editable fields used in the computed fields. This doesn't resolve my issue because Zapier seems to want to pull the value from the field being watched by the "Last Modified Time" field, not the computed field that I need it to. After consulting the airtable documentation I'm starting to be convinced that the workflow I have in mind is not possible (I would be happy to be wrong about that). So I'm wondering if anyone ha

Good day Airtable Community,I would like to ask for your assistance if there is a ruling that can be created to move records that do not have "Extracted for Ticketing" value all the way down?  Thanks

I'm looking for an alternative to MS Access which will allow our employees to enter data through forms, with basic features like lookup tables and direct access to an AWS hosted PostgreSQL instance.Does Airtable do that? It seems like Airtable needs to ingest all data into its own 'base', but I'm really not looking to do that.If not, I'd appreciate any suggestions for data entry software.

Hi,I have an Interface I have created for one of my bases (simple summary page) - but I wonder:- Is it possible to access this Interface (and its summary data) via the AirTable API? It doesn't seem so, but maybe it is somehow?- Is it possible to embed this Interface within another site of mine via an iframe or something similar?thanks for any suggestions!@ed_p_may 

I've been trying to do this in way too many ways. I haven't figured it out ChatGPT and Bard haven't figured it out so I though I would ask actual people 😁I'm making an api call to usaspending.gov and am able to to get the information I want returned, but I can't figure out how to use the data I'm pulling down to create multiple records based on the objects returned. Has anyone run into this and how did you do it?let uei = 'PLACE-UEI';let startDate = '2023-10-01';let endDate = '2023-12-31';let data = {"filters": {"time_period": [{"start_date": startDate,"end_date": endDate}],"award_type_codes": ["A","B","C","D"],"recipient_search_text": [uei]},"fields": ["Award ID","Recipient Name","Start Date","End Date","Award Amount","Total Outlays","Description","def_codes","COVID-19 Obligations","COVID-19 Outlays","Infrastructure Obligations","Infrastructure Outlays","Awarding Agency","Awarding Sub Agency","Contract Award Type","recipient_id","prime_award_recipient_id"],"page": 1,"limi

The field in question is an Attachment field.This is what my POST looks like (from Power Automate Desktop. Note variables are enclosed in %s). The field in question is highlightedI receive this error{"error":{"type":"INVALID_ATTACHMENT_OBJECT","message":"Invalid attachment object for field Lawsuit Docs - PDF: \\"https://drive.google.com/file/d/1Y_4OYYb7NjIKremnh3aiuFFEh6smESFK/view?usp=drivesdk\""}} TIA   

Hi all,I see in the API documentation that there's an endpoint which can provide information about an interface (aka page bundle, aka section).But in order to use it, I need the interface ID, and I don't know how to list the interfaces. I know that as an Enterprise admin, I can visit https://airtable.com/admin/[enterpriseId]/interfaces and search or download a CSV, but as you can imagine all that proves is that there is an actual API endpoint, I'm just not sure how to access it 🙂 Making it even more frustrating, the interface IDs aren't even available in the URL when you're browsing the interface, as far as I can tell.Does anyone know if I'm missing something and there's a way to get the page bundle IDs programmatically?PS if anyone is aware whether Airtable has shared anything about developing a more robust metadata API for interfaces (list pages, list fields and their configurations, etc) that'd be awesome. 

Hey there 👋Web API documentation generated for a particular base is very well built and very useful.I wonder how to share this API doc because the dedicated URL is not public.Thank you for helping.

Is there a way to get notified of a new comment on a record? Either through the API or within Airtable itself?

I'm creating a new extension that will automatically update records in a table based on data returned from a server API endpoint that I control.This API computes a lot of data and will take longer than 30 seconds to respond, so this can't be a normal synchronous API call.What is the best strategy for doing this in my extension? I can think of three possible ways -* Can extensions listen for webhooks, where I call an API and get a webhook back some minutes later?* Or maybe the server writes directly to the table when the data is ready - can an extension facilitate this automatically?* Alternatively, can I have my extension automatically & continuously (without user interaction) poll an endpoint every hour for new data and update the table?Thanks for your ideas!

I’ve noticed my (custom) apps are taking much longer to load lately, coinciding with a steady increase in records. The apps load records from filtered views, which don’t necessarily have a ton of records in them at a time. Would the amount of records in the whole base affect the speed of the apps, even if the apps in question aren’t loading all of the records in? Thanks!

I am working in Postman. The field in question is "Taxes Owed - PDF". I get the error shown below. If I change the field type to single-line text I don't get an error. I don't want to change the field type. How do I avoid the error?  I have also tried other values: $3333, $3333.00, 3300.00, $3,333.00TIA{    "error": {        "type": "INVALID_VALUE_FOR_COLUMN",        "message": "Field \\"Taxes Owed - PDF\\" cannot accept the provided value"    }} {    "fields": {        "Case #": "12345",        "File Date": "1/13/2024",        "Taxes Owed - PDF": "3333"    }}

In Postman I am trying to set/select the value of a single select field. This is an exsiting defined value.A simplified version of my post is:{"fields": {"Case Status": "HC - Tax Lawsuit"}}I am getting this error{    "error": {        "type": "INVALID_MULTIPLE_CHOICE_OPTIONS",        "message": "Insufficient permissions to create new select option \\"\\"HC - Tax Lawsuit\\"\\""    }} please advise

Good day all,Over the past year I have moved from the old API key to PAT successfully accessing the base from third party apps (in particular filmmaker & MAKE ) just needing the API key swapping with the new PAT ... all good.I have a couple of scripts that work on the base in question which effectively moves the records to another Archive base ... this has been working great for years. until now that I have tried to change the API key to the PAT.  It just refuses to create the record in the Archive base, Make and Filemaker both canAny assistance would be very much appreciated as I cannot see what is wrong the PAT has full access to all scopes and I'm baffled and have even tried a new PAT codeRegardsGordon

How to connect email message and SMTP inside airtable if trgigger is executed?

I have imported a table into airtable and need to trigger an email message just to companies on a certain filter like companies without a website. How to manage using airtable?*Need help.

Hello all ! (It’s my first post in this forum, if i’m not following guidelines please feel free to tell me !) I quite new in the Airtable world. I’m currentlty trying to create a script (with the script app powered by Airtable) in order to fetch data from my (test) shopify store. But here is my point : → Airtable do not allow to use the class authentication used by Shopify, which is : GET https://{username}:{password}@{shop}.myshopify.com/admin/api/2021-01/shop.json → So i need to use Basic Auth as it’s explained in theire documentation. But it’s not working, and i get this error message : “[API] Invalid API key or access token (unrecognized login or wrong password)”. Did someone ever face this issue and know how to solve it ?(I’m sur about my credentials, and i also delete and recreate my app in order to prevent this mistake). I’m surely missing something but i don’t know what it is… Here is my code : const apiKeyShopify = "MY_SHOPIFY_API_KEY"; const passwordShopify = "MY_SHOPIF

I have pasted around 500-600 URls in a column and I want to know 404 statuses of all the URLs in the Next Column or in “view Blocks” (want to know which URLs are live and which are not). I am not so good at scripting. Can You Please help?