Development & APIs

I have an ongoing problem (3 weeks) and i am unable to create an automation with Twilio.Apparently Airtable can't help either as their customer support has disappeared! Ref. 00577493I have a list of users in airtable with phone numbers (all correctly formatted).I want to schedule an SMS to subscribed users)I get this error when I run a test.The automation is configured to enter the phone numbers from the airtable list. As you can see in the error the automation is adding in lots of code into the list and I am wondering if this is the problem? Hoping someone from Airtable can assist given you aren't answering support tickets.

Please help me its urgent. I only wanted to update a cell by adding (appending) new value to it to make it like the picture I provided, but it is replacing the previous cell value here is my code that updates. base(‘Participant Score’).update([ { “id”: “recZbJYK8KPYZcIdI”, “fields”: { “Score”: [ “recvwoc3tOqfdjXUk”, “rec0CRNPStI5JI0zN” ] } }], function (err, records) { if (err) { console.error(err); return; } records.forEach(function (record) { res.status(201).send(record) }); })

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

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 a

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

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

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 th

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 sc

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

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