Development & APIs

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.

Been trying to wrap my head around how to display record attachments (images) in the markdown output of the scripting app. I heard rumours that’s possible :slightly_smiling_face: but haven’t seen any code snippets that seemed to be working []!($URL) produces errors asking for a function called Any hints?

Hello, We have created a new base with full permission. But i can’t write to this new base. Is anyone else having same issue? “message”:“You are not permitted to perform this operation because the field or table has been configured to limit who can perform this operation”

Hi, I have two tables. “Margins” and “Orders”. I need a script that would be triggered by an “New Record in the Orders table” automation that would use the value in the “Product” field to lookup a “Margin” value in the “Margins” table, then record this against the new order record, assuming a match is found. In doing this, I hope to preserve the current margin against a new order, something that would not happen with a normal lookup filed as it would simply update all the linked order records when a margin is altered. Would anybody be able to nudge me in the right directly here. I have no experience in Javascript, although I have basic knowledge of Python. How do I select the “Product” value from the latest record(s) in the Orders table and only update those records that have not been already updated previously be the script? Are there examples of similar scripts that anybody is aware of that I could work from? I am guessing that this example posted by @Sam_Cederwall could be a good st

When adding a file to an attachment field via the API (using Zapier) the file being added replaces any current files already in that field rather than adding it in.

In case somebody looks for ways to get uploaded Youtube channel video links to Airtable… You can go Zapier … Or you can go Integromat. However, Integromat doesn’t list Youtube as one of the available integration options. I’m not sure why is that. Is it because Youtube is not a business app? I found link to automation template and that enables to get the Youtube app. https://www.integromat.com/en/integration/79-post-new-youtube-videos-on-facebook You need to create API credentials for Youtube (it’s a bit pain, the description here doesn’t match anymore)… https://support.integromat.com/hc/en-us/articles/360025257393-Connecting-YouTube-to-Integromat-via-Google-OAuth-Client The “Search Records” module needs a Formula {YOURFIELDNAMEINAIRTABLE}=“NAMEOFTHEYOURUBEVIDEO”. In this scenario the name of the Yourube video matches the name of the record in the Airtable field. Set the limit of number of records to return to “1”. If multiple videos have same title, I believe higher number would res

Hello, as far as I understood I cannot pass an input when I call a script. Am I right ? I have a table A with 3 fields id, name, description I have a table B with 3 fields name, id (link with the table A) and single select (template, todo …) Each time there is a new record in A I want to create records in B with b.id = a.id for each record b.template. for those records the single select will not be template but todo. I hope it is clear :frowning: Thanks for your help Alex

I have a ledger for tracking inventory movements. When I create a new line with a 502 movement I want to run a script. The script has an input variable which is a list of linked records from another base. I want to read those records and get some data from them and then automatically create some new lines in my ledger base. I am trying to pass the values from the subcontracting records lookup The problem is when I read the subcontracting records it looks like it is reading multiples of the same record ID and when it writes to my ledger it links the incorrect material codes. Can someone help me with what I am doing wrong? //sets up the tables and input var let subcontractingTbl = base.getTable('Subcontracting'); let ledgerTbl = base.getTable('Ledger'); let inputConfig = input.config(); let mapOutput = 0; let compPosted = 0; //loop thorugh, read the subcontracting components and writes to ledger for (let i = 0; i < inputConfig.subcontractedRecord.length; i++) { let subconInpu