Development & APIs

Hello! I am looking for a way to import data using a URL that connects to a CSV and merge existing records on a recurring basis. This can be through a click of a button or the script running in the background. The CSV could also come from google sheets. Which of the following would be easiest to automate the importing of the CSV? Using the Scripting block and creating a button that will trigger the CSV import app? The automation with run a script every hour to trigger the CSV import app? Google scripts on the Google sheets with the Airtable API to import the CSV? If anyone has a built a similar script and is willing to share the script please do! The ideal would then be to have additional columns in the base that only sit in Airtable. Due to data privacy concerns, we cannot use a third-party extension. Thanks in advance!

I have grouped some fields in my Airtable. How can I get a specific “count” or a “sum” with API? How can I access this data through API? I am interested in getting the different counts and sums for each group. I.e: Score_act: sum 41 Task: “Jeg har koblet av med noe underholdende”: count 4 (times this task had been completed). Is this possible? Regards, Tor M

Hi all! I’m trying to remix the Wikipedia Enrichment app from Github. I’ve got everything installed and it’s working great, but I can’t get the app to release to Airtable’s servers. I’m getting zero feedback from Terminal when I put in $ block release. Right after it gives me the address to plug in a line shows up “Switched to a new block installation.” I’m not really sure why it keeps doing that. I’m on Big Sur 11.2.2 with Xcode command line extra tools installed, with a lower version of Node (14.15.0) installed because I noticed people with Big Sir are having problems. Any suggestions or what other information would you need to diagnose? Thanks everyone!

I’ve installed the Scripting app, but the input area in the upper left corner keeps loading and I can’t input any script. This happened after I ran the “Sync Airtable Base Structure” script provided by “miniExtensions”. I’m a beginner, so I don’t know how to solve this problem. If anyone knows how to solve this problem, please let me know. Thank you very much for your help.

I’m trying to use @Kamille_Parks Script No-Conflict Appointment Scheduler but I’m having a slight issue trying to set it up to allow Same day Scheduling currently it only allows appointments as soon as the next day. Any ideas? I found the line 266 //loopdates.push(loopCurrent); //NOTE: uncomment this to allow same-day scheduling but i wasn’t able to get it to work. Following is the script I am using with changes i made. /* Script: No-Conflict Appointment Scheduler Author: Kamille Parks This is the sister-script to my "No-Conflict Asset Reservations" script. This script performs a similar function, however this one is built for appointment/reservations which start and end on the same day. It allows users to select a service, pick a qualified agent/employee to perform that service, and then select upcoming dates and times which work for that agent. The script opts to use buttons as opposed to text box inputs to reduce human error in typing in correctly formatted date/time strings

Hi all, I’m at my wits end. I’ve written code for Airtable locally, which largely works. Now I’d like to place the code on a cloud functions tool so I can run my code on the browser and have it communicate with other APIs. Here’s the code I have on the serverless tool, just the basics first just trying to call the airtable library. /** * main() will be run when you invoke this action * * @param Cloud Functions actions accept a single parameter, which must be a JSON object. * * @return The output of this action, which must be a JSON object. * */ var Airtable = new require('airtable'); var base = new Airtable({apiKey: 'XXXXXXXXXXXXX'}).base('appumWMhUzhgN8fFe'); function main(params) { return { message: 'Hello World' }; } When I try to run this code, I get Error: Cannot find module ‘airtable’\n In this case I’m using IBM Cloud Functions, but the process as I also read Google Cloud Functions and others seems to be the same. I just am doing something wrong. Here’s the

Uncaught (in promise) Error: Can't create table: invalid field config for field 'games_id'. Creating or updating options for multipleRecordLinks fields is not supported at this time. Is there any other mechanism or workaround for this? When creating a table, or updating a table?

I wonder if anyone can point me to the right direction. I’m tasked to create a base for simple school administration for a small NPO. The use-case is quite simple: a Program contains multiple classes a Class contains multiple students a Student may attend more than one programs Based on the above processes, I’ve created a base with four tables: Student, Program, Class, and Attendance. the Student Table lists all of the students, and each student record would also link to multiple Program records, multiple Class records, and multiple Attendance records the Program Table lists all of the programs, and each program record would also link to multiple Class records and the students records the Class Table lists all of the classes, and each class record would also link to its parent program record and students and the Attendance Table is a junction table between Class Table and the Student Table With the above set-up, I’m able to create all of the views needed for my colleagues, such as

Hi, new to Airtable, so this may be a dumb question; apologies in advance if so. Is there a way to dynamically update single select field options from an API? For example, looking to have a list of item types to select for a record, ex: Server, Workstation, Switch This master list is contained in another system but accessible via rest API. Is there a way so that in the far end system, if “Router” is added as an item option, the Airtable option list for that field will now contain “Server, Workstation, Switch, Router”?

Hello AirTable Team! This may a simple ‘request’ to some of you. Here’s my ask… What’s the best way to use the API from Most Trusted Cryptocurrency Market Data API | CoinMarketCap to Get the data (list of all cryptocurrencies) - initial Update the data (list of all cryptocurrencies) and append new crypto currencies to the list I have my Coinmarketcap API key to get the free data Not sure if I should use scripting or pay for DataFetcher account Hoping someone can help Thanks in advance, Paul

I am trying to create a new contact record in Airtable using Zapier - linked to Hubspot. This should be really simple but I get this error: “Could not find field “fields” in the request body” When searching in community, this suggests a cdoding error in the API request - which suggests to me the Zapier-Airtable API is not set up properly \nd I cannot change this. I am not a techie - all solutions welcome!

Hi everyone, I am writing a micro-service where I want to accept a field, look for its record, and return with data from its record. Ideally, I also want to make it not case-sensitive. But I am having multiple issues with it. Firstly, unwrapping the string is “SELECT” is not working for me. It works if I just pass a string but not when I try to unwrap a variable (according to a solution I found on this forum. Secondly, how do I make it not case sensitive? is this possible if I have to write something custom (as in fetching everything and manually search through). Here is my current code. export const getDefinition = async (userInput: String) => { console.log('this is from getDefinition!!!', userInput) //configure Airtable// Airtable.configure({ endpointUrl : process.env.AIRTABLE_URL, apiKey: process.env.AIRTABLE_API_KEY }) const data = base(process.env.AIRTABLE_TABLE_NAME).select({ filterByFormula : `{term} = "${userInput}"` }).eachPage((records: any, fetchNextPage:

I’m trying to write a script for an automation that creates a list of all the companies which bought a certain material. (input.config() has two variables: materialUsed and recordID) However, I want the output pushed onto the Contact field which is in the record (which itself is a link to the “Companies” table). In short, when I add a new record, I want the Contact field to autopopulate with the links to all the relevant companies. The output.set displays an array of the correct companies, but I can’t seem to figure out how to push each of the results using the updateRecordAsync(). Thank you. // query for all the records in a table let table = base.getTable("Companies"); let searchPO = base.getTable("SearchPO"); let materialsBought = table.getField("Materials Bought") var material = input.config(); let result = await table.selectRecordsAsync(); // print ID & "Company" from each record: let records; records = result.records.filter(record => record.getCellValue('Materials Bought'

Hi everyone - I’m a total beginner to Node js but it’s very frustrating, that after hours of searching on Airtable Docs as well as through the community, I can’t seem to find the answer to one of the most basic things a user would want to do with a database. In short - I’m trying to do a lookup. Given a “phone number” of “(454) 382-9029”, I want to return the “Full Name” of “Carol Lerner”. I want Airtable to access the right record and the code to print the “Full Name”. In Excel this takes 2 seconds to do. I’m at a loss why this has been so difficult to find code for on Airtable Docs or Community on Node js. I know that I’m a beginner. I’m not sure why it’s so difficult to see how to do something like this. My code won’t really be of much help here as I keep getting errors when I try to run it. Thanks for taking a look and hope you can help.

Is there a way to tell table.updateRecordAsync what field to update with a variable? I have a table that tracks the date a person receives multiple trainings. Each training has a date field. I’m able to hard code the field in table.updateRecordAsync, but I haven’t figured out a way to do it with a variable, even a string type variable. This would allow me to have one script where one could select the training to update, rather than a script for each training. Here is my code: await recordTable.updateRecordAsync(record,{ '*INSERT VARIABLE HERE': date }); I also tried using the usual javascript way of inserting variables into strings like this: await recordTable.updateRecordAsync(record,{ `${fieldString}`: date }); This just gives me lots of errors.

I am following from API documentation. This is to capture selected fields. let table = base.getTable("SP1: Donations"); let field = table.getField("CID"); output.inspect(field); But what I wanted was to show fields specific for the selected view. I currently select view via: let view = await input.viewAsync("Messages will only be sent to records in this view", table);

Hi there, I developed a custom app/block and released it into it’s base with “block release”. Sadly it’s only working correctly on my own laptop but not on any other laptop, even with my account logged in. The app shows data in a diagram with the packages “apexcharts” and “react-apexcharts”. On any other laptop the bars in the diagram are not displayed correctly. The data is loaded and it tries to plot it, but all data are just crammed together at the axis not displayed correctly. The libraries seem to be loaded as it’s not showing nothing. I guess there must be something missing in the “released version” that is cached on my own laptop. I tried to delete the browser cache but it is still working on my own laptop. I’m a bit stuck and don’t know how to start to debug this. Any ideas what could possibly go wrong during the “release process”? Note: It works on my laptop even when “block run” is not executed so I should be running the exact same released version than the other laptops wher

Is there a way to have a user input a date in a script? I have a button that adds today’s date, but I’d like to give an option to add a custom date, just like in a date field. Text input seems kinda iffy.

I was hoping to create a simple chrome extension to plug in that would load a different css for airtable. This would have been my way around a feature request that has been forgotten. My end goal is that the table header row is 2 lines tall. A secondary goal would be if the width of a column is <x, then text orients vertically. Where I’m getting stuck is that after 1/2h of using inspector in chrome I was finally able to get the header row twice as tall, but text wouldn’t wrap to 2 lines and I’m wondering if this is as simple as a CSS switch or if I’m dreaming.

Has anyone been able to use AWS CLI as part of a script ? I want to user services like aws comprehend , aws polly and transcribe as part of a Script.

Hello, Is there a recommended approach to saving sensitive data e.g. credentials retrieved from a user logging in to a third party service? I’ve seen multiple topics created regarding this issue and they were never answered and automatically closed :frowning:

I’d like to have read-only and commenter users able to edit data using the scripting app. Is this possible? It seems the permissions within the scripting app are tied to the user’s permissions, but are there any APIs to have the scripting block act as someone else?

Hello, My input are: idStock getURL getApiKeylabel getApiKey My code: let table = base.getTable("Stocks"); let query = await table.selectRecordsAsync(); console.log(query.records); let inputConfig = input.config(); console.log(`The value of idStock is ${inputConfig.idStock}`); console.log(`The value of getApiKey is ${inputConfig.getApiKey}`); console.log(`The value of getURL is ${inputConfig.getURL}`); let mergeAPI = (`${inputConfig.getApiKeylabel}=${inputConfig.getApiKey}`); let mergeURL = (`${inputConfig.getURL}${inputConfig.idStock}?${mergeAPI}`); console.log(`The value of mergetURL is ${mergeURL}`); let response = await fetch(`${mergeURL}`); console.log(await response.json("price:")); I want to output my json result to a field.Is it possible?

Hello, we’re looking to into automatic integration to an Airtable table for moderation activity report from admin panel on our Discourse forum. Is it possible to integrate this and are there any examples? Thanks.

It would be really useful to be able to set confirmButtonDisabled and cancelButtonDisabled (both booleans) to diable the respective buttonts on the ConfirmationDialog component.