Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,658 Topics
  • 11,711 Replies
3658 Topics
J
James_BurtonInspiring
posted in Development & APIs
Single Linked Record ID Showing as List Instead of Object

Hi everyone! May be a confusing title but here’s my issue: I am using Airtable API to build in Appgyver. I am trying to use the filterByFormula to pull records with a specific linked ID. However, it was suggested to me in another forum that the reason it’s not working is that the ID is being returned as a list rather than an object (see below): I thought the reason it was showing as a list was because I initially had it to be able to link to multiple records, but then I changed that to single record and it still show up as a list with the brackets. IS the advice I’ve been given correct? And if so, how do I change it to show as an “object” so the filterByFormula can find it?

425
kuovonne
C
Carson_CarrNew Participant
posted in Development & APIs
Failing to load all records on slow WIFI

Long story short, I’m caching hundreds of images before showing users the home screen. This way I’m not calling the records with each click and there’s no delay… The app loads every record, every time on a highspeed connection but on slow WIFI, I’m getting errors or time-outs which causes the content not to fully load. Do I need to add 1 second delays after every 5 records because of the limit per-base? Or is there something else that could cause this? Here’s a screen recording of the app loading successfully. You can see the “image loaded” print strings in white, then I’m logging what has completed in green. Maybe it will help illustrate something I’m doing wrong. Thanks! https://dl.dropboxusercontent.com/s/iwzvocmu42mdzqf/fast_loading_question.mp4?dl=0

10
C
F
Felipe_Torres_TNew Participant
posted in Development & APIs
Using field value as input variable to create multiple entires in linked child table

Hello community! I’m very new to Airtable and colleagues of mine - who are using Airtable very intensively - are using one of the communities’s script automations to create a child table linked to a parent table with a number of entries that is controlled by a “on-run” string-input from the user that originally has triggered the automation by clicking on a button at a given row in the parent table. The script is “Multiple records w/prompt”: What I’m trying to achieve is that, instead of waiting for the manual input from the user during execution to determine how many entries the script should create at the child table, as per line const newRecordCount = hardCoded.newRecordCount ? parseInt(hardCoded.newRecordCount, 10) : parseInt(await input.textAsync(‘Number of records to create’), 10); I would like to use the value of a field (column) that actually contains the number of entires to be created in the child table. More precisely, in the first row of this example: after pressing the bu

92
kuovonne
J
John_BrandiNew Participant
posted in Development & APIs
Cart add with Store

Hi, I’m looking for an app to build an Airtable Web App/Website, where the user can order directly from the application, with an add to cart button and thus a global cart payment. I’m currently using Soft and I’m new to it. There is the ability to add a payment button but the user has to pay for each product separately. Maybe I should create an Automattic table for the orders so that I can calculate the global amount, instead of ordering each product, and thus create a payment button for the global amount. Is there a simpler way to do that? I’m stuck

61
M
Ramagu
RamaguParticipating Frequently
posted in Development & APIs
Existing record in integroma import

I have a table that in addition to other fields has an identification id. This table is automatically populated by a Make scenario (Integromat). Is there any way to configure in Airtable that if the field already exists when Make makes the call it is not created and duplicate the record? Thanks

21
M
R
Ron_WilliamsInspiring
posted in Development & APIs
All records aren’t updating via the iPad app

I am running into an issue where the records that I’m updating with the app on the iPad are not getting updated in the actual base. Let me explain. I use Airtable to inspect products. I have fields for photos, multi select fields, note fields etc. the record already exists in Airtable and I search for it and update it. Sometimes when I update it, the iPad will act like it’s updating everything as I’m doing it but not actually update in the base. I am typically running 4-6 mobile devices in different tables at the same time all working on different records. Does the Airtable app make a api call and is it possible I’m hitting the 5 per second limit? Is there something anyone can recommend trying? Thanks.

10
R
J
Jay_LopezNew Participant
posted in Development & APIs
Pass Variable To Base In URL

Is it possible to pass a variable to a base in the URL? I’m looking to send a URL to a client, embed their Account ID in the URL, and then have them be able to click a URL or button that also includes that Account ID, so it would need to be accessible in formulas and buttons.

171
A
A
AcefastParticipating Frequently
posted in Development & APIs
Oauth2 Intergration XML Post from AT

I have most of my app built in AT and I’m loving it but I have hit a snag. I was using Zapier Dev console to authenticate with Oauth2 with the intention of posting XML but it only allows JSON for some bonkers reason. So that solution has hit the breaks. My feeling is that I no longer want to use a third party connector and will instead use the scripting app to authenticate and then output the XML direct from inside AT itself. If that isn’t possible then I was looking to use Google Sheets/App Script as a go between. I did look at the API solution, Datafetcher but haven’t had a response back by email so not sure it’s there thing. Any advice or devs who can solve this and I’m all ears/yours.

00
A
T
Tyrel_Froese1New Participant
asked in Development & APIs
Button API Script - how to populate self-linked fields?

Hi all, I’ve been using Airtable for a few years and have finally decided to try my hand at writing a few scripts to streamline our workflow. I’ve coded a fair amount before but am new to JavaScript, so please excuse my ignorance. My current project is writing a script that will be called from a button field. This script will make a request to a taxonomic database, retrieve classification data for a single creature, and populate a series of self-linked columns within the table. I have a working script that gathers the data and reformats, but I’m stumbling across the last step of assigning data to the linked fields. Throws this error after the last line: Can’t set cell values: invalid cell value for field ‘kingdom’. Cell value has invalid format: must be an array. Linked records field value must be an array of objects with property ‘id’ corresponding to linked record id. I understand that the issue has to do with needing the data to be formatted as an array for linked fields, but I’m

203
kuovonne
A
appflow_persistNew Participant
posted in Development & APIs
Accessing metadata

Hi everyone, I want to use metadata API to get details of all the bases used in my project. I hit the following API with my auth token- https://api.airtable.com/v0/meta/bases Reponse- {“error”:{“type”:“NOT_FOUND”}} Kindly help and do let me know if something is missing from my end. Thanks in advance!

81
K
Q
Quentin_BNew Participant
posted in Development & APIs
Script: update field of a linked record

Hi community! I’m setting up a script so I can mark order line items as “Delivered” by ticking a checkbox on the order tab. I’ve find a really useful post where a boiler template of code was provided (can’t seem to find it back). // Setup const config = input.config() const ordersQuery = await base.getTable("ORDERS").selectRecordsAsync() const orderLinesTable = base.getTable("ORDER LINE ITEMS") const orderLinesRecords = await orderLinesTable.selectRecordsAsync() const checkedOrder = ordersQuery.getRecord(config.recordID) // Collect linked tasks and find those that aren't checked let orderLines = checkedOrder.getCellValue("ORDER LINE ITEMS") let uncheckedTasks = orderLines.filter(linkObj => !orderLinesRecords.getRecord(linkObj.id).getCellValue("Mark As Delivered")) // Build array of updates let updates = uncheckedTasks.map(linkObj => { return { id: linkObj.id, fields: { "production_status": DELIVERED (PARTYSPACE) ✅ } } }) // Update t

113
Justin_Barrett
B
B_I_SASUNew Participant
posted in Development & APIs
E-Commerce Store with Add to Cart

Hi, I’m looking for an app to build an Airtable Web App/Website, where the user can order directly from the application, with an add to cart button and thus a global cart payment. I’m currently using Softr and I’m new to it. There is the ability to add payment button but the user has to pay for each product separately. Maybe I should create an automattic table for the orders, so that I can calculate the global amount, instead of ordering each product, and thus create an paymetn button for the global amount. Is there a simpler way to do that ? I’m stucked

291
ScottWorld
C
Cameron_Mason1New Participant
asked in Development & APIs
Lookup Record by Field based on Value with Script

I would like to use a scripting automation to check if a record exists. i.e. Does John Doe exist already in the Name column? The results should be simply yes or no. I’m not great at scripting and am looking for some fast track help!

181
Justin_Barrett
M
Matthew_BattenNew Participant
posted in Development & APIs
Use API to copy a base?

Is there a way to duplicate a base with the API?

212
kuovonne
A
Anthony7878New Participant
asked in Development & APIs
maxRecords - clarification

Hello, Given: var Airtable = require('airtable'); var base = new Airtable({apiKey: 'YOUR_API_KEY'}).base('app6wt6DBFn40vPRg'); base('Project List').select({ // Selecting the first 3 records in Master List: maxRecords: 3, view: "Master List" }).eachPage(function page(records, fetchNextPage) { // This function (`page`) will get called for each page of records. records.forEach(function(record) { //do stuff }); fetchNextPage(); }, function done(err) { if (err) { console.error(err); return; } }); How can maxRecords be determined dynamically via an API call? Is this the only way? Get the number of records in a table via API API Yes, a webhook with a script action. Even with a very full table, this will run in about 5s, whereas, an API process might require 15 seconds or more and will slow even more at scale. I tested the following on 37,000 records with 58 fields. I believe that by selecting fields: you are essentially ens

686
A
H
Hemi_PhillipsParticipating Frequently
posted in Development & APIs
Script to copy record contents to overwrite linked record in another table

I have two tables: Member Profile Update Profile Members can submit updates to their profile using a form that goes to the Update Profile table. They pick the member to update when they submit the form, linking the two records. I then review the updates and would like to click a button that runs a script copying the details from Update Profile to overwrite the linked record in Member Profile. Can someone help point me in the right direction for how to script this? I’m particularly lost as to how to read the contents of a specific cell from the current record. Thanks!

00
H
Y
Yana_MazoNew Participant
posted in Development & APIs
Retrieve column names via API

Hi there is there any option to retrieve column names? Something similar to Google Sheets: Method: spreadsheets.values.get if range A1:X1 provided, then column names are returned.

1345
M
K
Kaleb_Penner1New Participant
asked in Development & APIs
Hitting 30 sec script limit... What to change?

As the title says. How would this be written differently to avoid this error? My test environment only had 10 records, tonight was its first scheduled automation run and it grabbed 95 records for this process. // After Club Automations let table = base.getTable(“Children”) let view = table.getView(“Present”); let query = await view.selectRecordsAsync ({ fields:[“Pts this week”, “Spent Today”, “Total Spent”, “Points”, “Attendance”, “Last Club”], sorts: [ {field: “Pts this week”}, ] }); let totes = 0; let today = new Date() for (let record of query.records){ // Multiply 'Pts this week" by 10, add to ‘Points’, Subtract 'Spent Today, write new total to “Points” field totes = 10 * Number(record.getCellValueAsString("Pts this week")); totes = totes + record.getCellValue("Points") - record.getCellValue("Spent Today"); await table.updateRecordAsync(record, {"Points": totes}); // Add ‘Spent today’ to ‘Total Spent’ and clear ‘Spent today value’ totes = record.getCellValue("Spent Today") + recor

244
K
B
Bryony_MilesParticipating Frequently
posted in Development & APIs
Custom Apps - download on different machine

Hi there, Can anyone help me? I have built a custom app for a customer (about 2 years ago) and I am now working on a different computer. I do not have a copy of the files. Is there a way I can download the code if I know the security details?

72
B
M
mdmtrKnown Participant
asked in Development & APIs
Avoiding 'Rendered more hooks than during the previous render' on button-ran application

Hello! I’m writing a custom app to print information from my base on adhesive labels using a Zebra TLP2824 Plus printer, via Zebra Browser print. I’ve written the script below to gather, format and print the required information, but my amateur at best programming knowledge is holding me back a little bit. The functionality I’m going for is the following: once a button in an Airtable view is pressed, labels print for all records linked to a parent record. This works when the app is loaded from the button itself, but if the app loads without the useRecordActionData already loaded, I can’t get it to load without it throwing the following error: Rendered more hooks than during the previous render. Which is obviously right, because I’m accessing more data than requested initially, but I can’t figure out how to work around this! I’d really appreciate some help. Thanks! import {initializeBlock, useBase, useRecords, useRecordById, useRecordActionData} from '@airtable/blocks/ui'; import ZebraB

1320
M
T
Tim_MackeyKnown Participant
posted in Development & APIs
Automations: Script Action Maximum Output Size

The documentation for Script Actions states the following regarding the output API: The output API can currently return a maximum of 6MB of data. There are three ways I can see this being interpreted, and I’m not sure which is correct: Each individual call to output.set() has a 6MB limit Within a single Script Action, multiple calls to output.set() have a cumulative limit of 6MB Within a single Automation with multiple Script Actions, all Script Actions put together have a cumulative limit of 6MB for calls to output.set() Does anyone know which of these is correct?

171
T
S
Stephen_Pugh1New Participant
posted in Development & APIs
Creating records via Python - attachment URLs

Good morning, Airtable Community! I am getting into some Python automation scripts and working with Airtable for the first time (translation: relative n00b all around). I am looking to programmatically create a couple hundred records at a time, and each record has a thumbnail JPEG image that I want to include as a Screenshot attachment. I understand that Airtable requires a URL to the JPEG rather than a path to the local file, but so far all of the cloud storage options that I have at my disposal (well, both - Google Drive and Dropbox) construct a unique URL with a long string of arbitrary characters that I don’t yet have access to in my script. My question - how do you smarter folks accomplish this, is there a scriptable step that I am missing? OR, is there a service or trick that I can use to make a consistent, identifiable URL (i.e. http://somestorage.com/SameNameAsTheLocalFile.jpg")? Thanks for any further insight that any of you can provide! Steve

203
kuovonne
P
Paul_SuurmeijerNew Participant
posted in Development & APIs
Approval Workflow through Slack with a link

Hi there, I’m hoping to get some help with a workflow I’m trying to figure out. I have a base with records that include a checkbox for an approval, as well as a field who approved it, and a last modified time stamp to track when it was approved. So far I’ve been able to base this off an automation that when the Status (drop-down) moves to “Ready for Review”, the Slack message goes out and asks for a review. Now what I’d like to add is a link/button that will allow the person or people receiving the Slack message to click it, and it should then change the checkbox to checked for the approval (and ideally noting who it was; but willing to let that go if it’s too hard). I’ve been reading up on webhooks and similar solutions, but wanted to poll the community what could be a good way to do that. Thanks in advance for any help. Kind regards, Paul.

83
P
D
Devon_StantonParticipating Frequently
posted in Development & APIs
Incoming Webhook Trigger Automation Scripting

Hi, Noob scripter here I’d like to create an automation based on a response from an email, that will trigger an update on my airtable. This is how I want the flow to work. Based on a status I send an email that contains a link for the receiver to click once a job is completed. this link is the webhook I generated via the airtable script. once clicked this webhook updates the status of the airtable record. After doing a lot of reading on the webhook I now understand that you need to create a POST request with an object (excuse my lack of knowledge I’m very noob at scripting) or payload for the webhook to deliver. This has raised a few questions for me. How do I script the payload to be inserted into this webhook for the user. i.e. {"record": Record_ID, "status": "accepted"} Are webhooks unique? because I’ll be sending out unique webhooks and I worry that the URL changes to the last updated record id. Is my logic on the right track with this?

104
ScottWorld
T
Tim_MackeyKnown Participant
posted in Development & APIs
Using compression to store up to 10x the normal amount of data in a cell

I recently came up with a useful tool for my Airtable toolkit, and I thought I would share it in case others may find useful. On a recent project, I needed to transform a large amount of data into a JSON object for use by external applications. Unfortunately, I quickly ran up against Airtable’s 100,000 character limit on text fields. It occurred to me that if I could find a way to compress the JSON data, I could fit more data into a cell and wouldn’t have to worry about the character limit. There are a handful of javascript libraries out there for text compression, but what I settled on using is the lz-string.js library. It is based on LZW compression, and was designed for use on mobile browsers, meaning that it is fast, and optimized enough to use in Airtable Automations without going over the CPU time caps. Due to its repetitive nature, JSON data compresses very well—results will vary depending on the structure of your data, but with my current data I’m able to fit the equivalent of

414
T

Badge winners

Show all badges
Terms & Conditions