Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,656 Topics
  • 11,709 Replies
3656 Topics
J
Joe_PinoNew Participant
posted in Development & APIs
Script that when triggered, Automatically presses other buttons in the table

Dear Airtable Community, Seems as though the tenacity here never fails and I wanted to get some help on something I think a lot of people would take advantage of. Is it possible to write a script, either on Airtable or maybe with even another tool, that automatically presses other buttons in a table for all existing records? The buttons I want to be automatically pressed are all Zapier Webhook automations relative to each specific record, but I may need up to 200 of these buttons pressed at once and am looking for the best automated solution. Thank you to anyone who can offer some guidance!

53
B
J
Jac_EvansKnown Participant
asked in Development & APIs
Converting a date to a readable format in a script

Hi, I am reading a date from a field and want to include it in an email (as part of an automation). How do I go about converting the date that looks like this “2021-02-10t11:30:00.000z” into something like this - 10/02/2021 11:30am (or similar)? Thanks!

862
J
J
Jeff_MooreNew Participant
posted in Development & APIs
Searching a Table to retrieve Multiple Records for an update using the API

I am working on putting together a “sync” with another system to our airtable base. Basically i want to be able to pull a GET request on a members table on the field “CRM AGENT ID” and it find all the records with the matching ID’s. for example. I check a CRM system and find these agent ID’s: 3, 60, 67, 30. I then want to find those ID’s corresponding airtable records with a GET request. Then update all of those records with a PUT. Where i’m running into issues is the URL having the right search formula to search the field for all the agent ideas and return them all. Hard to explain, but how can i do this?

52
B
J
Jac_EvansKnown Participant
posted in Development & APIs
Looking up records with IDs

Hi, I have a few tables and i want to trigger an automation when a record is added in table 4 but go up the tables to get a value from table 1. Houses > Rooms > Items > Reciepts (best example I can think of!) When a new reciept is added I want to send an email to say here is a reciept which was added to item X in room Y at house Z. The new reciept has an Item ID in it but that field is an array of item IDs, so at the moment I have my input variable set as: let itemID = input.config().ItemID[0] Is that the right way to do this? Next I want to go into rooms and find the room linked to that item, but again the linked field is an array which is confusing me! Would love some help, Thanks!

00
J
Fred_Zhao
Fred_ZhaoEmployee
posted in Development & APIs
New: tighter security and network access option for marketplace apps

Hi everyone! As part of making Airtable apps safer for our customers, we’re rolling out tighter security restrictions for our marketplace apps, along with a network access option for Enterprise administrators. Apps are a powerful way to extend Airtable that gives superpowers to teams and companies of all sizes. We’re continually looking to make apps more secure and transparent to users, so we’re taking the first step to tighten app security and give users more visibility over how apps access their data. Our hope is that this long-term commitment to security and transparency will make Airtable a more valuable platform for developers and users alike. On February 10, 2021, we’ll start to enforce several browser-based security settings for any apps installed from the marketplace, including existing apps already installed in bases. The enforcement uses Content Security Policy headers (CSP), which are an industry-established standard for browser security. As part of this enforcement, we’ll u

520
Fred_Zhao
S
StevenB11New Participant
posted in Development & APIs
Help Creating a Script to Populate a Junction Table with Linked Records

Hello. I’m trying to write a script that loops through all of the records in the table MyTable1, and for each record in MyTable1 loops through all of the records in table MyTable2, and at each iteration checks to see if table MyTable3 contains a record where Field1 is a link to the current iteration’s record in MyTable1 and where Field2 is a link to the current iteration’s record in MyTable2. I’m essentially trying to automate populating a junction table where MyTable3 contains every possible combonation of linked records from MyTable1 and MyTable2. There’s a great example of how to something similar in another thread (Automatically Populate Junction Tables!), but it wasn’t quite what I was looking for. The script I’ve written so far is below. I wrote as comments the steps of the script that I’m unsure which functions to use to accomplish that step, and was hoping that someone might be able to help me out with this. Thanks in advance! let tableMyTable1 = base.getTable("MyTable1") let q

212
D
J
Jean-Philippe_EKnown Participant
posted in Development & APIs
Description App for field's rows

Hello, I’m using a Database to organize ideas in a Kanban view. My ideas contains a Rich Texfield to store notes, and things todo, etc … I’m wondering if there is an app working like Description App but to edit the field of one of my idea. Like a Note Taking App because the tiny popup/modal editor is not very handy …

172
ScottWorld
S
Sticker_ninjaInspiring
asked in Development & APIs
Accessing attachment thumbnail URL from record value

I’m building a custom app and need to show an attachment’s thumbnail image as part of an info card. When I enter <div>{record.getCellValue("Attachment field")}</div> to view the cell values, I get the following error: Error: Objects are not valid as a React child (found: object with keys {linkedRecordId, value}). If you meant to render a collection of children, use an array instead. I’ve tried adding record.getCellValue("Attachment field").fields.url but it comes up as undefined. I’ve also tried {record.map(value => {value.url})} to try access the object’s properties but map is not a function of record. How can I access the thumbnail’s URL?

110
Kamille_Parks11
V
Vova_KNew Participant
posted in Development & APIs
How can I add static resources in my app

I want to have a folder in my app with some static assets. How can I access it and use as images in html?

00
V
A
Abraham_BochnerKnown Participant
posted in Development & APIs
Script Request: Delete records from A Table & View

Looking to Delete records in batches base on a Table View Does someone have a script for it?

21
A
S
Stevan_PopovicParticipating Frequently
asked in Development & APIs
Can't write multiple records from custom app

I am trying to write multiple new records to a table. The docs suggest doing this like so: table.createRecordsAsync([{'My field name': '1'}, {'My field name': '2'}, {'My field name': '3'}]); In my code I have the following test: table.createRecordsAsync([{ 'Name': "Dave"}, { 'Name': "Sam"}]) But I get the below error: invalid record format. please define field mappings using 'fields' key for each record definition object As a check, I also attempted to write a single row, like so: table.createRecordAsync({ 'Name': "Dave"}) And this worked fine. I also attempted this: table.createRecordsAsync([{ 'Name': "Dave"}]) And I got the same error as before. So it seems to be something about the createRecordsAsync method and passing an array. Any ideas?

50
S
D
David_RoulinKnown Participant
posted in Development & APIs
"Log-in with Airtable" feature request (Airtable Sign-in)

I’d love for Airtable to provide a sign-in service, delivering oAuth authorization tokens, allowing us developers to create apps that would be able to read and write data to our users’ own Airtable accounts. For security reasons the permissions of such third-party apps should be limited to a specific workspace, base or table.

21
D
D
David_PrattenNew Participant
asked in Development & APIs
Default value not always applied

Hi, Couldn’t find the bug posting forum so I am posting here. If there is a better place, please let me know. When adding a record by clicking on “+ Link to a record from …” defaults are not applied to columns in the added record. Is this behaviour by design? David

120
D
A
Alexandre_AirvaNew Participant
posted in Development & APIs
Airtable API configurable

Love Airtable but feel frustrated by the API. At Blobr we developed an interface to share and manage easily the Airtable API. You can find it here: blobr.io Share and manage the content of your Airtable API Blobr is the no-code solution to turn your APIs into products It solves many issues we had like having not only one API key but several, be able to manage how we share the content and the business rules to do so. Hope you enjoy it.

20
A
Kamille_Parks11
Kamille_Parks11Brainy
asked in Development & APIs
Request to open-source the Batch Update App, or the component it uses for select fields

As far as I can tell, the Batch Update app uses the React Select library to handle input components for single-select and multi-select fields (both “regular” and “collaborator” types). Can the source code for the Batch Update app be made public so other developers can replicate the appearance already used in a “standard” Airtable app? As it stands, the Select component provided in the Airtable SDK isn’t quite sufficient for multiselect fields.

30
Kamille_Parks11
C
Connor_CashNew Participant
posted in Development & APIs
String not readable for 'includes' when filtering a

Hi All - new here and a bit of a novice developer but trying to automate a simple creation of new records in one table when a new record is created in another table. I’ve been trying to mimic a bit of the parent /template script example but my filter function wont read my input variable that is part of the automation. let listTable = base.getTable('List of Metrics'); let importQuery = await listTable.selectRecordsAsync(); let importRecords = importQuery.records; let metricsTable = base.getTable('Metrics'); let inputConfig = input.config(); let companySector = inputConfig.companySector; let imports = importRecords.map(c => ({ 'Sector': c.getCellValue('Sector'), 'Stage': c.getCellValue('Stage'), 'Name': c.getCellValue('Name'), })).filter(x => x.Sector.includes(companySector)) I’m trying to filter the imports by sector, but an error I’m getting is that since companySector is a string it is not compatible and reads as null. Feel like I’m missing something simple, thanks

21
JonathanBowen
F
fintableKnown Participant
posted in Development & APIs
When doing batch writes, what if some records fail, and some succeed?

When writing multiple rows with the Airtable API, what if some records fail (e.g. due to invalid fields) and some succeed? Does the whole call fail, or just API just return the record IDs that succeeded? I can test this myself, but for the sake of time I wish this was included in the API docs.

10
F
M
Mateusz_KobosNew Participant
posted in Development & APIs
How fast is searching for a specific value in a field (column)? Results of a test

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

233
F
N
Neal_PatNew Participant
posted in Development & APIs
How do I build a daily sales calculation based on previous day?

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?

71
F
A
Angel_BaenaKnown Participant
asked in Development & APIs
Selecting a record after pressing button

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

111
JonathanBowen
J
John_LongNew Participant
posted in Development & APIs
Newbie Help : Update Field by Script

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 10 trainin

20
J
Michal_Lew
Michal_LewNew Participant
posted in Development & APIs
Get record clickable link with ID and Base API

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

535
Kamille_Parks11
G
Gabriela_CastilNew Participant
posted in Development & APIs
Account not upgrade

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!

11
B
A
Abraham_BochnerKnown Participant
posted in Development & APIs
Bulk Delete with Integromat

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?

34
A
E
ezeikelNew Participant
posted in Development & APIs
Populating linked records

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?

10
E

Badge winners

  • Welcome
    Dwalz3has earned the badge Welcome
  • Certified Airtable Admin
    nitinjainhas earned the badge Certified Airtable Admin
  • Certified Airtable Admin
    CaitlenBerghas earned the badge Certified Airtable Admin
  • Certified AI App Builder
    stagandforgehas earned the badge Certified AI App Builder
  • Certified Airtable Builder
    stagandforgehas earned the badge Certified Airtable Builder
Show all badges
Terms & Conditions