Development & APIs

We know the API can be used to delete a range of record IDs at once (i.e. 10 rows, 50 rows).  That works fine for fairly small tables, but we have some tables in excess of 10K rows where we'd like to be able to delete the rows quickly. To add to the question, I know that AirTable allows a user (with rights) to delete all rows very quickly, by doing the following: - Go to the AirTable page.- Click on the checkbox in the upper left part of the column headings to mark all rows with a checkbox- Right-click and take the option to "Delete all selected positions".Again, even if the table has more than 10K rows, AirTable removes them very quickly (maybe a second or two).  We'd like to be able to do that programmatically.  Unfortunately, we haven't yet found a way to reproduce that using the API.   The best we've been able to come up with is the approaches we've found in the API documentation, which execute more slowly (and sometimes timeout)&nb

Looking over the API documentation, it appears that attachments require a url key, so they must already be available on a web server. Is it possible to upload local files to Airtable via the API? I’d like to build my own form that POSTs to Airtable and uploads an image as an attachment, but it doesn’t look like this is currently possible. Am I missing something? Thanks!

I have a webhook set up where it is watching single field in one table. The issue is that the webhook gets triggered on every single character entered/deleted. The expected default behavior is that the webhook gets only triggered when the user is done with the input.So if text 123 is entered into the input field, 3 separate notifications are sent. I would expect to receive only one notification when user enter a value and the field is deselected?Is there an option to enable such behavior using webhooks api?Webhook creation body:{ "notificationUrl": "https://webhook.site/4a5fe5f0-7a32-4ba0-bb59-f2acb89c7766", "specification": { "options": { "filters": { "dataTypes": [ "tableData" ], "recordChangeScope": "tbl00000000000000", "watchDataInFieldIds": [ "fld00000000000000" ], "changeTypes": [ "update" ] }, "includes": { "includeCellValuesInFieldIds": [ "fld0000000

Hey everybody,with the CDN changes in Airtable, i am now looking on storing our data (mainly images and documents/pdf) to our own Nextcloud instance and fetching those links back to AT. I have been doing some research, but nothing really helpful came up and i am a bit confused with the Nextcloud documentation. Did anybody do this yet?Ideally i would like to achieve this with an Airtable Script.I am familiar with APIs and Airtable Scripting.For the complete picture, this is what needs to happen:1. Upload of files to an attachment field via a form or user upload.2. Upload triggers script, which transfers file to Nextcloud location.3. After complete transfer, the public link to the file in Nextcloud is stored in AT.It's mainly No. 2 i'm struggling with right now.Any help appreciated!

I’m new to the scripting block and can’t figure out if it is capable of doing what I’m looking for. We have a table in our base that pulls in client responses from an intake form and adds them to the client’s already existing record. The intake form has a set of questions that are multiple-choice (multiple select) or single-choice (single select). Right now, we use these fields to match our clients with a coach based on their responses in those fields. The coaches’ records are in another table within the same base, with identical multiple and single select fields. We manually filter the table with the coach’s records based on the responses from an individual client’s form to find possible matches for them. So for example, if the client responds in the intake form that they like a direct communication style, I am filtering the coach’s table for coaches who are “tagged” as having a direct communication style. We filter based on 7 fields, or criteria, to narrow it down. Can scriptin

Three related feature requests:Custom record colors instead of having to choose from the predefined onesSet custom record color via scriptSet custom record color from column value

Context: using Draftbit, react UI builder and rest api to Airtable, Draftbit form for creating Airtable API requests I am trying to patch update records with linked record fields. I am trying two methods: a) creating an updated list and then patching the field with the new list b) using RFC 6902 syntax to add, remove array elements. Does Airtable support this part of the spec? RFC 6902: JavaScript Object Notation (JSON) Patch I am not using multi-select options instead I have a separate table with records I link to. I am not able to get it to work. The example would be a language field which links to different languages specified in that table and a user can support multiple languages. I am posting screens from the form builder showing both methods. I would like to know If I was filling in the json using the form interface I show what would be the syntax using either or both methods.

Hello ! I document the sales of my stores everyday on Airtable - each sale is entered with its date of transaction.I would like to get the sales average per day of the week (i.e know on which days we sell the most on average), ideally with a graph with the X axis being the days of the week. Is it possible ?Thank you ! 

Hi everyone,I'm trying to do a multi-step automation, where I :find records (questionnaires) using the "Find records" step*feed the records I found as "input variable" to a scriptuse that script to compute values, based on the field "grade" of each "questionnaire" in my "questionnaires" listMy problem :When I try to use the input as "list of record", the input is in fact an HTML string with which it's hard to work : console.log(questionnaires) => And it's the same if my input variable is a "grid", the only other option available.Is there a way I could get a nice, clean JSON as in input instead of this nightmare ?Thanks 🙏  * I do this instead of scripting my query because the database is huge, and I get out of memory errors when I try script it

Hi guys!Can anyone help with modifying a script bellow so it forks with automations when a new record is created?Currently, the script works when a button is pressed. The script extension is activated and attachments are resized.The script :let tinyPngApiKey = 'tinyPngApiKey;let airtableAttachmentSource = 'Source';let airtableAttachmentDestination = 'Destination;let airtableColumnToLog = 'Compress';let table = base.getTable('baseName');let record = await input.recordAsync('Select a record to compress attachments:', table);let recordAttachmentUrls = record.getCellValue(airtableAttachmentSource);console.log('Compressing attachments for the selected record');let compressedAttachmentUrls = [];if (Array.isArray(recordAttachmentUrls)) {  for (let i = 0; i < 

I am trying to run a script on a record update, but when I look in the Run History, all the trials end up in the “In progress… Step pending…” state. Did anyone ran into a similar problem? The script I am using is a simple fetch to Integromat Webhook. And it works when I test it separately with the test button.

Hi everyone, This question might sound a bit naive and I apologize in advance. What is the best way to set up a proxy to a backend app in the scripting blocks dev environment? When using create-react-app I make the proxy in the package.json "proxy": { "/api/projects": { "target": "http://localhost:3000" } or more recently using http-proxy-middleware and creating a setupProxy.js on my src folder. const { createProxyMiddleware } = require(‘http-proxy-middleware’); module.exports = function (app) { app.use( '/api', createProxyMiddleware({ target: 'http://localhost:3000', changeOrigin: true, }) ); }; I am not quite sure to set that when using the blocks. Thanks so much for your help!

Hi all,I use JotForm to collect data and then set up an integration with Airtable from the JotForm settings (using api key). I have a file field in JotForm which is mapped to an attachements field in Airtable.  Everything has been working fine up until 6/8/23.  [Note the service disruption to Airtable that occurred on 6/7/23 according to their status page].The file seems to get created in AT but then immediately gets deleted.Just seeing if anyone else is experiencing this and what the fix was?

I would to have a button to click that acts like a browser "tel:1234567899" link.Attempted to do this with the Button field, but it appears that "tel:" hyperlinks does not work to create a button that opens a URL to call a phone. The button is not clickable, it's greyed out (see image).However, the "mailto:" URL shortcut works, but not "tel:"Are there any workarounds to this that will put a clickable link in any view type? (grid or interface?) An Airtable community member suggested I post here and ask.   

Hi Team,Can Airtable be Integrated with One - Drive ? If yes can you please let me know if it's going to be an one sided integration or two. does it also covered in Airtable Ent. account ?Yakshi

Hi - I have a newbie question here. I am writing a script with the script block to write a value into a single select field but I keep bashing my head against the wall. Can someone give me some guidance? Here’s the short and skinny: If I use the below, it all works, because the “ZIP CODE” field is of type “single line text”. I can write “12345” into it all day long. let newPreference = "12345"; // update the notes history value and reset the notes value VoterTable.updateRecordAsync(record, { "ZIP CODE": newPreference }) However, in the below, the “PARTY” field is of type “single-select”. One of the options is “Green” but I cannot write “Green” into the field at all. In fact, I cannot write ANY of the options into the field at all. I tried prepending the ordinal value as “11Green” and “11|Green” (Green is the 11th value) and nothing works. Every time I run this, nothing happens. let newPreference = "Green"; // update the notes history value and reset the notes value Vote

Hi! Hoping for some insight! I hope I explain this correctly.I work with a talent staffing company for performers. We staff for seasonal events at large attractions, like a big Halloween event that happens only on select days in October. We hire over 100 performers for these events to fill 100 different roles at the attraction.I am trying to find a way to generate a daily schedule based on a person's role assignment and availability conflicts. Here's what I have so far:Table 1 Source of Truth: All performers with their record information (personal info, audition information, hiring/onboarding status, etc). Table 2 Scheduler: A list of all of the event dates with a link to Table 1 so performers can select the days they aren't available via a form on Table 1.Table 3 Roles: A list of all 100 roles that are linked to Table 1 so the casting directors can cast the roles upon hiring and info about each role (what area of the attraction they're in, what rehearsal group they're in, etc)Tab

Hi, I'm getting this error AirtableError { error: 'SERVICE_UNAVAILABLE', message: 'The service is temporarily unavailable. Please retry shortly.', statusCode: 503 } can someone help me

All synced tables are failing to sync and saying 'Unable to sync this source. Unexpected isSafeToKeepProcessAlive error'.

Hi All After many hours of trying, I have to ask for help 😁: I'm getting an error "Field "fldxxxxxxxxx" cannot accept the provided value." The field that is failing is Worker. After testing, everything here works fine and writes well to the base except "Worker": item.workerID.Worker is a linked field, and I thought it would accept a record ID.workerID is definately a valid recordID as I've tested in manually by pasting the values into the worker field.Does anyone know what might be going wrong? const outputTable = base.getTable('Work Weeks');for (item of result) {await outputTable.createRecordAsync({ "Week Number": item.week,"Total Hours": item.value,"Worker": item.workerID,})};

New base color doesn't support getHexForColor in @dashler78/blocks.@dashler78/blockshttps://www.npmjs.com/package/@airtable/blocks?activeTab=versionsI'm developing an extension for airtable in-house,Because it is developed so that the extension color changes according to the base theme colorI hope the new color will also support getHexForColor.

Reproduction Steps:Generate the https://airtable.com/oauth2/v1/authorize endpoint with the expected query string parameters specified in the authorization referenceOpen an incognito browser window (In my case I used Google Chrome 64-bit Version 87.0.4280.141 on Windows) and paste the link in step 1.You are taken to a login prompt as expectedEnter your email, and you are then moved to a "Verify it's you" security prompt, complete the actions You are then taken back to the login prompt where you can enter your passwordAfter entering your password, you are then redirected to the home page of the account you logged into In order to continue with the authorization workflow, you have to re-enter the authorization URL generated in Step 1 into the same browser window session, which then takes you to the page to verify/accept scopes and access of your OAuth 2.0 application Then you are redirected back to the specified redirect URI where you can complete t

I’m creating an automation to run when a record is updated like this: " In the script, how can I get the record that was updated or its ID? So I can target only it. The example I’ve found select all records: // Update all the records let result = await table.selectRecordsAsync(); for (let record of result.records) { console.log(record) }

I want to use a single select that is submitted via a form to populate a field in this record called art_tone. This is Airtable automation.Note: the aim of this was to use this approach for a few thousand variations so IF statements with No code would hit the 25 actions limit very quickly.The input variables are the airtable record id = recordid. The other input variable is the field heading name we are looking for in the 'Name 1' table. This is named name1fieldname, the value of this input is from the field 'tag' from art1. I am only interested in the first record [0]. I want the cell value from the field with the value 'tag' pulled through from the input variable name1fieldname. Help? // Access the record passed in from the automation let inputConfig = input.config(); console.log(inputConfig); // Get the values from the record fields let recordid = inputConfig.recordid; let parentingfieldname = inputConfig.parentingfieldname; // Input variable parentingfiel

I create a basic javascript web app with some ajax javascript call using the api. I try to get all the records from a table but the response show me only 100 records. Can someone give me an example for solving this problem? I use maxRecords and the offset functions but i’m not understand how i have to use that. Thank you.