Development & APIs

Continuing the discussion from How fast is searching for a specific value in a field (column)?: I did a test to check in practice how searching for a single value using Airtable API scales with the number of rows and it turns out that there’s no problem with that. Here’s a table that I got that shows the number of rows in an Airabse table and how long it takes to find a given user ID string in seconds: rows, time 1, 0.52 10, 0.39 100, 0.39 1000, 0.41 10000, 0.47 50000, 0.75

I currently have a spreadsheet in which I enter my daily sales records and bank balance for each day. I use the previous day data to calculate the bank balance difference and sales data. I was wondering if there is a way I can replicate the same behaviour with Airtable?

Hello all, I’m a no-code programmer (if that’s even possible) so for everything I do I look for a similar example and I copy and adapt. I’m trying to make a script where after pressing a button the user is asked for a couple of values to be updated in that record. I’m not able to find any script example where it automatically selects the record which button was pressed, and I always see something like this: const record = await input.recordAsync(“Pick a record”, table); Where user has to find and choose again the record to be updated. How can I do that? Is it possible? Thank you!!! Angel

Recently discovered Airtable and love what it can do as I track several things across a good amount of Google Sheets. I have been wanting to consolidate them for a long time and Airtable looks the part. I have a very long and complicated if/else statement that I need help with. I have never written script before and over the last three days I have tried to learn as much as I can about it. With that being said it is still over my head on how to accomplish what I want. I tried to do this with a very long nested if statement with no luck and after some research it looks like a script would easily do want I need. Our company pays out a year end profit share bonus based off the number of training hours the teammate(employee) completes. The basic formula is long but fairly easy to follow. Where things get complicated is if the teammate joined us during the current year. Last year we expanded and had several join us throughout the year. Every quarter we require a minimum of

Hi guys! I’m running an Order Management System with Airtable and I run into the 50 000 limit quite often. My solution is to make a copy of the entire table and clean the main table from most of the copied records. This solution is quite effective but as I have many of these copies there is a problem where my team needs to find an archived record. For this I have created a multibase PHP search that works quite well - but I don’t have any way to generate a clickable link to these record. What I have: I have the base ID that I’m searching I have the record ID What I need: An https link that opens the record in Airtable so that my team doesn’t have to open the table manually. Is it possible to generate a clickable link while having a base ID and the record ID - or do I need anything else? I’m writing the script in PHP. Thanks for any help - much love to everybody <3

Hi, we paid for the Pro Account on Airtable yesterday ,the trial period was expired. However, the workspace shows we are on Trial. This is a problem because it is a big blocker for my project. Hope someone can help. Thanks!

I am trying to delete in Bulk with integromat, I am trying to create the payload Can someone please tell me what is wrong here?

I have been using Airtable as the database to work with a Node/Express API for about a year and when fetching data from a table, any linked records just return as IDs. I ended up creating a populate() function which loops through these linked IDs and does another fetch to Airtable to grab those linked records and merge it back into the original object. As you can imagine this can result in some really slow response times based on how many records are being returned and how many linked IDs those record have. Would love to know if there is an easier/more performant way to do this?

I have a table/sheet that has a field that links to records in another table (parent/child). When I use the REST API and do a HTTP GET (url, params, headers), and look at the response, the only thing I see in the field with the link is the AT record identifier like: [ 'recPKTGm6EPiDoS6g' ] No data from the linked record is present. I have searched all over the response, and I do not see that there is enough information to use this AT record id to get the data of the record it refers to. ------------------------------------------------------------------------------------------------------------------------ In the UI, if I click on the field in the sheet, I get a popup that shows the full record (all data fields), and clicking on the down arrow next to the key at the top, I can see an option: “Copy Record URL”, and it looks like this: https://airtable.com/tblPlziY7QNosBG3N/recPKTGm6

Hello all! Very new to this, especially to scripting. I am simply trying to create a way to generate multiple entries on the ‘Codes’ tab based on the Quantity Purchased in the ‘Purchases’ tab. Currently I have an automation which allows one single entry to be created in Codes based on the New Record trigger on Purchases. I have tried to go through scripting and cannot get my head around it and would so greatly appreciate if someone would be kind enough to assist me by any chance. Many Thanks indeed, K

Two questions, rolled into one. I started using prefill_ to populate a form with URL parameters which worked a treat against a single line text field. However, I’ve had no joy in getting the prefill_ to work against a lookup field. Is this possible? I then explored using a script to copy the value from a single line text field into a lookup field, so that I can create a linked value. However, when I tried this, I kept on getting error messages about the lookup field being an array and I couldn’t work out how to pass the single field values into an array, to populate the lookup field! Any help would be much appreciated. Simon

I was reading in Reddit about the AirTable metadata endpoints API: Verb URL Description GET api.airtable.com/v0/meta Returns a list of your bases GET api.airtable.com/v0/meta/{{base_id}}/tables Returns a list of tables in the base GET api.airtable.com/v0/meta/{{base_id}}/tables/[{{table_id}}, {{table_name}}] Returns a list of columns, column metadata, and views and read that some this link work from some users, this is true or fake???

Is there any plan for an API to pull metadata? It’s currently very difficult to infer the schema, you have to resort to hacks like reading all records and then trying to infer types and column names from that. It’d be great if you could pull the schema information for a table more easily! It’d also be awesome if you’d be able to add and change tables from the API, but that’s less pressing to me :slightly_smiling_face:

I love hill charts and I’ve used them with a number of clients. While the work at Basecamp was certainly inspirational, there are many instances of this data visualization that intersect with the basic concepts. It is truly an appealing visual and when people look at it, they get it immediately, not so much the case with the 1861 version, but certainly with modern versions. Courtesy of Edward Tufte, here’s the first “hill chart” - 1861: I’ve certainly derived original inspiration from other Tufte works and shaped new elements (simplification mostly) by Tufte and the folks at BaseCamp whose engineers describe it like this: Here’s a recent example working in Airtable.

Hello I’ve a database with over than 20K questions sometimes a question has multiple duplicates or (50% similar) I saw a feature in apps that find duplicates which is great my question is that I will add field for each question that will detect any similar record and put it as (link to record) the idea here is to solve my problem, its very hard to find duplicates is that possible ?

I would like a field label to be marked as a required field with a red * - is this possible? I have been trying to use this but can’t get it working. Any tips? Thanks

I tried to get an answer to a couple different things im working on over in the formulas section but didnt get the answer i want so im going to try it here. I am working on a new base that will keep track of fuel used in equipment that i take care of. in one column i have the equipment number, everyday i will be adding a new column to enter the fuel dispensed in each machine that day. The sum at the bottom of that column will let me know the total amount of fuel dispensed for the day but i also need to keep a running total of fuel dispensed for each piece of equipment. My field names will all start with “Fuel” followed by the date… ex (Fuel 1-11-21) , (Fuel 1-12-21) , etc. Creating a formula for this is easy enough if there was only a few fields to add but adding a new field for each day would make that formula long and would require me to go in and modify the formula each day to add the new field to the calculation. Does anyone know how i can do this with a script whe

I have the following code that is looking for the value of a calculated field. But I’m getting an Error: no field matching … let rootTableDat = await rootTable.selectRecordsAsync( { fields: [“Zeiss Planar 80mm 2.8-Prontor CB”] } ); Should this work? Is there a preferred way of doing this? Thanks.

I’m looking for a simple example for updating one or more fields of existing records thru excel vba. I’ve found several example of using GET, a few for POST & PUT, but almost nothing for using PATCH. I really only need to update one field of a record, but many records to update. Thanks,

I have a field for first name and last name where people routinely throw in an extra space after the name so that it will be "john " instead of “john”. I am unfamiliar with js but I would imagine there is an easy script that would trim that last " " off the first name. Help please! David

I’m considering storing information about users in an Airtable table. One of the fields would contain a unique username. From my application, I would like to find the user that corresponds to a given username. I think that the recommended approach would be to retrieve all records with a parameter filterByFormula= {Username}={My ID} as shown here. However, if I’m not mistaken, this would entail Airtable to scan all the rows of the table in order to find this particular record and thus would be very slow for a larger number of rows (O(n) complexity). Is this the case? Can I create an index (as in a relational database) to make such searches faster (O(log n) complexity)?

I’m trying to make monthly reports of a few thousands entries. However my script never stops, and not sure what the mistake is. I’m pretty new to JS and not sure if it’s my loop within a loop that is the problems? let wip, wipOrderView ,tableWIP, queryWIP let cost, costReviewView, costTable, date, customer, garment, switchs, totalFactCost, costTime, estTotalCost, price let currentMonth wip='Work in Progress' wipOrderView='Monthly_order_review' cost = 'Costing' costReviewView = 'Monthly_Overview' date='Date' customer='Customer' garment = 'Garment' switchs = 'Switch' totalFactCost = 'Total fact cost' costTime = 'Time' estTotalCost = 'estTotalCost' price = 'priceScripting' tableWIP = base.getTable(wip).getView(wipOrderView) costTable = base.getTable(cost).getView(costReviewView) /////////////////////////////////////EVERY MONTHLY REVIEW ////////////////////////////////// let everyMonth = async () =>{ output.text(`This will take a

I’m trying to refactor a script that I wrote that is working with a button into a triggered automation. I’m passing the variable “triggeredRecord” using input.config() but for some reason I keep getting the error “TypeError: testRecord.getCellValue is not a function”. I made a test record (testRecord) and I’m getting the same error. What am I missing here? The main goal here is to just keep “triggeredRecord” available so I can target it using “updateRecordAsync”

I’m trying to make a simple repport and wonder if I can make line breaks in a table? I have tried a few different things like: output.table([ {'': 'start', '%':0}, {'': 'Halfway', '%':50}, {'': 'finished\ncompleted' , '%':100}, ] ) output.table([ {'': 'start', '%':0}, {'': 'Halfway', '%':50}, {'': 'Delivered<br>Completed' , '%':100}, ] ) output.table([ {'': 'start', '%':0}, {'': 'Halfway', '%':50}, {'': 'Delivered\nCompleted' , '%':100}, ] ) output.table([ {'': 'start', '%':0}, {'': 'Halfway', '%':50}, {'': ['Delivered', 'Completed'] , '%':100}, ] ) output.table([ {'': 'start', '%':0}, {'': 'Halfway', '%':50}, {'': `Delivered Completed` , '%':100}, ] ) The closest I’ve come to a line break is this:

As in my previous post, and several other posts here about fetch(), I’m not sure how much of this question is: 1) my own coding error; 2) issue with/how the scripting block functions; or 3) a combination of those and more. I’ve gotten simple fetch() calls to work, from examples posted on this forum and in the documentation. I’ve also gotten a call to my desired Vimeo endpoint to partially work (with some restrictions mentioned in the earlier linked post). The following code works (copied and modified from other examples on this forum), and since the example video here isn’t restricted (it’s a random video I picked on Vimeo’s homepage), all the information I need is present (namely: the “duration” field). let url = "https://vimeo.com/api/oembed.json?url=https%3A//vimeo.com/392348731"; let headers = { 'Accept': 'application/json', 'Refe