Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,657 Topics
  • 11,711 Replies
3657 Topics
M
Mallory_PriceNew Participant
posted in Development & APIs
Referencing Field IDs using the API for Code Maintainability

Hi all, I’ve read up in this forum on how to see the Field IDs for the fields in my table. However, I’m struggling with how to to actually use the API to reference those field IDs. Using Python, I’m able to grab the record through the API and convert the data to JSON. I then assign a field in the record to a variable: json_variable = json_data['fields']['Name'] However, after trying some different variations of this, I can’t seem to figure out how to access the field ‘Name’ just by using its field ID. Can anyone help with this? The motivation behind this is to avoid hard-coding Field Names so we can change them in Airtable without the program breaking. Thank you!

347
D
V
Vadim_Ciobanu1New Participant
asked in Development & APIs
Using a variable for field name in updateRecordAsync method

Hi there! I’m not a developer but I trying to write a script. Please tell me if is possible to use a variable to define the field name inside updateRecordAsync method. await table.updateRecordAsync(record, {"Phone": value}) the method accepts variables for “record” and for field “value” but I want to use a variable for “Phone” (without quote marks) like the example below: let fieldName = "Phone"; await table.updateRecordAsync(record, {fieldName: value}); I want to let users set up fieldName using input.config Please help. :pray:

192
V
J
Jeremy_OglesbyInspiring
posted in Development & APIs
Create Single-Select / Multi-Select Field Options from Script

I’m guessing the answer is no, but is it possible to add a new option to a Single-Select or Multi-Select field programmatically from a script? At first I tried to just brute force it - I tried to enter a string value for the Single-Select field via table.updateRecordAsync(). This is a way we can add new options via the main UI, although the UI presents a context menu for doing so. Next, I tried to see if I could push() a new value into table.getField("Single-Select Field").options.choices but the API returns the options as immutable, since it’s a get[***]() function: Any way to do this, or any plans to support it in the future?

11214
kuovonne
A
Airtable_admin11Participating Frequently
posted in Development & APIs
"Error: Field cannot accept the provided value" for creating & linking new records

Hi all, I’m new to scripting in Airtable and I got a bit confused about my error. I’m using two variables for the script projectID which is the ID of the project that is linked to the test record linkedIndicatorIDs which are the IDs of all the indicators that are linked to the test record When I run this script it gives an error “Error: Field XXX cannot accept the provided value.” for the project field although via the console.log I see that the correct projectID is being used. I don’t really understand why it doesn’t work for linking the project if it does work for the indicator (I tested succesfully the script without the project linking). let inputConfig = input.config(); let table = base.getTable('Progress General Indicator 🚫'); let indicators = inputConfig.linkedIndicatorIDs; let projectID = inputConfig.projectID; for (let indicator of indicators) { console.log(`Adding indicator ${indicator} to the new record.`); console.log(`Adding project ${projectID} to the new

3667
B
S
Sean_WilsonInspiring
asked in Development & APIs
A formula for running total based on LINKED records

Hi everyone. We all know the script in the airtable scripting examples to create a running total. The script below is as such: // change these names to pick a view: let table = base.getTable('Marketing'); let view = table.getView('Grid view'); let result = await view.selectRecordsAsync(); let runningTotal = 0; for (let record of result.records) { // change the field names here to adapt this script to your base runningTotal += record.getCellValue('Amount'); await table.updateRecordAsync(record, { 'Running Total': runningTotal, }); } The issue with the script is that it takes the running total from the previous row and adds the number of the current row to create the running total for the current row. I was wondering if there was a way to filter based on linked records. That is: for the current record, you only add the current number to the sum of running totals of linked records. Would anyone know how to do this?

3216
H
Zack_S
Zack_SInspiring
asked in Development & APIs
Error with Post request to Notion API

Trying to make a post request to Notion to create a new page. Receiving an Error 400 Bad Request and can’t find the issue. Here’s the documentation - Create a page and script below let payload = { 'parent': { "type": "page_id", "page_id": "my page id" }, 'properties': { "Name": { "type": "title", "title": [{ "type": "text", "text": { "content": "My Page Title" } }] } } }; let response = await remoteFetchAsync(postUrl, { method: 'POST', body: JSON.stringify(payload), headers: { 'Notion-Version': '2022-06-28', 'Content-Type': 'application/json', 'Authorization': `Bearer ${apiKey}`, }, }); output.text('**POST RESPONSE**' + ' - ' + response.status)

18710
Justin_Barrett
T
Ted_Charles_BroNew Participant
posted in Development & APIs
Script to trigger Button / Page Designer

Hello everyone! I am looking for help in regards to either; A script that triggers a button, or A script that can trigger the equivalent of “Open in Page Designer” action in the button dialogue. Also, is there a way to disable the sidebar popup that appears after a script is used? Any help or leads appreciated, thanks all!

135
T
S
Steve_Schrader1New Participant
posted in Development & APIs
Creating a linked field with Scriptin

I am trying to create a field which links a table to itself: //Now that the table has been created add the linked field var newFamily = base.getTable( familyName ); var linkOptions = { linkedTableId: newFamily.id, prefersSingleRecordLink: true, isReversed: false, }; await newFamily.createFieldAsync( ‘SpouseLink’, ‘multipleRecordLinks’, linkOptions ); I am getting an error: j: Can’t create field: invalid field config. Failed schema validation: prefersSingleRecordLink is not included in the .options schema, isReversed is not included in the .options schema I am confused because I have include those fields in the schema …

52
S
B
B111New Participant
posted in Development & APIs
Is anyone else seeing MANY unresolved blocks-cli error threads?

Good-natured vent: it seems like most of the issues I research in this community are closed/auto-resolved despite no clear solution. Case in point: there is a years-long issue with node version controls interfering with blocks-cli install. If anyone is interested, after hours of research, I found this link to be the only solution that helped me: TecAdmin – 24 Nov 20 How To Install NVM on macOS with Homebrew The NVM (Node Version Manager) is a shell script used for installing and managing Node.js on a Linux-based system. The macOS users can install NVM using the homebrew. This tutorial helps you to install NVM on your macOS system and manage Node.js... Est. reading time: 2 minutes

00
B
A
Ariana_GarbersNew Participant
asked in Development & APIs
Run script only on new records

Hello! I am using the covert url to attachments extension and I’d like to run it every time I do an upload via csv, but only have it go through the newly uploaded records. Right now it does give the option to skip fields that already have attachments in them which is nice, but I have about 30,000 records and a decent amount of them don’t have urls to convert in the first place so it takes a while. Is there a way to only run a script based off a view or conditions? I’m not familiar with JavaScript, but I feel like there should be a way. I’ve attached a screenshot of the extension script, any help is appreciated - thank you!

192
D
R
RaphaNew Participant
asked in Development & APIs
Identify the record associated to a button used to open a custom extension

Hello, I’m trying to develop a custom extension, but I’m facing an issue. I’ve defined a button associated with action “Open Custom Extension” that points to my custom extension. However in both case, I’m unable to retrieve the recordId of the line of the clicked button: When extension panel is closed When extension panel is opened I’m trying to retrieve the “selectedRecordIds” but upon a button click, it remains empty… Is it possible to retrieve this? Is it possible for the custom extension, that the source event is a click on a button? Thanks, Raphael

210
kuovonne
M
Matt_BeyerNew Participant
posted in Development & APIs
Link/download from NAS

I have a list of “Jobs” in Airtable, and a corresponding list of Files in a NAS drive, which have the “Job number” field from Airtable in their filename. So it’s easily filterable by just looking for files with that “Job number” in their filename. I would like to attach a script to a button that would automate that process. Basically, filter and download the files from the NAS when the user clicks the button. Is there someone who can point me in the right direction here?

364
M
A
Ahmet_KaragozNew Participant
posted in Development & APIs
Extension Limit

10 extensions per base on the Pro plan! Do you really think 10 is enough for each base? I can unlimited things but when it comes to make them readable understandable with extensions Dashboard I have limit even in Pro Plan. Enterprise edition is not a solution because we don’t need to be an enterprise to summarize our base data. What does the community think about this? Regards and thanks,

2510
ScottWorld
S
SyncWith_IntegrNew Participant
asked in Development & APIs
Are Airtable integrations still being reviewed?

Hi forum! Can anyone from the community let me know if their Airtable integration was reviewed after submitting it? We’re getting radio silence recently – just want to understand the timelines so we can plan our developer resources for this quarter. Our timeline so far: April 17: Submitted an app May 9: emailed marketplace-submissions@airtable.com asking for an update May 12: got an email from Albrey asking for changes to the integration May 16: made the changes, resubmitted, emailed to confirm changes were made June 6: emailed asking if there was an update June 16: emailed asking if there was an update June 27: emailed asking if there was an update Airtable Blocks SDK talks about a 2 week turnaround time, but it’s now been almost two months since we last heard from Airtable. Once an integration is approved, is there a similarly long turnaround time for any changes to the integration? I’d hate to be telling a customer that it’ll take 2+ months to respond to bug reports. :frowning:

80
S
R
RSkInspiring
posted in Development & APIs
The attachment link fetched using Airtable REST API doesn't work

Hi, I am developing an MS Teams bot using Node.js and Airtable REST API, the bot fetches the information from Airtable and sends it to the MS team’s bot. I’m facing a problem when sending the video attachments. This is the code that I use to fetch the attachment record: const records = await base(table_name).select({ view: "Grid view", }).all( ); records.forEach(async function (record) { files= record.get("Attachments") //Attachments is the field name console.log(files) const reply = { type: ActivityTypes.Message }; reply.attachments = [await getInternetAttachment(files.url)]; turnContext.sendActivity(reply) }) [ { id: 'attAm7ezFldMnS7uC', url: file_url, filename: 'SampleVideo_1280x720_10mb.mp4', size: 10498677, type: 'video/mp4' } ] When I redirect to the output URL, the video doesn’t load which causes issues in sending the video files to the bot. Is this how the a

193
B
R
ruby_railsNew Participant
posted in Development & APIs
Create and Sign JWT in Airtable Scripting

Hi everyone, Is it possible to create and sign JWT inside Airtable Scripting? It is an authorization step required for making API calls. Thanks.

495
C
M
Marc_TorraParticipating Frequently
posted in Development & APIs
Create records based on configuration

I would really appreciate if someone could help me with the following script: I have a table called VARIABLES with certain costs {variable_name} and the possibility to assign to a cost concept different groups of assets {variable_groups} Then I have a second table called ASSETS for entering assets, where I always assign one group to each asset being entered. And I finally have a third table called COSTS connected to ASSETS in a one asset_id to many cost_id relationship with a field called {Cost name} that Links to the field called {variable_name} in VARIABLES. I need a script to be triggered when a new record is entered in ASSETS that: Reads the group to which this asset belongs {Group}, Checks in VARIABLES what costs {variable_name} have this group assigned in {variable_groups} Creates in COSTS one record for each {variable_name} that has this {Group} assigned. In the example for {Group}= “Vehicles”, we can see how it creates 6 records in COSTS connected to the asset_id just ent

33
Justin_Barrett
E
E_KKnown Participant
posted in Development & APIs
Add image from Google Maps Script

Have anyone tried this script yet? When I run it with Map address field populated by lat, long in degrees separated by comma (exactly how I use same for other maps), the script adds some attachment to every record but them removes it. In the end of the day, the attachment field instead of having pictures remains empty for every record. Any ideas?

115
Ricardo11
A
Arwel_BrownNew Participant
posted in Development & APIs
Populating a new table with entries from lined fields

Hi! I’m attempting at the moment to automate a flights table so passengers know where they’re flying to and when, etc etc. I’m having a huge issue with the linked fields! Here is the current table design; (confusingly, ‘Name’ here is in reference to flight name, but the principle will be exactly the same as extracting the Confirmation) Where ‘Confirmation’ is a six digit flight confirmation number (PNR number), coming from the ‘Confirmations’ table. For some reason, whenever I attempt to populate that field with my script, with a linked record from Confirmations, it shouts at me telling me the linked record ID does not exist! A dumbed down version of my code is below, it’s not too dissimilar to what is being done in this forum post (Adapting script to paste into linked field). The record is being created just fine, but the update with the value from the linked field is where things go wrong. I am a huge airtable newbie and am a bit lost! // Read table info let flightsTable = base.get

20
A
Tyler_Thorson
Tyler_ThorsonInspiring
posted in Development & APIs
How to sort a query?

Hello, the airtable documentation shows that to sort a query using selectRecordsAsync you should do it as follows: let queryResult = await table.selectRecordsAsync({ sorts: [ // sort by "Description" in ascending order {field: "Description"}, // then by "Priority" in descending order. {field: "Priority", direction: "desc"}, ] }); but this is apparently deprecated. How can I do it with the current codebase?

622
Tyler_Thorson
Mittens
MittensNew Participant
asked in Development & APIs
Use a "button" field to enter a value for that single record

Howdy, I have a database that deals with inventory for serialized items. For each item, I need to know when they have been found to be in-stock. Here’s what my setup looks like today: Records are items uniquely identified by a serial number One link-to field is Inv_Seen In which collects values each month that that item has been present for. As an example, one record will have been “Seen In: 2022-06” which means it was seen in June 2022. I manually type “2022-06” for each item. This setup is working fine, but requires a lot of typing the same exact thing over and over again Here’s my “dream” setup that I’d like help writing a script to achieve: Records are uniquely identified by a serial number One link-to field is Inv_Seen In and collects values… BUT… …There is ALSO a button field called Inv_In Stock? whose action is “Run Script”. That script will populate Inv_Seen In with “2022-06” (or whatever the month currently is. I am a-okay hardcoding the month value in the script.) for jus

1155
Mittens
Pete_Lindley
Pete_LindleyParticipating Frequently
posted in Development & APIs
Copy a Custom View Group / Section

Our Jobs & Projects are identical in structure with regards Airtable views. I create a section view with 4 / 5 separate views all predefined. When a new job comes up, I create a new section, then duplicate each view, then rename each view, then alter each filter according to the job number. Request: In addition to “Duplicate View”, can we have a “Duplicate Section and all views in it” please? Thanks in advance.

41
ScottWorld
C
Cedric_NIEUTINNew Participant
posted in Development & APIs
Create a delay with a script

Hi Everyone! I’m trying to set a 5-10 seconds delay for an automation. I’ve checked this post : https://community.airtable.com/t/i-need-a-delay-method-settimeout-is-undefined-not-found-window/28125 And I’ve tried the following script: function timeout(ms) { return new Promise(resolve => setTimeout(resolve, ms)); } await timeout(50000)//waits 5 seconds The editor gives an error and my automation can’t complete. Do you have any clue of how I can (A) fix this issue or (B) set a delay in a different way ? Regards,

3577
R
A
AirKVNew Participant
posted in Development & APIs
Can't get JSON data into Airtable through API

Hi all, I pulled JSON data through an API that looks like this: {'odata.metadata': 'https://opendata.cbs.nl/ODataApi/OData/80416ned/$metadata#Cbs.OData.WebAPI.UntypedDataSet', 'value': [{'ID': 0, 'Perioden': '20060101', 'BenzineEuro95_1': ' 1.325', 'Diesel_2': ' 1.003', 'Lpg_3': ' 0.543'}, {'ID': 1, 'Perioden': '20060102', 'BenzineEuro95_1': ' 1.328', 'Diesel_2': ' 1.007', 'Lpg_3': ' 0.542'}, I have created corresponding column names in my table. I have also read through the API docs and set up my Base ID / Table ID / API key. I managed to GET and POST requests into/from Airtable with dummy / hard coded data as presented in the API docs. I have tried to POST the JSON data into Airtable in different ways, which resorted in all the error messages you can think of :grinning_face_with_big_eyes: . So how do I structure the JSON data so that Airtable can interpret it? Look forward to hearing from you

1464
C
B
Brian_GottiNew Participant
posted in Development & APIs
Multiple Cells to Bullet List in Rich Text Field

Hello - I have a base that manages products for a website through Webflow. I have built and tested a tool that will import products from an XML source from the supplier that my client uses; however, for the product descriptions it gives the bullet list in an array (XML) that provides up to 24 bullets. I have them mapped and they sync to 24 distinct columns accurately, but now I’m having some trouble navigating how to get those 24 fields converted into a bullet list in the rich text field I have for the “Full Description” - while ignoring empty fields. Any support or insight would be greatly appreciated! Brian

51
Alexey_Gusev

Badge winners

Show all badges
Terms & Conditions