Development & APIs

I'm looking to see if the solution below is viable to develop as a script inside Airtable.We use a loans table and a transactions table to manage a ledger in Airtable.  In the transactions table, users enter either capital advances (loans out to clients), or capital reductions (payments against the principle).  We also have interest only payments and a few other types for bounces and reverses in this table, but for this all we really care about is the principal impacting records.    This goal of this script is to calculate the accrued interest between any two principal transactions and run this daily to update and hard code it so we always have a daily total of interest accrued on each account.  Here is the rough flow I made in make.com (although it takes too many operations)   List all active loansIterate through each loanGet loan informationList all principle transactions from the first to lastIterate through principle transactionsGet the first prin

Right now I have a multiple select field as follows: The script I’m trying to run has already identified the record IDs of all records with “Split Invoice” as a status. What I’m trying to do now is to remove that split invoice status and leave the rest (For example Estimated, Invoiced, those can all stay). What’s the best way to do this? All I can think of is to create an array of all statuses except for “Split Invoice” but I’m not sure how to write the syntax for that either. Code below: let table = base.getTable("Items"); let queryResult = await table.selectRecordsAsync(); var rec_IDs = [] var rec_names = [] for (let record of queryResult.records) { try { for (let status of record.getCellValue("Status")) { if (status.name === "Split Invoice") { rec_IDs.push(record.id); rec_names.push(record.name); } } } catch(e) { { continue; } } } // Script operations go here // As a fin

I'm trying to do a simple post request with Ruby and  net/http  but it keeps throwing the same error, here's my code:  require 'uri'require 'net/http'data = { fields: { "Video Title" : "Top 10 funniest videos of 2022" }}uri = URI(https.....)headers = { 'Authorization': 'xxxxx', 'Content-Type': 'application/json'}http = Net::HTTP.new(uri.host, uri.port)http.use_ssl = trueresponse = http.post(uri.path, URI.encode_www_form((data), headers)puts response.body # {"error":{"type":"INVALID_REQUEST_BODY", "message":"Could not parse request"}} I've tried a bunch of things from google including downloading Ruby air table gems but they always throw the same error, I have a hunch that the object is not properly structured, If I send an empty object I get a different error: data = {}....response = http.post(uri.path, URI.encode_www_form((data), headers)puts response.body # {"error":{"type":"INVALID_REQUEST_MISSING_IELDS", "message":"Could not find field \\"fields\\" i

I have a board where I track ice cream names and the flavours they come in. Names are self generated where are flavours are common names such as vanilla or chocolate and so on.I want to use the npm airtable code here:https://www.npmjs.com/package/airtableand what I want to achieve is if a new flavour is added to the list of flavours, I want to also add this new flavour to the list of options available on the Airtable multiple select field. I am trying to mimic the code here:https://airtable.com/developers/scripting/api/field#update-options-asyncconst table = base.getTable("Tasks"); const selectField = table.getField("Priority"); await selectField.updateOptionsAsync({ choices: [...field.options.choices, {name: "Urgent"}], });However using the npm package it seems these functions are not available.I also tried using Curl as below:curl --request PATCH \ --url https://api.airtable.com/v0/meta/bases/{baseId}/tables/{tableId}/fields/{fieldId} \ --header 'Authorization: Bearer {myToke

Hi All, I would like to use the Airtable API to create a new table in an existing base. I've tried using Python/ PyAirtable as well as https requests via Postman. The API reference uses the following:https://api.airtable.com/v0/meta/bases/{baseId}/tables However, the last bit seemed rather strange to me plus I'm getting the following error: { "error": { "type": "INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND", "message": "Invalid permissions, or the requested model was not found. Check that your token has the required permissions and that the model names and/or ids are correct." } } I'm using a personal token, with the required scopes (i.e. schema.bases:write)And the following payload (copied from the example): { "description": "A to-do list of places to visit", "fields": [ { "description": "Name of the apartment", "name": "Name", "type": "singleLineText" }, { "name": "Address",

Hello!I am getting error while requesting api - using your javascript examplevar Airtable = require('airtable'); var base = new Airtable({apiKey: 'YOUR_API_KEY'}).base('XXXXXXXXXXXXXXX'); base('Settings').find('recKrP4fJsCmnavbd', function(err, record) { if (err) { console.error(err); return; } console.log('Retrieved', record.id); });GET https://api.airtable.com/v0/undefined/Settings/recKrP4fJsCmnavbd? 404AirtableError {error: 'NOT_FOUND', message: 'Could not find what you are looking for', statusCode: 404}

Hi All,I am looking for a FIND or SEARCH formula to use in a GET URL.I need to lookup an ID, lets say "1234" and that ID is within a Multiple Select Option Column.the column on the table is a lookup and has multiple ids all in a string. example: 1234, 3563, 235234, 1435I am wanting to do the lookup to find the Record that the "ID" is within the multiple ids.The formula i'm using now, is looking up a Single entry, not an entry within multiple.What would my URL Formula Looklike?Here is what i'm using now.api.airtable.com/v0/"APP"/"MYTABLE"?filterByFormula=FIND("ID",{Client+ID})&maxRecords=1&pageSize=90Thanks

Before starting this, I will say I have no background in writing script.  Any script/code I have posted was created using OpenAI API.What I am trying to create is an automation that upon an update in a selected Single Select Field will begin an automation that utilizes a script to input today's date & time in an adjacent Time/Date field.When I entered the code below into the Edit Script window and ran a test, the test failed with an error stating "ReferenceError: document is not defined at main on line 12" Can anyone provide feedback of what I need to change to make it work? var today = new Date();var options = {  timeZone: 'America/New_York',  hour: 'numeric',  minute: 'numeric',  second: 'numeric',  hour12: true};var timeString = today.toLocaleString('en-US', options);var dateString = today.toLocaleDateString('en-US');var dateTimeString = dateString + ' ' + timeString;var dateTime = document.createElement('div');dateTime.innerHTML = da

Hello there!My goal is to get a video from my Airtable record and Transform it with Cloudinary.I've tried using the Airtable "Search" and "Watch records" module(both successful at picking up the right record), and then retrieving with Make's HTTP module as well as directly to Cloudinary's Upload module.Both HTTP & Cloudinary modules seem to be failing at retrieving anything with the Airtable URL. Do you have any tips on where I am going wrong? New to APIs in general so it's tricky for me to troubleshoot on my own.

Hi! I would like to write a script that automatically creates time slots one week in advance. These time slots are every Tuesday and Wednesday from 9am to 2pm (6 time slots/day). For now, I type them manually but there is certainly a better way… Let me know what you think :slightly_smiling_face:

Dear community,I'm seeking your help on this critical matter:My client is in Europe, it is a GDPR breach if their data leaves Europe, does Airtable has storage in Europe? My client needs to upload videos to our tables. The attachment bucket seems to be a S3 bucket in the US. Do you have a quick workaround for this matter? Happy to provide our own data storage on S3 which is in Europe.If we don't resolve this we have no choice but to move away from lovely Airtable :((Thanks

Hey everyone! Excited to join this community as a developer.I have submitted my app for the Airtable Marketplace on 21 November, but I still haven't heard from the review team. Is it normal for app reviews to take this long? What's the usual turnaround time?

Hi, I am trying to create a rather simple table view of linked records with some editing capabilities. As far as I managed to discover, the grid element is not available in the SDK, so am using using the Primereact library. It is going pretty well overall, expect that I cannot get primeicons to be displayed. All I get is a square instead of the actual icon (similar to what is described here) I am fairly new to React and frontend development, so perhaps my question will not make sense to everyone and I am not sure this is even supported, but I’ve seen that some people are using primereact with Airtable SDK, so I am thinking there must be a way to display these icons?

Writing valid .jpg URLs to an attachment field - one of them is saved as normal, one of them fails to show a preview whilst loading, then gets cleared completely. I saw it 1st in Data Fetcher and then wrote a script to reproduce it: // This URL is fine const url1 = 'https://upload.wikimedia.org/wikipedia/commons/7/7a/Galileo_moon_phases.jpg'; // This URL does not work for some reason const url2 = 'https://www.haven.cz/_scripts/slir/w1200-h1200/eshop/batohy-hydrovaky/luminite-ii-18l-green/1-batoh-luminatte-ii-green-male.jpg'; const table = base.getTable('Table 5'); let query = await table.selectRecordsAsync({fields: table.fields}); for (let record of query.records) { await table.updateRecordAsync(record, { 'Image1': [{url:url1}], 'Image2': [{url:url2}], }); } console.log('Done') Here’s a video of the issue: Loom | Free Screen & Video Recording Software | Loom @Will_Powelson @SeanKeenan please let me know if there is someone better from the Airtable team t

The tutorial by Jonathan Bowen has been incredibly helpful. So far my script calculates the sum of the “Amount” in the “Monzo Transactions” table. My next step is to figure out what to add to the script so that the next part of the process will update a record in the “Monzo Account Balance” table which inserts the sum every time the script runs. (either in the “Mozo Balance” field or “Total Amount field”) If anyone can offer the script that would need to be written to complete this process (or advice) I would appreciate it. Thanks

Hi guys, I’m working with a base that I have created for our team with 3 tabs: Talent, Client and Projects Since this is a many to many relationship between Talent and Projects, I created a Junction table to log and manage information specific to various Talent and Project relationships. We now have over 40 projects and 800 + talent records that become 30,000 + records in the junction table. I need some help with modifying this junction table script to avoid unnecessary records being created. I only want this for selected records in the Project tab i.e. live projects instead of complete ones or checked projects in the Project table. I’m a little new to Airtable and I don’t know how to script unfortunately, so i’d any input/guidance towards this issue.

I’m relatively new to coding, and I was able to call a REST API, and record the information to the console log. Unfortunately, where I am having trouble, is then taking that response and doing literally anything with it. Here is the code and the response below let response = await fetch(‘https://myapiendpoint.com’, { method: ‘GET’, headers: { ‘apikey’: ‘123456789’ }, }) console.log(await response.text()); The response I get is in XML it seems. A small excerpt of the response below: <User><Id>USER ID</Id><UserName>USER NAME</UserName><FirstName>FIRST NAME</FirstName><LastName>LAST NAME</LastName><Active>true</Active><Email>EMAIL</Email></User> I want to take the objects in this response (for example FirstName and LastName), and assign them to variables so that records can be created in later steps. I appreciate any assistance that can be given!

Hello together, is there a way to get just even or just odd rows from a table? Even: 1,3,5,7,9,… Odd: 2,4,6,8,10,… I want to use https://api.airtable.com/v0/xxxxxxxxx/${even-rows} or something else. Maybe someone high skilled can help me with this issue :slightly_smiling_face: Thanks a lot!

Hi, I’m trying to get a component’s name and insert it as a class name. A google search tells me I should use this.constructor.name, but that doesn’t seem to work here. Eg: function OrderLineItems(props) { return ( <section className={this.constructor.name}> </section> ) } Does anyone have a solution for this?

Hello dear community members, I hope you’re doing great. I am requesting your help because I would like to use a script, so that when a partner edits a Linked Field (here ‘Status’) in his Table View, it will directly compare its value to the Status of the client in my Lead Table (lookup field) to update it, based on the one the partner selected. I was using “edit shared view” before but it has been removed by Airtable, and I tried different options but seems the “only way”. I already have different synced tables within my main base, and I manage to organise everything between them, but he cannot work for this specific need of editable view. Because the “Status” that is to be chosen from the partner in its view is creating a duplicate in my ‘Status’ table, and thus do not update my CRM, which therefore do not stop/ launch my sequencing and is a big problem for me because it means I will/or will not send email to people who should receive/or not one. The thing is that in both table my ‘k

My extension uses a react component (monaco editor) that downloads a .js from cdn . jsdelivr . net when it is rendered. The extension was approved for Airtable marketplace in July (4 months ago) and it worked fine. But now users are getting error when extension tries to display the editor and the browser console shows: “Refused to load the script [link to .js on jsdeliver cdn removed] because it violates the following Content Security Policy directive” etc… Extension communicates with my server with no problems, so the “Allow network access” for the extension is enabled. Do I need to change the extension to no longer use that react component and resubmit to Airtable - which will probably take weeks - or is there another way? Extension is: InfoPixo Live Charts

Hi - I am trying to have a script that will take a single row with a linked record column (one which allows multiple entries), grab the data from the field, strip the commas, pivot the data (now 1 value per row), and then insert those rows into another table. For example, the source data: Source table Person Project (linked record, multiple) Bob Proj1, Proj2, Proj3 Jane Proj1, Proj3 Destination table Person Project (linked record, single) Bob Proj1 Bob Proj2 Bob Proj3 Jane Proj1 Jane Proj3 I can generally understand existing scripts but am not a dev full time and so am not sure where to start with creating new. Can anyone help?

Hi first time scripting in Airtable and its a bit difficult so any help would be appreciated. I am using a button to run an automation to create a new record in a table. I then want to set a value in this new record to a USER INPUT value. This USER INPUT would be prompted when clicking the button.

Hello, I try to fix the change made by Airtable that break all scripts with Expiring download URL. So I was building a list of Media URL for my record Switching form URL to Expiring Download But I have no results while iterating of the variable: The content seems to be blank on test record: How can I retrieve from the Script UI the correct “temporary URL” in order to be able to download it WITHOUT Sign-in ? Thanks !

Hi, can anyone help with scripting? I am loading a record from Salesforce with a number, an ID, and a quantity. I want to then (with a script) automatically create more records (depending on quantity) with each record adding a 1 to the first records number. So if the salesforce imported record had number: 000001, ID: XYZ, quantity: 5, this would be pulled into airtable and then a script would create 4 more rows as follows, then stop. 000002, XYZ 000003, XYZ 000004, XYZ 000005, XYZ Can anyone help? Thank you so much in advance if so!