Development & APIs

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 la

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

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://s

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 = bas

Background: Hello, any help with this is much appreciated. I’m pretty new to JavaScript, but learning quickly. So far I am proficient with variables, functions, scopes, oh—and commenting things to death! Problem: I’m trying to create a script that creates a new event that automatically fills in some recurring contextual information in an [Events] table. However, I cannot find anything anywhere about entering/recording the time of day into a {Date/Time} field when running a script. The event is always at the same time 12pm-1pm (EST in my case) but the date is what needs input(ed) by the user running the script. So Far: // identify base and table info let table = base.getTable('Event List'); // user input "Event Name" let eventName = await input.textAsync('What\'s the name of this event?'); // Create new record with default event criteria in the [Event List] table let recordId = await table.c

I just can’t find the right way to format my request. I’m trying to update a single field in a single record. but keep hitting - INVALID_REQUEST_MISSING_FIELDS",“message”:"Could not find field “fields” in the request body Getting data is fine. After a few hours trying different things I’m asking for help what am I missing? Any help appreciated API and Base ID Blanked out function apiCall(){ var API_KEY = ‘XXXXXXXXX’; var root = ‘https://api.airtable.com/v0’; var baseId = ‘XXXXXXXXXXXX’; var tableName = encodeURIComponent(‘Travels’); var recordId = “recSaJTXSBu1g8CBd” var endpoint = ‘/’ + baseId + ‘/’ + tableName + ‘/’ + recordId; var params = { ‘method’: ‘PATCH’, ‘muteHttpExceptions’: true, ‘Content-Type’: ‘application/json’, ‘headers’: { ‘Authorization’: 'Bearer ’ + API_KEY }, "fields" : { "Declarat

Hi – In an effort to save weeks worth of research, I’m hoping to find someone who may know the most efficient way to build out an automation process. I have no experience with computer language or programming and am officially waving my white flag. :rofl: I essentially need to build a custom numerology app. I need to be able to press a button in my Airtable and run a program to break down each name (first, middle, last - each in separate columns) into individual characters and assign each letter to a number. There are more steps to the process as a whole, but this is my primary need for assistance. I’m fairly certain this can be done with a formula by splitting the text string (name) into individual characters; however, I don’t know how to make this a dynamic process (for the len and/or mid functions) nor do I know how to run a split function without a delimiter. If anyone has any suggestions, all feedback is appreciated!

Hi all. With my custom CSV importer script, I’d like to do a few operations before the .parsedContents method should look at the file. Examples: My file uses a comma for decimal notation. .parsedContents simply removes them, so 4,5 becomes 45 but it should become 4.5 I’d like to take a closer look at date formats used in the file, because they may vary, and even if .parsedContents correctly identifies it as a date, the format may be DD/MM/YYYY or MM/DD/YYYY. The Javascript methods .readAsText() or .text don’t seem to work even though the documentation states that input.fileAsync() delivers a File object which is a Blob. Any clues?

Hey! I’m currently making the first steps with the Blocks SDK and having problems with fetching data from our Shopify Backend. I’m trying to do it like this (frontend.js): let url = https://xyz.myshopify.com/admin/api/2020-01/orders/${record.getCellValue("Shopify Id")} let response = await fetch(url,{ method: ‘GET’, headers: { ‘Content-Type’: ‘application/json’, ‘X-Shopify-Access-Token’: ‘xyz’, }, }) return await response.json() Whenever I trigger this function, the console logs say: Access to fetch at 'https://xyz.myshopify.com/admin/api/2020-01/orders/123.json' from origin 'https://devblock---123xyz.airtableblocks.com' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: Redirect is not allowed for a preflight request. Any help with this will be much appreciated :slightly_smiling_face:

Hi everyone, As part of our ongoing effort to make Airtable more and more extensible, we’re beginning to expand access to the Metadata API. The metadata API gives you read-only access to a list of a user’s bases, as well as the specific schema of each base - things like what tables exist, what fields exist on those tables, etc. Usage of this API currently requires a unique developer token, in addition to the user’s API key for whom you are looking to pull the metadata. You can view the metadata API documentation here, and request a developer token here. We are considering in the longer-term simply rolling the metadata API functionality into the main Airtable API - this would require some deeper underlying structural changes, however, hence in the short-term we are bridging the gap by issuing individual tokens.