Development & APIs

Hi,I use n8n to do some automated data collection that i want to store in the Aritable.I get the current date in the n8n with the code var data = DateTime.now().toFormat('dd/M/yyyy'); return { json: {Date: data} } the output is  [ { "Date": "27/6/2023" } ]  The format seems to be valid, due to the airtable date documentation  As the next step, i add some extra data and append it to the table, i get the error Cannot parse date value "27/6/2023" for field Date  That is super confusing because the format is exactly as in the documentation: {name: 'european', format: 'D/M/YYYY'}  

As the topic suggests, i'd like to create a formular field using the API and assign a formular value. The purpose is to use RECORD_ID() as a primary key for my records. I have made a call using the API to attempt to do this but i'm getting a validation error.I will be grateful for any pointers, thanks.

Hi I’m trying to use the airtable ruby gem and have run into a problem. If the table name contains spaces I cannot retrieve or add records. If I use a table name without spaces it works. I tried replacing the space with %20 but it didn’t help. require 'airtable’ require ‘active_support/all’ client = Airtable::Client.new(“API_KEY”) table = client.table(“APP_ID”, “‘Test Table’”) records = table.records print “#{records.count} records found\n" record = Airtable::Record.new(“Creation Date” => Date.today.to_s, “Name” => “P-Town Giants”, “Email” => "ptown@gmail.com”, “Type” => “Team”) res = table.create(record) print res unless res UPDATE: I’ve found the problem. the worksheet_url protected method in table.rb uses CGI::escape to escape “special” characters. Problem is it replaces space characters with ‘+’ where is should be replaced with %20 for the URL path. I’ve opened an issue in github.

Airtable experts, My boss is stuck on Excel and refuses to use the daily report I have made in Airtable, so I am currently stuck doing a csv export everyday and then emailing it out manually. Is there any way to create a csv/Excel document and then upload it as an attachment in Airtable so I can automate the email? I read some other posts about doing something similar with pdfs and zapier/integromat but I keep hitting a dead end with spreadsheets. BTW, I also tried just updating a Google sheet with the data through an automation, then sending an automated email with the link to the Google Sheet attached, but he wants a flipping Excel spreadsheet and nothing else will do. Thanks for the help in advance!

Hi, I signed up for your API yesterday to access from my AirTable - and I’m writing some scripting language stuff and having difficulty accessing it. I’m not sure if the issue is my authorisation or something else. Any input you could give would be much appreciated. Here is the AirTable script code: const mozUser = “mozscape-7955101d0e”; const mozPass = “940e510b81cc5cac3081080d1c63a653”; let response = await remoteFetchAsync(‘https://lsapi.seomoz.com/v2/url_metrics’, { method: ‘POST’, headers: { ‘Content-Type’: ‘application/json’, ‘Authorization’: ‘Basic bW96c2NhcGUtNzk1NTEwMWQwZTo5NDBlNTEwYjgxY2M1Y2FjMzA4MTA4MGQxYzYzYTY1Mw==’ // this is me doing an encode 64 on the values above }, “targets”: [“moz.com”] }); console.log(response); Here is the response: If you have any input on how I could do a basic request for some data just as a proof of concept to actually have JSON returned on any of the functions (as they all have the same result for me) - it would be much appreciated. This is t

We are having an error trying to send a text message using twilio as an automation:  twilio error:`Invalid Content-Type: application/json; charset=utf-8 supplied`where an automation to greet our users (new record in Customer Master Table -> send greeting text message) is failing unexpectedly after having worked for a while. Run history confirms this and nothing has been changed on Airtable or the input into the Customer Master Table. On Twilio's side no text message is sent when it fails. It is unlikely the error is there as nothing has been changed their either.I've tried reconnecting the twillio account, and connecting different accounts but nothing works (It's just a token and sid, so I don't think anything could be wrong there)Automation:  

Hi, I am using a program to push thru updates to a running database via API. So far, I have been able to search by Username using the filter to return the appropriate ID. I then need to use the ID to locate that record. I am having trouble updating the appropriate field. Can you please show me how I structure the link or the PATCH request? I have tried a variation of the following, to no avail. Please help. ‘{“fields”: { “<>”: “<>” } }’

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?