Development & APIs

Hi, is there a way to check the validity of a URL from a record? I would consider a URL to be valid if it is reachable and does not lead to a 404 error. Using Google I have seen examples as the following: var request = new XMLHttpRequest(); request.open('GET', 'http://www.mozilla.org', true); request.onreadystatechange = function(){ if (request.readyState === 4){ if (request.status === 404) { alert("Oh no, it does not exist!"); } } }; request.send(); But apparently XMLHttpRequest() is not known in Airtable Scripting block. Any hint would be appreciated! Thanks, Stefan

Hi, I’m wondering if anybody can help me write a script to convert .mov files into .mp4 automatically in Airtable. I currently use CloudConvert but since they have an API, I thought there may be a way to have this done in Airtable. I know very little programming and am not sure how to even start making this work. https://sandbox.cloudconvert.com/api/v2/jobs/builder#

Hi All, So I am trying to create a new record in Airtable using google app script. I have been using the API documentation and reading the forum but can’t seem to get it to work. Any help would be much appreciated. Thank you. Code snippet var baseKey = 'XXX'; var airtableAPIKey = 'XXX'; var airtableAPIEndpoint = 'https://api.airtable.com/v0/'; var tableName = 'Table 3'; var payload = { "records": [ {"fields": { "Name": "Jeff", "Date": "2020-11-15", "Status": "Done" }} ] }; function AirPost(baseKey, tableName, payload) { var options = { method: 'POST', headers: { 'Authorization ': 'Bearer ' + airtableAPIKey, 'Content-Type ' : 'application/json' }, payload : JSON.stringify(payload), muteHttpExceptions : true }; var response = UrlFetchApp.fetch(airtableAPIEndpoint + baseKey + "/" + encodeURIComponent(tableName), options).getContentText(); return(response); }

I am doing a onedrive link generator , however , I found file path structure is very important to me. file path of URL is like https://walttaz-my.sharepoint.com/personal/aloha631_office-365_com_tw/_layouts/15/Doc.aspx?sourcedoc={69284668-F854-4789-A74F-C9F6DA0C1AAB}&file=Link%20List.xlsx&action=default&mobileredirect=true I need convert it to something that I can understand I found there are some sites which are able to convert url to file structure https://www.convertstring.com/zh_TW/EncodeDecode/UrlDecode How can I convert it automatically within airtable?

Hello, I have a database with a lot of companys and company’s informations. I would like to find the linkedin URL of the CEO for each company. So I would like to create a script that take the value “company name” and that search on google : site:linkedin.com/in ‘CEO’ OR ‘Co-fondateur’ AND “company name” and return in the same record the first link found. I never practice on javascript… so someone may help me with that please ? Thank you

Hi, everyone! I need your help: I have installed the scripting app, and I am trying to make a report going through all the records in one of my tables. I would like to be able to compare the date in one of the columns (type Last Modified Time) with the current date (today), because I only want to output records that are 2 days old or less. I’ve tried some scripts I’ve seen around here (if (DATETIME_DIFF (TODAY (), {theDate}, ‘d’)> 2)), but they don’t work for me. Thank you.

Hello Community, Trying to create my first Airtable App by following the Hello World example and running into a number of npm errors and issues. If anyone can provide a bit of guidance on how to resolve this it would be greatly appreciated! The first error occurs when trying to run ➜ Airtable npm install -g @airtable/blocks-cli npm WARN deprecated urix@0.1.0: P npm WARN deprecated resolve-url@0.2.1: npm WARN deprecated fsevents@1.2.13: fsevents 1 will break on node v14+ and could be using insecure binaries. Upgrade to fsevents 2. npm WARN deprecated chokidar@2.1.8: Chokidar 2 will break on node v14+. Upgrade to chokidar 3 with 15x less dependencies. npm WARN deprecated fsevents@1.2.13: fsevents 1 will break on node v14+ and could be using insecure binaries. Upgrade to fsevents 2. npm WARN deprecated chokidar@2.1.8: Chokidar 2 will break on node v14+. Upgrade to cho

We’ve built a custom API call to push form data into Airtable, this works fine when working on my localhost environment but when deployed to our staging site we get the following error returned from the API {"error":{"type":"AUTHENTICATION_REQUIRED","message":"Authentication required"}} There is no difference between any of the code base, the tables it references or the API keys. Is there some additional setup needed to allow these requests to be pushed up from a specific domain?

Hi, I copied Airtable’s Currency Conversion Import script and kept everything the same except renamed the table and fields to the following: const table = base.getTable(‘Currencies & Exchange Rates’); const conversion_field = ‘USD → Currency (Non-Static)’ const currency_code_field = ‘Currency’; I’m currently getting the following error message when I try to run the script: What’s the issue here and how can I fix this? I have extremely limited JavaScript skills, I only know what I’ve used by copying other template scripts. Pasting the full script below in case helpful.

Hi all, my first new topic. My background includes coding in many languages, working with mysql, and other database tools (filemaker). New to scripting in AT. Have a field that is a Link field to another record called “art# FK to Inventory”. And as the name implies, the link points to the Primary Key (aka the first field in a record here in AirTable world). Some of the records have this field blank. Luckily i have a backup copy of this field that has the data that needs to go into this field. In my first foray into scripting in AirTable (AT), i searched around in scripting basics and a bunch in this fine topic and found the code i needed to try what i thought might work to copy the backup field, which is a Text field, and put it into the Lookup field. Before i hit Run, i put a Break into the code to stop after finding just one blank field to fix just in case. So then I hit Run button to test (i have a backup copy of my base), and got this display:

What would be the best way to format and clean a field with Instagram URLs? I have a CRM built on Airtable and one of the fields is the contact’s instagram details. But some of them have been entered as ‘@myinstagram’, some simply as ‘myinstagram’ and some as ‘https://instagram.com/instagram’. What would be the best way to format all of them as URLs? Thank you!

Hey all. I’ve got an Automation script seemingly close to get the Youtube Video ID from a full URL which I found here. Script from link above <script type="text/javascript"> function youtube_parser(url){ var regExp = /^.*((youtu.be\/)|(v\/)|(\/u\/\w\/)|(embed\/)|(watch\?))\??v?=?([^#&?]*).*/; var match = url.match(regExp); return (match&&match[7].length==11)? match[7] : false; } </script> Goal: I’m trying to take a Youtube URL in an existing field: myInput or https://www.youtube.com/watch?v=YAIlMUX9VLg and strip out only YAIlMUX9VLg to pass onto the next step (or output to the field Video ID, doesn’t matter). I’m feel like I’m so close but

Hello, I’m attempting to integrate Airtable and Power BI to create reports. Using the API authentication key, I am able to connect to one of my tables in Power BI. However, the JSON string only contains 100 rows when connected. A more complete explanation of this issue is covered in this short tutorial and subsequent comments: mpolino.com – 29 Apr 16 Airtable and Power BI - mpolino.com Warning, this may be l

I am reviewing our approach to websites - and want to connect airtable and the CMS - so that writing / approvals etc get done in airtable and then this automatically updates Wix (for example) with the content into their CMS databases. this would have the benefit of not needing to have lots of people log into Wix / or a website CMS and having one source of our data that we want to show. - e.g. blog posts I am not loking to embed the Airtable DB in Wix - that bit is easy - but doesn’t provide the same opportunity to play with design as being in wix DB any thoughts / help?

Here’s a simple script - so small it should be labelled a scriptlet. It takes a crappy date value stored as a string from one field and scrubs it for use in a real date field. In practice, it might be easier to clean up this date column easier with a formula field, but then you’d have another field with dependencies. While formulas are fine for simple tasks, this little block can implement very complex string handling and math computations. As such, this example is simply an educational step to get some experience with the new Script Block. It could be broadly applicable to almost any data cleaning or data-building process. (complete source provided at the bottom) The data import and resulting cleaned column look like this: Now, imagine a case where you had the lat/lng of your business and the lat/lng of every sale. How could yo

We’re trying to write a script that will copy all of the records in a template table into a work table. One of the fields in the template table is a single select field, but we can’t seem to copy its value into the new table. We can create a query with the selected records and iterate through them, but can’t get the format right for the single select field. In the following code, the first two fields copy fine, but we can’t find the correct format to copy the value of the single select field “CATEGORY”. fields: { 'BUYER CHECKLIST': task.name, 'SORT': task.getCellValue('SORT'), 'CATEGORY': ???, } Can anyone point us in the right direction? Thanks!

Hey all. I have been building a Video Tracker Base for my Youtube content. It’s honestly one of the most enjoyable things I’ve worked on in Airtable so far. Anyway, I’ve used this post to make an awesome clipper to pull in my existing videos (with the Clipper App). However, one common data tracking piece is what the view count is at 24 hours. I’ve never had a way to track this, and without setting a timer and manually going to track it myself, I’d love to make an Automation that scrapes the views off the video page. I know the view count css selector is: #count > yt-view-count-renderer > span.view-count.style-scope.yt-view-count-renderer Which works great in the clipper from the above-linked post. Some examples of fields this would probably use : Date Field called: Published (the publish date to trigger the 24hr timer)

Hi! I am using an automation to run a script when a record is created in SIGNUP table. The script should link the records (which are people) between two tables—SIGNUP and CUSTOMERS. The primary field in both tables is the person’s name but it is easiest to match the records via the email addresses. I am getting an error saying that the link field cannot accept the value. I am using the input variable. See photo. let recordId = input.config().recordID let trainingTable = base.getTable(“SIGNUP”) let recordQuery = await trainingTable.selectRecordsAsync() let recordToUpdate = recordQuery.records.find(record => record.id == recordId) let trainingEmail = recordToUpdate.getCellValue(“SIGNUP EMAIL”) let applicationsQuery = await base.getTable(“CUSTOMERS”).selectRecordsAsync() let applicationsToLink = applicationsQuery.records.map(applicationRecord => { if (applicationRecord.getCellValue(“CUSTOMERS EMAIL”) === trainingEmail) {

Is the airtable API down? Please see the screenshot below. Can someone help me?

I am working to develop a custom integration between my Airtable base and my Office 365 system via Sharepoint and PowerAutomate. For Context: My overall project involves pushing selected emails directly from Outlook into Airtable, with a pdf of the email text and uploading the attachments. Power Automate allows me to create the pdf of the text and the attachments into any cloud storage system, I want. However, all of those systems only seem to output sharing links that require some kind of authentication or are view-only style “sharing”. Is there a way I can get a URL from any of those services that would actually allow Airtable’s api to download the file and get the proper file type, name, and other metadata?

Hello everyone! I am not familiar with scripting or programming so I was wondering is it possible to create a script that pulls attachments from multiple different fields and compile them into a single field? Below attached is an example of what I am trying to describe. I want attachments uploaded in [DASH] to be compiled into [FM] All other customs docs.

Hey everyone! I’ve spent hours dealing with this issue, and I think it’s time to come hat-in-hand to the community now. I’ve created a royalty system that pays out composers each month. I’m working on splits now among our composers, so each song in our catalog may have a link to one or more composers. Up until now it was very easy to do a “select” call to our song base and filterbyformula on our “Composers” lookup field by individual composer and then do various nifty operations on that composer’s songs for the payment period. But NOW some songs have more than one composer attached, and when I try to do various iterations of filters that I’ve tried, I either get ZERO songs or ALL songs, neither of which are ideal, to say the least. Does any Airtable API Javascript guru out there have the answer where I can make a call to the Songs and filter by Composers (with more than one attached in a Lookup field) where I can do what is essentially a “contains” filter?

I’m trying to make a script that will read from a Date field and copy and paste that data into a Link to field in the same table. If there is a better way of doing this I am completely open to it. The end goal is to setup an Automation that will check for a change in date from the source and reflect that in a weekly report table.

I have a table that tracks the steps and results in a process. Sometimes we modulate the steps, but often the steps remain the same over multiple submissions/rows. For example, we have molds that need to be cleaned using a variety of different tools, solvents, and methods. I have a column titled Mold Cleaning with options “Standard” and “R&D”. I would like to be able to have subsequent columns autofill based on the selection in this column. If “Standard” is selected, then I would like the tools/solvents/methods to input our standard selections for that. If “R&D” is selected then I would like for the tools/solvents/methods to remain blank for input. Can this be done through scripting or some other means?

Hi, I have a Product Management Base that houses a series of production deadlines. As each deadline, set in its respective Date field, approaches the 72-hour mark, a corresponding Function field flips from “Work In Progress” to “Upcoming.” My question is as follows: is there a way for this change to trigger an email, either through Zapier or Integromat? From what I’ve seen of Zapier, it’s Airtable triggers only involve adding new records, not updating existing ones. I’m new to integration so anything helps!