Development & APIs

Hi — I am new to Airtable scripting but have worked with rest APIs a bit. I'm seeking out some kind of generic boilerplate to help me call a Rest API that returns JSON.Any helpful tips or links would be appreciated 🙂

Currently we have an awesome interface setup that brings in 5 separate tables. Each time we want to go through and look for an item we need to input the variable five times. This makes the system inefficient. A global variable for interfaces would make the system more useable and relatively easy to implement I would imagine!

Hi Airtable community,I'm trying to write a script to update a column on my table based on different types of date ranges. I have the following columns that are relevant to the script:First column defines the type of date. Type 1 is regular date range (from day A to day B), type 2 is range with days of the week (Mondays and Saturdays from day A to day B), type 3 is random dates (July 1st, 7th, and 19th).Second and third columns are start and end dates, which are mandatory for every row.Fourth column is only filled out for type 3 dates, and it has DD/MM/YYYY dates separated by spaces.Fifth column is only filled out for type 2 dates (range with days of the week), and includes the days of the week to be included, separated by spaces.I created the script below to populates another column with a string of DD/MM/YYYY dates in each of those scenarios. However, the rows with date ranges with days of the week are not populating at all, and I don't know how to fix it. It looks like it may b

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.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”: { “<>”: “<>” } }’