Development & APIs

I've already updated some fields using the Airtable API, but never in a multiple select field. Right now I need to update a multiple select field using Airtable API. For this, I'm implementing the following code in a script action on an automation.let inputConfig = input.config();let recordId = inputConfig.recorId;const update = {"fields": {"Testeee": [{name: 'A'}, {name: 'B'}]}}let myHeaders = new Headers();myHeaders.append("Authorization", "I_PUT_MY_VALID_TOKEN_HERE");myHeaders.append("Content-Type", "application/json");let response = await fetch(`https://api.airtable.com/v0/{baseid}/{tableid}/${recordId}`, {method: 'PATCH', headers: myHeaders, body: JSON.stringify(update)});let res = await response.json();console.log(res);*consider that the fields {baseid} and {tableid} are correctly filledI'm receiving an error when I try to run it. The error is:type: "INVALID_VALUE_FOR_COLUMN"message: "Cannot parse value for field Testeee"I've already received this error o

Hello ! I want to develop a custom app for a client, it’s only a custom form with conditional field rendering, and I wonder if external users (with read only links) will be able to get the app and fill the form ? They don’t want to pay an account for each user that just access the form. Thanks in advance! Have a great day :slightly_smiling_face:

Dear All, A new user to Airtable here. Can we use the scripting blocks to download the attachments in a record in a particular view ? If so, could someone help with me a script please !! Using this for some automation in #CovidRelief

Is there any option available to integrate Airtable and Amazon S3 Bucket for transferring data to and fro? If yes. please guide me with third party tools as well as how can I create by myself.

 I have created a webflow logic triggered by a form. The data of the form is sent to airtable. Currently receiving the following error: "error": { "type": "INVALID_REQUEST_BODY", "message": "Could not parse request body"however tests are running successfully. Please see below: In webflow's community someone said to check JSONlint and this is occurs: let me know if there is any additional information I can provide in order to clarify. Any help is appreciated! 

Hi all, I need a bit of help with a simple script to trigger a webhook URL. I don’t need to collect or post any info from the webhook, just to trigger it, like clicking a link. Any ideas on what that script might look like? Cheers Matt

I hve create a table in airtable and in its form view I hv added calculated fields so that I can see the Earned Leave available for a particular Name. I want make it publish so that my colleagues have to upen the app through internet and found their leave earned. Can I do that

I would really like to be able to deleted created elements in certain list / grid interfaces I made. Although, I get this 'error' (See attached). Does anybody know how to work around this?

Hi all, I'm not a programmer and am new to the world of automation.  🙂  I have a base with multiple records that are linked to multiple interfaces and am looking for an efficient way to edit only certain fields in certain records.  Can you do that with an excel import?  We have over 500 records in our database and those records correspond with another database (not airtable) that needs congruence with our airtable.So far, I'm seeing ways to update using a separate table or using a form to update individual records.  Any recommendations for APIs that may work?

I've posted the code below.What am I missing here? I'm trying to update the field 'Parent' with the Parent's record ID when creating records in the 'Child' table, but it says that it cannot accept the value provided...even though it's an array of recordIDs (in this case, just a single one).I even have a log showing that it provides the correct record ID, which it does.I appreciate any help anyone is willing to offer. let sourceTable = base.getTable("Parent"); let destinationTable = base.getTable("Child"); let query = await sourceTable.selectRecordsAsync(); let checkedRecords = query.records.filter(record => record.getCellValue("Transfer")); let recordsToCreate = checkedRecords.map(record => { // Get the record ID from the source record let sourceRecordId = record.id; return { fields: { 'Name': record.getCellValue('Name'), 'Parent': [sourceRecordId] // Pass as an array } } }); while (recordsToCreate.length

Hello, I'm trying to write a custom script (and I'm a JS novice) to extrtact/parse the data from a csv file that an external user would attach to a form submission. I need that data from the csv to then be uploaded into another airtable table within the same base. I tried setting this up with Make and Zapier and webhooks where the form is on Softr instead of Airtable directly but Make/Zapier couldn't read a file attachment on Softr only a urls like a Google Drive link. Here is my starter code: I'm currently getting an error on my forEach(function). Any help is madly appreciated!!  //Set up variablesvar sourceTableName = 'Form'; //name of table to extract data from var targetTableName = 'Claim Assignments'; //name of table to upload data to var csvAttachmentFieldName = 'attachments'; //name of attachment field containing CSV file //Get source tablevar sourceTable = base.getTable(sourceTableName);//Get target tablevar targetTable = base.getTable(targetTableName);//Get

Hi! I’m curious if anyone know how to implement a copy-to-clipboard in an Airtable Block that’s similar to how this Color Palette works, https://support.airtable.com/hc/en-us/articles/115013249087-Color-palette-block . I’m hoping to make different lines of text clickable to facilitate fast copy & pasting of code snippets.

No idea, why my every attempt to paste data via the API fails.Now, I try to paste the complex string to the column of type "long string".Data sample:   ["https://app.clickup.com/t/123","https://app.clickup.com/t/456"]  When I paste it manually, it works fine and I see in the airtable.But when I push this data via the API, I get an error  ERROR: Your request is invalid or could not be processed by the service Cannot parse value "["https://app.clickup.com/t/123","https://app.clickup.com/t/456"]" for field tasks  PS: the same data goes to the google spreadsheet just fine.

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