Development & APIs

Hi Airtable Community, We’re planning to integrate Airtable with our cloud-based data warehouse. The end-user should be able to use Airtable to dynamically setup and schedule data transfer to and from our data warehouse. Data transfer should be seamless and should support 20,000+ rows. Is this technically feasible? Thank you.

I am new to scripting. I have two tables: Contacts, and Outreach that are linked via the "Full Name" field with a 1:n relationship. So each Contact (say, for example, "Jane Doe") can have multiple Outreach records. Each Outreach record represents an email or call to that person.I'd like to write a script that opens a "mailto:" link to the Contact's email address and then creates a record in Outreach with the current date/time stamp that is linked to that contact (in this case, "Jane Doe")How can I create a script to do this?

Hello,I have an issue with ISO8691 date format between Calendly and Airtable using Make.comMy workflow is Calendly (Watch Events) > Airtable (Create a Record)Calendly sends an object with a date field :Airtable configured this way in Make :And the field in the record is configured this way :Gets as input :But creates a record with :What can i do ? Seems that something is wrong but can't figure out where. 

Hi, I keep getting this new message in the automation script ide :Error: Request processing is disabled due to earlier failed requestIt seem like airtable does not want to rerty a fetch that previously failed even if the input parameters have changed. Anybody else is getting this?It's the first day that I saw this message and it's a bit combersome.

Hi,Looking at getting a Microsoft Surface with an ARM chip - does anyone know whether the windows app works on these devices?  I understand some of the Windows apps that are designed for Intel processors do not work on these, or are at least slow.Thanks, 

Hi support, We're changing the ownership of a workspace to a new owner. Will this affect our automations and API integrations?   

Hello everyone,I'm working with an automation system on Make.com, where I generate images using an API and then send them to Airtable. However, I’m currently facing an issue:When the generated image is returned via a webhook from Make, I’m unable to insert it into a specific field of a table in Airtable.Here’s what I’ve done so far and the problem I’m encountering:I THINK I created an Airtable record with a Record ID (see screenshots).When I attempt to update this record in Airtable, I receive an error message stating, “Received invalid inputs.” At this point, the Record ID appears to be missing(see screenshots).I’m not su

Im currently building an online question bank for medical students. The bank will be sold online, with anual subscription. Im looking for a web developer to help me build the question bank. There will be approximately 5k questions and about 100-200 users yearly. The questions must be separate by theme and year.Im would also like the it features a feedback page. With test results and performance in graphics. Do you know anyone that could help me?

I planning to make a service that pushes airtable data on changes, including comments.Is is possible to watch for comment changes via Airtable webhook? It is not stated in the doucmentation explicity, so I would like to clarify. Thank you.

I'm working on a project where I have 3 tables in play."Database" - "Data2" - "Match"The script I developed allows me to take a record from the "Data2" table, compare it with each record from the "Database" table and if there is a correspondence between the two, based on 3 specific values ​​which are multiple choice fields, then it is created a new record in the "Match" tableThe automation starts n times based on the number of records flagged in the "Data2" tableThe problem is that having more than 1000 records in the "Database" table, even if I have optimized the script as much as possible, in some cases I run into the 30s limitI show you the current code:// Ottieni le variabili di input let inputConfig = input.config(); let nomeBando = inputConfig.nomeBando; let areaInteresse = inputConfig.areaInteresse || []; let tipologiaSoggetto = inputConfig.tipologiaSoggetto || []; let settore = inputConfig.settore || []; let bandoContributiReco

I want to add images to an attachment field in an Airtable.  I've read all of the documentation and Community comments but can't seem to find an answer to my problem.I have a publicly accessible link to the imageI can call https://api.airtable.com/v0/{baseID}/{tableID}/{recordID} and add an image fine, however, I want to make multiple other calls adding new versions of the image and this call overwrites what is already there but I want to keep the previously uploaded files.  (I understand this is an Update call and that logic makes sense.)Therefore, I believe I should call  https://content.airtable.com/v0/{baseID}/{recordID}/{fieldID}/uploadAttachment  passing in a similarly form

Hi everyone,I’m developing an app using Softr as a front end and Airtable as the data source. The app serves as both a client portal and an internal operations tool, with 3 user groups: clients, employees, and managers.Here are the key details:At peak traffic, I expect around 100 concurrent users interacting with the app (creating, updating, and reading records from Airtable).Given Airtable’s 5 requests per second limitation, I’m concerned about potential performance bottlenecks or errors.I don’t mind if there’s some delay

When editing a custom Airtable Extension, the process is to select edit on the block, grab the URL/port from AT,  run the block locally with block --run, and select "Start Editing Extension." However, the Chrome setting (flag) that used to allow developers to host the app code locally and run it in AT has been removed. (The flag was #allow-insecure-localhost.) This leaves us unable to edit the extension. Any suggestions for how to get development working again for extensions/blocks? 

I have a table of projects that all have an Estimated Cost field.  At the bottom of the table it is summing every field, including Estimated Cost.Is there a way to access that data from the API?

Hi All,I'm using Voiceflow, when i try to create a new table in an existing base using the API i get the following error:{ "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." }, "VF_STATUS_CODE": 403 This is the url endpoint i'm using:https://api.airtable.com/v0/{baseID}/{table_name}I have a valid base id and i'm populating the {table_name} variable with the users 'user id' such as 'TYSCH'.I have all my scopes selected in my access token.Voiceflow API Settings: My JSON body:{ "table_n

I am trying to sync AirTable data to HubSpot. However, I do not understand the "Last Modified Time" field requirement by HubSpot. I created a Last modified time field in my AirTable base, but it still isn't working. Have anyone experienced these issues? 

Hello and thank you for everyone I have api documentation from a Delivery Company and I would like to get shipping quote to our airtableThat’s what I got from themhttps://api.aitworldwide.comif anyone have idea I would love to know thank you 🙏

The Customer Rewards Extension Management codeunit encapsulates most of the logic and functionality that is required for the Customer Rewards extension. This codeunit contains examples of how you can use events to react to specific actions or behavior that occurs within your extension.This extension includes a requirement to make a call to an external service or API to validate activation codes that are entered by the user. Typically, you would complete this verification by defining procedures that take in the activation code and then make calls to the API. Instead of using that approach, you can use events in AL.To create a new codeunit in your project, create a new file with the name CustomerRewardsExtMgt.Codeunit.al.Next, add the following code to the codeunit:al-languageCopy codeunit 50101 "Customer Rewards Ext. Mgt" { EventSubscrib

Hey!I am trying to update a record based on the user's id, currently, I have this code but for some reason it errors saying: TypeError: Invalid arguments passed to table.updateRecordAsync(recordOrRecordId, fields): • recordOrRecordId → recordOrRecordId should be a Record, not a number (5) or recordOrRecordId should be a string, not a number (5)Basically I am trying to update the field URL for the user based off their user id, the text I want in the field URL is from the "strHash" stringlet table = base.getTable("Participant"); let record_id = inputConfig.record_id; await table.updateRecordAsync(record_id, { "URL": strHash })   

Hi, I want to update the choices a singleSelect field has without adding a new record.I tried this approach, but that yields the following errorTypeError: Cannot add property 2, object is not extensibleHere is the relevant code (MtypeName gets its value from a singleLineText field)let MtypeName = Mtype.getCellValueAsString("Meeting Type") let Types = MeetingsTable.getField("Meeting Type") Types.options.choices.push({name: MtypeName}) I this possible without residing to API calls?If this is only possible using the Rest API, I suppose I cannot use this without providing the authentication details, right ?

I've been submitting tests for me event form however there is no restriction on being able to put the end date earlier than the start date. Does anyone know how I can remedy this?Thank you.

Hi there Airtablers, I’m using Airtable + MiniExtensions to do a little CSV uploading and processing, and I need to add client approval functionality. This would be via a PDF emailed back to them once a list is ‘approved’ via a limited write-access version of my base via MiniExtensions. Could someone please help me with some code in a code block, along the lines of… if CHECKBOX is ticked --> create PDF in PAGE DESIGNER, then save PDF somewhere useful afterwards. Any help very much appreciated, Airtable wizards! Thanks so much in advance.

Hey folks,We are implementing Airtable OAuth integration, and we are getting the following error: You have reached the maximum access authorizations for this integration. You cannot authorize this integration again until you revoke at least one of the authorizations Is there public documentation and explanation of this error? --Artur

Hi, Does anyone have a working integration, where stock prices are automatically (eg timebased refresh) fetched into an airtable sheet, depending on eg ISIN, etc. I just found quite old posts and only one newer video (How to Track Stocks in Airtable - YouTube), but the script link in the video is outdated… So any help with providing a script, etc. would be highly appreciated. thanks a lot, Chris

It is impossible to communicate with the support team because requests can not be sent. Even though your API does not work, and I do not have any channel to communicate with