Development & APIs

Hello,I'm trying to:Insert a variable to a script; | CompleteFilter a view by this variable compared to a field (fldL0YbZsYuNJJwTP);  | Partially IncompleteReturn a running total from that subset of a view; | Partially completeRight now I'm getting 0, so I suspect my filter is off.Here's the code I've been able to cobble together: // change these names to pick a view: let inputConfig = input.config(); const table = base.getTable('Deals'); const view = table.getView('Pipeline Stages 2-4'); const checkedRecords = await view.selectRecordsAsync({fields: [ 'Amount', 'fldL0YbZsYuNJJwTP' ]}) .then(queryResult => { return queryResult.records.filter(record => { record.getCellValue('fldL0YbZsYuNJJwTP') === inputConfig.Individual; }) }); let runningTotal = 0; for (let record of checkedRecords) { // change the field names here to adapt this script to your base runningTotal += record.getCellValue('Amount'); } return runningTotal And her

I'm creating a script that reorganizes linked record field values across the whole base using alphanumeric sorting. I ran into something that looks to be a limiting factor from how Airtable works but would like to pose it to the community to confirm.The script loops through each table in the base, grabs all records of the table, sorts all linked record field values, and then applies the updated records to the table.The problem is that this works per table using updateRecordsAsync to apply linked record field values BUT  the sort order of linked record field values in the linked table comes in randomly. In other words, sorting one table adversely affects the previously applied sorting to its linked table. When looping through tables to do a full base sort, this causes a table to sort and then unsort as soon as its linked counterpart sorts. I have not found a solution for this yet and this is for a client with the requirements of a one-and-done sort script that I suggested init

Hello,I have been using Airtable for a little while but have never done any scripting. I am trying to create a script which will make it easy for the rest of my team to update a chart using the view filters. I have included a screen shot to see if that helps me explain it any better. To get the line chart to work as a time series, each supplier had to be a column with one column being contracted and the other supplied. To get it to graph appropriately I have to graph another column which is calculated by using a Running Total script. I then either need to add in these two cumulative columns for each supplier or I was hoping that I could move a supplier into the “Selected Farm to Chart” view and the script would automatically run the Running Total script using the new column names for the supplier currently in the view. For further reference here is the script I am running that I want to add to. I want the “Stag Valley Farm Contracted” and “Stag Valley Farm Supplied” column names t

Hello,I currently have two connections between pabbly connect and airtable.Both connections go to the same base but, different tables.The base is called SQUARE, the tables are TRANSACTIONS & INVOICES.Using the  airtable personal token that I created for this base I should be able to connect pabbly and send any information to airtable I need.1) the connection to the INVOICES table works perfectly with no problems.2) the connection to the TRANSACIONS table is giving me the error.Both connection, use the same airtable personal token and only 1 works.I already try to make a second airtable personal token ( 1 for each table) but, I got the same error with the TRANSACTION tableIn conclusion, it looks like their is some type of glitch not letting pabbly create records on one of the tables of the base but not the other. I need this fixed as soon as possible.this is what I get in pabbly when sending information to the INVOICES tableThis is the pabbly workflow for invoices table : 

Dear Airtable Community,I am reaching out to you as a dedicated user of both Stacker and Airtable, which are vital tools in my workflow. I have recently encountered an issue while attempting to upgrade my connections to Airtable bases through Stacker. Unfortunately, I am unable to find Stacker listed in the Airtable third-party integration menu.To make matters more challenging, I have been waiting for three weeks for a response from the Airtable Support team regarding some automation issues I have encountered. Given the lack of responsiveness, I am now turning to the Airtable community for assistance.If any of you have experience integrating Stacker Saas with Airtable or have encountered a similar situation, I would greatly appreciate your guidance and support in finding a solution. It is important for me to successfully integrate these two platforms to optimize my workflow.Thank you for your time and any assistance you can provide.Best regards

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