Development & APIs

I already have an existing database with about 3500 records. Each record contains a high rez image of a piece or artwork. The database was originally created for the sole purpose of keeping records of an artist’s work. The needs have grown. We are near the 20 Gig limit that Airtable allows our Pro account for images. I would love Airtable to look into a folder (Dropbox or something similar) and match a record number with file names. If it sees a file name that matches the record name it looks to see if it has an image in the image field. If it does not, it imports that image. If it does have an image it checks the date of the last import and if it matches the creation date of the file it does nothing. If it finds that the creation date of the file is newer than the last import date, it deletes the image on the record and uploads the newer image. I also would love to automate the creation of links to be able to download hi rez versions of the image files in the record. I am trying to ma

Hi guys, first post for me and i’m french native so sorry for spelling mistakes I have a base that shows every forms (one record for one form) and I would like to automaticaly fairly attribute a single select choice to each of these forms when they are submited I have 3 developers and I would like to fairly attribute them a form (ex. I have 90 forms/I would like 30 forms per dev) Here I’m attributing it manually Thanks you guys

Hello! I am trying to achieve the following. I would like to update my stock on button press by adding or removing the value given in the cell. Please help. Thank you very much in advance!!!

I am looking for a script to insert the current date and time into a field when you hit a button. Currently, my users just hit the “Today” button when the calendar pops up in the date-time field when they begin a task but I would like to just have a “Start Task” button. I am new to scripting and would appreciate it if someone could walk me through this first application.

Greetins! I am starting a new project where in which I will write a script that needs to be triggered… at regular intervals (eg. daily) ad hoc, manually by a user Automations work well for the first case, and scripting app for the second case. However, I wont sleep well at night if I have to maintain two copies of the script, one in Automations, one in the scripting app. What would be the best approach to not duplicating the code here? For now I am thinking of… a first automation with an incoming webhook trigger that runs the actual script a second automation with a scheduled trigger that runs a one liner script to call the webhook (and this covers my first use case) a scripting app with the same one line script that calls the webhook (which covers my second use case). Any better idea way of doing this? Thanks in advance!

I’m trying to read what are the width/height of a given image. The following JS code works fine outside Airtable: const img = new Image(); img.onload = function() { alert(this.width + 'x' + this.height); } img.src = 'http://www.google.com/intl/en_ALL/images/logo.gif'; But when writing an Airtable script, const img = new Image(); yields ReferenceError: Image is not defined. Is there another way to know what are the width/height of an image within an Airtable script?

Hello, I’d like to embed a Form in an iFrame or Webview of my WebApp because I like the way to display link records BUT I don’t understand: Testing the form I have beautifull preview with autocomplete, etc …: If I test the form “as a user” I lost all the fancy features: What should I do ? Is there a trick to embed a form with all the good looking ? Or should I code it ? Is there some kickstart to handle autocomplete ? This issue might be similar to: Showing more information with link fields on a form Views If the Link field accepts multiple linked entries, then the person filling the form can add additional options once they open the form. The one they click from will be pre-filled, but they can add more options once in the form. That may be about the best you are going to get with Airtable’s current incarnation of forms. But no real answers :frowning: What’s the point to loose “hard to code” features ?

I am trying to create a record on airtable and I am getting that createdRecords is “undefined”. All the variables FirstName,LastName,Email,JobLevel print to console but then createdRecords is undefined. const Airtable = require('airtable'); var base = new Airtable({apiKey: 'VARIABLE'}).base('VARIABLE'); const table = base('VARIABLE'); var FirstName = event.user.given_name; var LastName = event.user.family_name; var Email = event.user.email; var JobLevel = event.connection.id; console.log(FirstName,LastName,Email,JobLevel); const createdRecords = await table.create([ { fields: {FirstName, LastName, Email, JobLevel} }, ]); console.log(createdRecords); This is all part of auth0 post login action that looks like this exports.onExecutePostLogin = async (event, api) => { const Airtable = require('airtable'); var base = new Airtable({apiKey: 'VARIABLE'}).base('VARIABLE'); const table = base('VARIABLE'); var FirstName = event.user.given_name; var LastNam

Hi, I’ve been using Airtable for just over a month now and loving it, been able to create workflows that I’d have needed a whole dev team for before! Just brilliant. But now I’m straying into the world of scripting and feel a little lost, despite lots of reading, testing and trial and error. Think I need to do a course, but in the meantime I’d really appreciate some help. My base is all focused around event planning. For the challenge in question there are x3 tables: 1. Speakers - a list of speakers at an event 2. Sessions - a breakdown of the event sessions. Each session is a row, with speakers associated with each session listed in columns (Speaker 1, Speaker 2, Speaker 3, Speaker 4, Speaker 5) - and yes, I know this is not ideal and I can use a single field to reference multiple speakers, but this is how I’m supplied the data (in old school spreadsheets which constantly update), and yep, number of speakers varies per session! Speakers are linked to the Speakers table as linked recor

Hi there - We have a database with 8000+ records and have been creating a hash with them. It is crashing our automation and exceeding the limit. What are some tips to not exceed the limit?

Hi Team, I have created 1 view and 1 form within air table. As soon as i submit the form 1 row gets inserted in the view. Subsequently, The view is attached to Run Script which gives call to external REST API. Below are the fields displayed on the form. FYI. I have mentioned the fields type as well in the bracket. Field names: customer(Single Select),source category(Multiple Select) and source url(Long text) ,target category(Multiple Select),target url(Long text) and email(Single Line text) etc. Requirement: I would like to dynamically pre-filled the source category and target category fields based on the selection of the value of customer field. Could you please guide and point me to the example/link where i can get idea how this is possible to do in air table?

Hi, I want to get from a table all the records, filtered by one of the columns. For example: I have a field called “SKU”. There are many records in the table with the same SKU, different dimensions of the same products. I want to get, with CURL, all the records with SKU = 1000. How can I do that? Thanks!

Hi there - When I am testing my script, it is popping up and asking which record do I want to test. Will this always be the case or how can I have the variable passed from step 1 in the automation which is the record which is updated?

Hi there :slightly_smiling_face: I’m new to coding and Airtable and I need some assistance. My script is to update a record with user input. The issue I’m running into is in line 7. The script runs but I’m assuming it is this error that stops it from actually updating the cell. I understand the error but I’m just not sure how to remedy it. I’d also like to know how to output the new_date variable within the text output line above it.

Hello Community! I have the below script that will create X number of records based on the Episode Count, but I would like to tweak it to auto-number those episodes each time. For instance, Show 1 has 5 episodes, then each episode record would be numbered 1, 2, 3, 4, 5 //Tables let projects = base.getTable('Shows'); let episodes = base.getTable('Episodes'); //Record Input let record = await input.recordAsync('Please select a project', projects); //Record variables let quantity = record.getCellValue('Ep Count'); let order = record.id; //New record array let recArray = []; //Iterate by quantity if(quantity > 1){ for(let i=0; i < quantity; i++){ //Push to the array recArray.push({ fields: { 'Shows': [{id: order}], } }); } //Create new records await episodes.createRecordsAsync(recArray); } Any insight would be so incredible appreciated :pray: Thank you!

I have an automation that I need to count all records that meet a certain criteria. The number of records that meet this criteria exceeds 100, so the find records tool isn’t useful. There is a scripting block in the automation and I would like to count them there, but I’m not seeing an easy way to do this. I only need the step to return the count of records that meet the criteria, not the actual records themselves. Has anybody done something similar? Ideally I could make a view with the criteria filtered and then have the scripting step return the number of records in the view, but I don’t see any documentation for a function to fetch record count within a view in the API docs. Also don’t see a way to use selectRecordsAsync with an offset to capture all records that meet a criteria instead of just the 100 allowed by the function as it currently exists. Any thoughts?

Hi, I’m writing a program in Node.js using AIrtable API that fetches the record from Airtable and sends it to WhatsApp. The problem I’m facing is that for example, there are three columns COL1 | COL2 | COL3 I’m trying to achieve that if any of the columns are empty, it skips that one and moves on to the another. But when I execute col1 == null || col1 == undefined it returns false. This statement returns true only for the last column. Also when I execute col1.length it returns 1 but for the last column, it returns Cannot read properties of undefined (reading 'length') I don’t understand why the empty cells/ column before the last one doesn’t return undefined.

Hi, Professionals here, I encounter a problem, I want to use EmailJS service to send HTML emails. I try the automation of Airtable, the actions of “finding records” and “sending email”, but it is not as intelligent as I want, So I want to use EmailJS service. So I wrote the below code in Airtable script. let params = { service_id:'service_gbwx81a', template_id:'template_6euwe2d', user_id:'cxkTio1YLQSY241rj', template_params:{ to_name:"Stone", from_name:"Stone", reply_to:"Stone", message: "ABC", } } let headers = { "Content-Type": "application/json", }; let options = { method: 'POST', headers: headers, body:JSON.stringify(params), }; console.log(JSON.stringify(params)); let emailJSURL = 'https://api.emailjs.com/api/v1.0/email/send'; await doRemoteFetch(emailJSURL, "POST", params); async function doRemoteFetch(url, postOrGet, body = null) { let success = false let fetchedData = null let fetchOptions =

Hello, How do I pass function parameters as JSON field name for updating fields in Airtable using Airtable REST API and Node.js? The code const updateField = async (id, field_name, updateValue) => { base('table_name').update([ { "id": id, "fields": { field_name: updateValue } } ], function (err, records) { if (err) { console.error(err); return; } }); }

I am creating a proof of concept script which you can see below: const data = { title: 'AirTable Pusher', content: 'Push, push, push this.', excerpt: 'The short version' }; let response = await remoteFetchAsync('https://staging2.conveyancingqld.com/the_vision.php', { method: 'POST', body: JSON.stringify(data), headers: { 'Content-Type': 'application/json', 'Authorization' : 'Basic d2h5d29udHlvdWNvbm5lY3Q6Y2N1WSAxWWhkIDdsTmkgMzdWSSB5MVlyIDYySEs=' }, }); console.log(response); The return on the server side if you check at the time of this writing is: {“a”:1,“b”:2,“c”:3,“d”:4,“e”:5} It returns some JSON data - I want to access that in the AirTable script - however when I check the Console log response it says the following: {type: "basic", url: "https://staging2.conveyancingqld.com/the_vision.php", status: 200, statusText: "OK", ok: true…} type: "basic" url: "https://staging2.conveyancingqld.com/the_vision.php" status: 200 statusText: "OK" ok: true header

Hello, i am setting up a Google Apps Script to update some records from our student information system. I was able to set up an array of records in the required format for patching the data in Airtable, i also got it to work, however whenever there are more than 10 records i get an error, so i am trying to figure out the best way to process them 10 at a time using plain JS or Google App Script. I was thinking of implementing a for loop to send a patch request for every record, but that did not seem like the smart way to do it. I wondering what was the best way to break it down 10 at a time Thanks Anto

I tried to use input.buttonsASync but it’s impossible. I receive this error: “ERROR TypeError: input.buttonsASync is not a function at main on line 2” Can you help me?

Mi update with curl doesn’t work and i dont know where is the error Record id, url and key are corrects (they works with delete and create rows), but not with update. ¿Can someone help me? Thanks for your time!

Hello there, I’m having troubles to set up the “hello world” to develop a custom app. I’ve followed the guide as well as search for possible solutions without success. I’m using Chrome on Mac, “block run” is running with “https://localhost:9000” but both Airtable and Chrome are unable to access to localhost due CORS issue. I’ve tried to use chrome extensions to allow all origins but any luck. Tried to use a Proxy, no luck. I think the problem is in the Node server since if I try to reach localhost:9000 with Postman, I get the listing of Browser-sync and not the compiled React app source. Thanks for any heads-up

Today is my first foray into scripting with AirTable and i feel like the best method of learning how to script is to figure out a use of it that would be easy and useful. So i want to create a button that would copy certain fields and input them into a new row. For instance, my company manages affordable housing vouchers and we want to keep track of units that do not work out, but the voucher recipient (potential tenant) will still be searching for a new unit. Instead of rewriting over existing data, i wanted to make a button that would copy these fields: Participant Name Specialist Name Action Program URL NOTES and input them into a new row with an updated STATUS of “Back OTC”. So we know that this person previously attempted to move into a unit, but that unit didn’t work out, now they are OTC (on the clock) to go find a new unit. Does that make sense? i feel like making a button do this with a script should be a perfect way of getting my feet wet into scripting in general. I appreci