Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,658 Topics
  • 11,710 Replies
3658 Topics
Sergei_RasKar
Sergei_RasKarKnown Participant
asked in Development & APIs
Airtable SDK: how to output to console? (with console.log())

I’m coding AT SDK extensions using Visual Studio Code, and most likely I’m missing something but I can’t output to console with console.log() function. There is no output on VSC terminal, debug console or output. I’ve tried running in debug mode, nothing changes. There is also a button “Log component to console” - a small bug icon - on the app editor interface, but clicking it seems to change nothing Thanks ahead for help!

400
Sergei_RasKar
A
Amber1003New Participant
posted in Development & APIs
Script Automation for Creating New Records & Numbering Them

Hello fellow Airtable peeps! Let me start by detailing what I need out of this script I’m trying to make, then I’ll give ya’ll the two scripts I have been using that I’m trying to replace. What I Need In Table 1, I have a field where I input the amount (i.e. “6” or “10”). In Table 2, I want this number to be translated into that number of records and I need them to be numbered. Here’s an example: Table 1: Table 2: What I Have I’m currently using two scripts to accomplish this goal on the second table, but not only does it require two scripts, but if I turn them both on at the same time it will expand the records forever (first script will expand any number that isn’t 1 and change their number to 1, and the second script will just keep changing the numbers, so it just keeps creating records). So, basically, I’ve been turning each one on individually to avoid the eternal expansion. I searched the forums far and wide just to find these two scripts, but they’re just not quite what I need

291
A
Sergei_RasKar
Sergei_RasKarKnown Participant
asked in Development & APIs
How to edit my existing extension

I looked everywhere but don’t seem to find how to edit my custom extension I’ve released. I only see instructions how to create a new extension from scratch… I can’t find a list of my extensions as well. Please help!

230
Sergei_RasKar
K
kennypurnomoKnown Participant
posted in Development & APIs
How to "skip" changes in PATCH http request for update a record?

I have a body like this { “records”: [ { “id”: “reccsfBOAsOX5nigv”, “fields”: { “test”: 123 } } ] } How can i skip the “test” (currency type) field? The idea is that i have a condition that shall be met. If not, then do not change the “test” field. Thank you

31
kuovonne
H
Harry_McDonaldKnown Participant
posted in Development & APIs
Create number of records in 1 table based on Qty Field in another table

Hey there, I’m hoping someone will be able to help (my scripting ability is limited) - I want to be able to create a specific number of records in Table 2 based on the Qty field in Table 1. I have a script which creates a singular record in Table 2 from the data in Table 1 but does not consider the QTY field and creates the X number of rows. Would anyone be willing to help please? Thanks in advance

182
H
J
Jose_CKnown Participant
posted in Development & APIs
Calendarific and airtable

Hi all, i am trying to build a table for holidays via caledarific API. this is the part of response from json { “meta”: { “code”: 200 }, “response”: { “holidays”: [ { “name”: “New Year’s Day”, “description”: “New Year’s Day is the first day of the year, or January 1, in the Gregorian calendar.”, “country”: { “id”: “es”, “name”: “Spain” }, “date”: { “iso”: “2022-01-01”, “datetime”: { “year”: 2022, “month”: 1, “day”: 1 } }, “type”: [ “National holiday” ], “urlid”: “spain/new-year-day”, “locations”: “All”, “states”: “All” }, { “name”: “Reconquest Day”, “description”: “Reconquest Day is a provincial holiday in Spain”, “country”: { “id”: “es”, “name”: “Spain” }, “date”: { “iso”: “2022-01-02”, “datetime”: { “year”: 2022, “month”: 1, “day”: 2 } }, “type”: [ “Local holiday” ], “urlid”: “spain/reconquest-day”, “locations”: “GR”, “states”: [ { “id”: 324, “abbrev”: “GR”, “name”: “Granada”, “exception”: null, “iso”: “es-gr” } ] }, So , i am trying to fetch data in a “Vaciones table” without succ

30
J
N
Nguyen_Son_TungNew Participant
posted in Development & APIs
Handle click event in Gantt view

I am developing an extension that handle “row changed” by using cursor selectedRecordIds as follow: useWatchable(cursor, [‘selectedRecordIds’]) But the event doesn’t fire in Gantt view mode. Is there any other way to work with Gantt view? Thanks

10
N
Karlstens
KarlstensBrainy
posted in Development & APIs
Retrieving Linked Records via API

Hey all, Question for those with API experience. As linked records return the RecordID, do you typically create a Rollup Column to display and retreive the Linked Record name data, or, do you code the solution in your source to retreive the name of each record? Simple two table base layout - an active score board; And registered users; My example code below, heavily influenced by the current Airtable API code samples - when retrieving the ScoreBoard, how best to show the Linked User names? Although I’m yet to refine my find() code block, already I can see that returned names aren’t in any particular order, as opposed to the Player Name Rollup at least being the correct order. So in summary, do you tend to code solutions in the base, or solutions in the API source when working with Linked Records? I can see advantages of knowing and understanding both. Sample code below; const Airtable = require('airtable'); const base = new Airtable({apiKey: apiKey}).base(myBase); base('Score').se

3299
kuovonne
S
Scott_MullinInspiring
asked in Development & APIs
Reading formula result as string

Hello, I believe this is simple, but I don’t understand what syntax is needed. I’m trying to read the results of a single-select field as a string. I’m doing a running total calculation, but resetting it whenever a certain reading is found. The running total part was working, but I can’t figure out how to get the single select output as a string. When I run this, I get: typeof respGroup.records[0] returns “Object” output.text(typeof respGroup.records[0].getCellValueAsString) returns “Function” let table = base.getTable(‘Prints’); let view = table.getView(‘MTBF layout’); let respGroup = await view.selectRecordsAsync({fields: [‘NDD - Responsible Group’]}); //NDD - Responsible Group must be manually filled out! let elapsedTime = await view.selectRecordsAsync({fields: [‘NDD - Elapsed print time’]}); //NDD - Elapsed print time is a calculated field let groupRecords = respGroup.records; //trying to understand how to get the group records into a string format output.text(typeof respGroup.re

878
S
R
Ronen_BabayoffInspiring
posted in Development & APIs
Please don't depreciate cursor and session

Hey there, The state management and reactivity of all of our airtable apps is based on mobx and mobx-react-lite and not on hooks. This allows use to write code that is object oriented and therefore cleaner, more robust and faster and easier to develop and maintain (at least for us). We specifically wrapped your cursor and session objects as mobx based classes and are observing changes by calling the watch methods of those objects and updating class members that are mobx observables. I saw here that you plan to deprecate the cursor and session objects. Please don’t and allow people to decide which state management paradigm and library to use and don’t force them to use react hooks. Thanks

51
S
H
Hendrik_YangInspiring
posted in Development & APIs
Dynamically filter the last record based on the view/grouping

Hi Guys, Previously I was using filtered.pop (thanks to @Alexey_Gusev) to find the last record that has no amount let filtered=(result.records.filter(item => item.getCellValue('Cumulative by Customer') > 0)); let last=filtered.pop(); However when I am adding more data, let’s say different customers, it’s not dynamically filtering those data. The amount $12,203.50 below is based on last amount of $10,253.5 above (they are different customers). It’s supposed to take the last amount of $22,776 instead Is it advisable to build custom index of the data or is there any better method to calculate cumulative sales amount by customer? Thank you.

73
H
A
Andrew_HaegNew Participant
posted in Development & APIs
Creating clickable / interactive interfaces using Airtable Interface Designer

Greetings! We use Airtable to (among many other things) create reports from surveys that we’d like to be interactive, such that if someone clicks on a bar chart, they’ll be able to explore the records associated with a certain bar. e.g. If someone clicks on the bar representing the number of 30-39 year olds who answered a question a certain way, they’d be able to click on that bar, and see their responses in another pane. So far as I can tell, there’s no way to do this in Interface Designer. Is there another way within Airtable? Or would we need to use another platform? Thanks!

471
Kamille_Parks11
L
Lisa_BauerInspiring
posted in Development & APIs
Is this even possible?! Scripting help - identifying when a designer becomes available and for how long

Hello fellow Airtablers! (maybe there’s a better name…?) I staff designers onto projects and I want to create a “Supply Grid” where it shows when a designer is next available, for how long (# of weeks) and what they are off to next after those weeks. Something like this: Many thanks to help from @Mike_Pennisi and @Alexey_Gusev (thank you both!) I was able to create records that help indicate when a designer is available each week (labeled “Open Space”). So essentially, my Airtable Table looks kind of like this (a much simplified version): Where I Need Your Help: Using this data, I want to automatically create the “Supply Grid” (Right now i’m doing this all manually). I’m imaging the steps being something like: From the list of open space records for each designer, identify the open space record with the earliest start date and have that be the “Available Starting” date for the Supply Grid for that designer Identify the # of open space records in a row until it hits a record that’

00
L
L
Lisa_BauerInspiring
posted in Development & APIs
How to create script (or automation) that creates multiple linked records for different date ranges

I have been helped by so many of your community posts, thought I’d post one of my own for a problem I’ve been trying to solve. I use Airtable as a resource management tool to staff designers onto projects. However, I want to also quickly pull data on who is on “open space” (not on a project) each week. (I’m often trying to answer the question "who’s available the week of i.e. 9/5?) My Airtable base is set up with the following tables and links: Designers Table: holds all of our designers Projects Table: holds all of our projects (that designers need to be staffed on) Availability Table: created via linked records between Designers and Projects Unless there’s a simple way I’m completely missing, here’s the work around scenarios I’ve come up with: Create a record for each week that’s labeled “Open Space” and set an automation for that record to be deleted if another record (a project record for a designer) overlaps with any of the open space records. That way I can set the filter to sh

364
L
Jake_Wilson
Jake_WilsonInspiring
posted in Development & APIs
Airtable Custom Extension developer needed

Hello, I have a few custom scripts for my base that I would like to be abstracted from other base collaborators so that they can’t see or edit the code. I would like to have these custom scripts moved into a custom extension with a simple UI. Please email me with your calendar / availability at jake@wholescalingsystems.com I’m ready to hire and will have lots of ongoing projects!

10
Jake_Wilson
J
Jose_CKnown Participant
asked in Development & APIs
I need help with a linked fields problem

Hi all, I have a problem with a project i am carrying out. I have a table A. with a X record which is linked to a field Y in table B and field Z in table C. After I have a table D. This records are linked to a field in table A. So , records in table D , are linked indirectly to table B and C. Now i have a table E, which is an input record to control hours. When I add a record with a field linked to table D, I can add a field with a lookup function, to show the linked field in table A. My problem is that i need to fill automatically as well, fields Y and Z which are linked to field in table A. Some idea how to perform this task? Many thanks in advance

1810
M
Pete_Lindley
Pete_LindleyParticipating Frequently
posted in Development & APIs
Number 1 Feature Request

The number 1 ongoing feature request from the community seems to be the wrapping and customisation of the header row. Looks like it’s been around since September 2016 and still not actioned. Any other feature requests that beat that one?

161
B
J
Jane_ZurbruggNew Participant
posted in Development & APIs
Conditional updating of a single select field in another table (not base)

Hello! I am trying to create an automation that updates a single select field based on the input in another table of the same base. I tried the “when a record matches condition” automation but it didn’t work as it only lets me update records from the same table. I thought that maybe it would work with a script but as I don’t know how to code I’m having a hard time. Any help is highly appreciated!

32
Alexey_Gusev
Y
Yuval_Yossefy1New Participant
posted in Development & APIs
Script to copy record names in a view to update multiselect field options

I have a base with two tables. The first has a list of events, and the second is an RSVP form for attendees to sign up to these events. The events are constantly happening and changing, and I’d like to show the events as a multiselect in the RSVP form (which linked fields don’t let you do). Can someone write a script that would pull the event names from a specific view in table 1, and then update the multiselect field options in table 2 to show those exact event names? The field options would be replaced completely each time it runs, which I expect to be daily.

10
Y
M
Musaab_RNew Participant
posted in Development & APIs
Sync Firebase Users to airtable (Real time sync)

Hi there I use firebase for all my projects but its hard for me to manage content and users So am working on custom extension to sync users (first) so you could easily manage them (disable, delete , rest user account) Airtable Grid view - Airtable Explore the "Grid" view on Airtable.

10
M
J
Joshua_CohenNew Participant
posted in Development & APIs
Iterate through field for '!' string, then iterate through another field to collect cells that had '!' in their records, in an array

Hi everyone, I have some coding experience, although by knowledge of Javascript is still very limited. What I’m essentially trying to do is: Iterate through one field for a certain string Collect name (or ID I suppose) of the record that had the string in an array The point of doing this would be to be able to compile the names of all the records that had the targeted string into a list that I could then email out through a build in automation. Unfortunately Airtable makes it difficult to send multiple records on a single automation, so I was wondering if I could do it this way. Thanks.

162
Alexey_Gusev
J
Josh_KurzNew Participant
posted in Development & APIs
Using a Script to Create a record in another base

Question for the community: is it possible to write a script that creates a new record in a table from a different base? Basically I would like to create a button in a few different tables from various bases that, when triggered, runs a script that creates a new record in a table (with some specific fields copied over) in a separate base. Is something like this possible in Airtable? Thanks! -Josh

709
Alexey_Gusev
Alex_N
Alex_NInspiring
posted in Development & APIs
Attachment Field Changes and API

Will file URL’s captured by API be affected by the planned November changes to the Attachment field? Currently I have a Bubble.io app that gets a file’s URL by API. I don’t store a static URL to the files in the attachment field but I do use Bubble’s Get external data from an API feature to get the record’s Attachment URL. Since this API call is made every time a user loads this specific page in the app, my understanding is that a new URL is captured on every load of the page. This would mean that a new URL good for 2 hours will be captured on every API call. Is this correct? I am trying to figure out how much this planned change will affect my app but I can’t find any information specific to the use of the Attachment field by API.

70
Alex_N
J
Joachim_BrindeaInspiring
posted in Development & APIs
Find and replace script with content of other fields

Hello, @Joris_Grouillet made me this script to search for {tag} and replace by the tag column. Am in urgent need of some changes but don’t want to be too much of a burden so I ask here. Could someone please help me modify the script so that: It replaces every occurence of a match in a cell (e.g. if there is {name} twice in a cell, it replaces both and not just the first it finds) It searches for tags in […] rather than {…} it searches and replace in place rather than in an additional field. (i.e. it uses the same field for template and destination) If possible, it is dynamic and uses regex to find any tag in […] and replace it with the matching column. I urgently need the first enhancement, the rest are more for the convenience of my workflow. Here is the script: (async ({ record_id }) => { async function getClientById(recordId, clientsTable){ const queryResult = await clientsTable.selectRecordsAsync({ fields: ['nom', 'code', 'ville', 'templat

104
J
R
Ronen_BabayoffInspiring
posted in Development & APIs
BUG - can't load record into app from button in expanded record

Hey, This used to work and stopped. Tried it with a new app and button too. Whenever I click an open app button when the record is expanded, it seems that the window message with the record id is not delivered to the app. I get the following error in the console: Failed to execute 'postMessage' on 'DOMWindow': The target origin provided ('https://block--t-qtk-d2-z-an-c-dz-kv--b3r294g.alt.airtableblocks.com') does not match the recipient window's origin ('https://airtable.com'). The app DOES open in the extensions dashboard when clicking an app open button from the grid view.

112
R

Badge winners

Show all badges
Terms & Conditions