Development & APIs

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};

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:

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>&

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

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!

So I have a situation where I simply want to calculate cost-of-goods sold. Allocation is done based on FIFO, however I could only find one reference to a script here: https://community.airtable.com/t/fifo-script-help/35234 Does anyone have a working script? Or is there a non-script way to do this that I’m just not getting it (admittedly I’m new to Airtable). I’m surprised this is not an extremely common problem–I don’t see much in the forums or other websites. Any help would be appreciated :). Many thanks :pray:

Hello, I’m hoping someone can help me figure out what’s wrong with my script. I’m new to JavaScript so I’m hoping it’s something simple. This is to track inventory first-in-first-out. I have 3 tables. First is a list of inventory received. Second is a list of inventory sold. Third is mostly lookup fields that track the current inventory levels. I have a script that works when I iterate through the array by manually updating the index. i.e. I put in “0” as the index, run the script, edit it to “1”, run the script, and it works fine. But when I try to loop it, something’s wrong. I’m doing this on the line that I’ve starred. Here it is: let salesTable = base.getTable("Sales"); let salesRecords = await salesTable.selectRecordsAsync({ sorts: [ // sort by "SKU" in ascending order {field: "SKU"}, // then by "Week (End)" in ascending order. {field: "Week (End)"}, ] }); let inventoryTable = base.getTable("

Hi everyone, I’m trying to build rollup fields using the enterprise api endpoint listed here. But I keep getting 422 errors, even when I try to create basic fields such as auto numbers. Here’s an example of the data I’m sending var url = "https://api.airtable.com/v0/meta/bases/baseId/tables/tableId/fields" var data = { "name": `q_2-1-test`, "description": `Random desc`, "type": `rollup`, "options": { isValid: true, recordLinkFieldId: `fldhDkHwnD45oCZq6`, fieldIdInLinkedTable: `fldn0niuiFhkEuyF2`, referencedFieldIds: [] } }; I’m a little confused by the referencedFieldIds property, I’m not quite sure what should be specified here. I have used the Script Interface to see what was referenced here on an existing rollup field, but here is what I got:

I’d like to add multiple values into one cell. Preferably so that these values add up to one summarized value to another cell. How to do this? Example: A 17.5 meters long flag festoon is done of 4 snippets of 5 meters, 5 meters, 5 meters, 2.5 meters. These snippet values should be in one cell and add up to total length into another cell.

Hi, new scripter here in AirTable. I’m familiar with Google Apps Script, so I’m just trying to learn the minor differences here. I’m trying to run a fetch POST operation here in Airtable scripting to a 3rd party site that stores jpgs. The fetch will return the image url and a bunch of metadata. I can retrieve this info in Apps Script ok. I’m trying to do the same here in AirTable. My question before I get started is, the 3rd party company requires a callback URL from this source to allow access to their server. In Google Apps Script, it looks something like this; https://script.google.com/macros/d//usercallback What is the AirTable callback equivalent, so I can send that info the 3rd party company and get my access approved? Thanks

I have a list of companies I need to keep an eye on. Is it possible to have an updated twitter follower count daily with only the twitter link of these companies? I have been searching everywhere but I cannot seem to find an answer.