Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,657 Topics
  • 11,709 Replies
3657 Topics
P
Peter_NguyenNew Participant
posted in Development & APIs
Unable to display my app on the hello world code sample- 'block run'

Hi, I’m following this tutorial to run a hello world Airtable app: Hello, World Airtable app . Everything runs well on blocks-cli after I execute block runs and I have https://localhost:9000 displays on my browser without any issue. However, when I come to the app section on Airtable, it shows an error log: /usr/local/lib/node_modules/@airtable/blocks-cli/transpiled/src/builder/node_modules/yaml/index.d.ts: Cannot read property 'get' of undefined (screenshot below). I’ve tested on both Node 14.0.1 and Node 12.0.0 & reinstall @airtable/blocks-cli multiple times but no luck. Anyone faced this issue before? I highly appreciate any help!

100
P
J
James_GrubbNew Participant
posted in Development & APIs
One row is not returning data after an API call

Hello, all. I am able to return data after an API from all bar one row. All rows seem identical i.e no empty fields. Does anyone know what might be happening? Thanks BTW If I query using Postman I get the expected result?

00
J
F
Fernando_ValiceNew Participant
asked in Development & APIs
Create Multiple Linked Records

Hi Everyone! Thanks for you time beforehand and apologies if this case was already resolved in another topic (altough I couldn’t find any similar). I am pretty new to airtable scripting and I hit a roadblock in one of my codes. I need to iterate and create multiple linked records into a table, but my code is throwing me the following error “j: Can’t create records: invalid cell value for field ‘Property’. Cell value has invalid format: .0.0 must be an object. Linked records field value must be an array of objects with property ‘id’ corresponding to linked record id.” I assume this is because I have to put some sort of id in the createRecordAsync function, but I am not sure how the syntax for that should be. Full code: let importTable = base.getTable('Master List'); let importView = importTable.getView('Active'); let importQuery = await importTable.selectRecordsAsync(); let newTable = base.getTable('New Table'); for (let record of importQuery.records) { let recordName = record.getC

332
F
W
Wahid_ShafiqueNew Participant
posted in Development & APIs
Why are my mp3 files being converted to mpga when downloaded through the api

Here is another discussion I opened on the Gatsby forums Anyone know how to rename a node's file extension? · Discussion #33916 · gatsbyjs/gatsby · GitHub The gist of it is, I am expecting the api to give me back exactly the file extension I want, yet it seems to compress it or otherwise rename it to an mpga. Is this a quirk of the API, or something specific to what I am using?

41
D
R
Rose_Haft1Inspiring
posted in Development & APIs
How to accomplish encryption

Hi - Has anyone managed to successfully encrypt information via scripting or otherwise? Would love help or suggestions. @Bill.French listed an encryption solution and I love it. Field-level Encryption: Does Anyone Care?

241
ScottWorld
P
Patricio_SuarezParticipating Frequently
posted in Development & APIs
Refreshing Thumbnails

I have a base which records are being created automatically via an Integromat integration. Part of the process is creating a thumbnail image pulled from a URL link. All this happens through Integromat, an integration someone did for me. Lately, I have been getting empty thumbnail icons in Airtable after new records are being created. All links work ok but there is no thumbnail. If I manually delete the empty thumbnail and re-upload it via the link that is covered, the image shows perfectly. I have over a hundred records with no thumbnail. Would love to create a script that I can assign to a button that allows me to replace the empty icon with a fresh image pulled from the link. Any guidance as to how to start structuring the script would be super appreciated. I am very new to scripting and javascript. Tried searching for solutions here but maybe I am not searching for the right thing. Thank you!!!.

81
D
P
Paul_GibbsNew Participant
posted in Development & APIs
Storing credentials securely with Airtable scripts

Is there any way to securely store and fetch secrets in Airtable (API keys, etc), and then access them from within a Script (not an App)?

2131
D
B
btg202New Participant
posted in Development & APIs
Help - Summarising Data by filtered column

I’ve created a script which counts the number of rows grouped by the column ‘Deal stage’. I now want to tweak it to sum the values in column ‘First credits’ and group by deal stage, rather than count the number. Any ideas? It’s basically a =SUMIF equivalent. let table = base.getTable('Origination'); let result = await table.selectRecordsAsync(); let recorddeal = result.records.filter(recorddeal => recorddeal.getCellValue('Deal stage')); let records = result.records.filter(recorddeal => recorddeal.getCellValue('Deal stage')); function countByField(records, groupByField) { let counts = {}; for (let recorddeal of records) { let key = recorddeal.getCellValueAsString(groupByField); if (key in counts) { counts[key] = counts[key] + 1; } else { counts[key] = 1; } } return counts; } let categoryCounts = countByField(records, 'Deal stage'); const primaryFieldId = table.fields[0].id; const queryResult = await table.

64
Justin_Barrett
S
Silvia_FattiNew Participant
posted in Development & APIs
Use a new record as input in a script

Hi, I built below script to use a filed in a new record created as input as project but it doesn’t work and I cannot understand why:

143
Justin_Barrett
Jeff_Miller3
Jeff_Miller3New Participant
posted in Development & APIs
Help with simple code block

Hi, I’m trying to run the below VLOOKUP type script. When I type it in I get a strikethough on mainTable.selectRecordsAsync - I’m not a programmer and wondering 1) if this is why my script is not running and 2) how to fix it. Any help is appreciated. Thanks! let mainTable = base.getTable(“Price Book”); let mainTableRecords = await mainTable.selectRecordsAsync(); let lookupTable = base.getTable(“Inventory”); let lookupRangeRecords = await lookupTable.selectRecordsAsync(); for (let record of mainTableRecords.records) { let lookupValue = record.getCellValue(“Number”); for (let rangeRecord of lookupRangeRecords.records) { if (rangeRecord.getCellValue(“Item”) === lookupValue) { let returnValue = rangeRecord.getCellValue(“CA INV”); await mainTable.updateRecordAsync(record, { "CA Inv": returnValue }); } } }

198
X
A
Aaron_HansonNew Participant
posted in Development & APIs
Alternatives to fetch() and cookies for authentication?

Per the documentation, it appears that we can’t send cookies in headers for fech() commands. I’m trying to access an API with a GET request in which the only authentication method I have available is a session cookie. Does anyone know of another way to be able to make a cookie/session-based get request from within an airtable script/automation?

161
J
J
Joe_PepperNew Participant
posted in Development & APIs
Vlookup script help

The script is below. I have to tables. Provider AIS API Info and Global APIs. Field “Provider ID” from the Provider AIS API tab should be looked up in the Global APIs tab, in field Provider ID. The matched records should return the “Is it global?” Field back into the “Global API?” field of the Provider AIS API info tab. The script is below: let mainTable = base.getTable("Provider AIS API Info"); let mainTableRecords = await mainTable.selectRecordsAsync(); let lookupTable = base.getTable("Global APIs"); let lookupRangeRecords = await lookupTable.selectRecordsAsync(); for (let record of mainTableRecords.records) { let lookupValue = record.getCellValue("Provider ID"); for (let rangeRecord of lookupRangeRecords.records) { if (rangeRecord.getCellValue("Provider Summary") === lookupValue) { let returnValue = rangeRecord.getCellValue("Is it Global?"); await mainTable.updateRecordAsync(record, { "Global API?": returnValue

61
J
V
Victoria_HirstNew Participant
posted in Development & APIs
Building KPI Dashboards with AirTable Data

Bear with as I’m new to this product! Does anyone have a recommendation for building dashboards with AirTable Data? I’d love something that could pull data from multiple sources, but has a strong ability to integrate with airtable. Someone suggested to just copy and paste data into google sheets and build something in google data studio, but I want something that has a live connection and more robust integration features. Thanks in advance!

921
B
ScottWorld
ScottWorldGenius
posted in Development & APIs
Workarounds for overcoming Zapier's "New Record in View" limitation

One of the big limitations for Airtable users who are trying to use Zapier is that we only have 2 triggers: “New Record” and “New Record In View”. The problem with “New Record in View” is that it will only trigger once for the entire lifetime of the record (in that view). But I have discovered some pretty cool workarounds! In regards to Zapier not being able to trigger multiple times for the same record, I have discovered 2 relatively acceptable workarounds to this issue. (Meaning that these workarounds are not really “full solutions”, but they should be acceptable for a wide variety of use cases.) Both of these workarounds require a paid Zapier plan: As described in this Airtable blog entry, we can use Zapier’s Code by Zapier module as the trigger for any Airtable action (such as searching records to give us the records we’re looking for). You don’t even need to know any JavaScript — you just set Zapier to run this simple JavaScript code that always returns “true”: output = [{status

193
S
B
Britt_GivensNew Participant
posted in Development & APIs
Return an Array of Values

Hi - I am new to Script, hoping someone can help me have this function return an array or values rather then just one. EX) Zip code 10001 exist in multiple cells in “ZIP” and was hoping to return all values associated with 10001, not just one value. //Substitute “Us Enterprise” for table name which contains values //on which you want to run the vlookup let mainTable = base.getTable(“US Enterprise”); let mainTableRecords = await mainTable.selectRecordsAsync(); //Substitute “ZipCodeData” for table which contains range to search in let lookupTable = base.getTable(“ZipCodeData”); let lookupRangeRecords = await lookupTable.selectRecordsAsync(); //Replace "Zip Code " with column name which has the values you want to look up for (let record of mainTableRecords.records) { let lookupValue = record.getCellValue("Zip Code"); //Replace "Name" with columnn name which value should be returned for (let rangeRecord of lookupRangeRecords.records) { if (rangeRecord.getCellValue("Zip") === lookup

661
Justin_Barrett
B
Bruce_HalliburtKnown Participant
asked in Development & APIs
Attachments Not Working In Automations Using Outlook

Hi, I have an automation which sends emails using the in-built Outlook integration. Sending plain email works fine, but I can’t seem to get it to send any attachments. While configuring the step which sends an Outlook email, I can specify a field in AirTable which holds a pdf file in the attachment section. However, when the email is generated no attachment is sent with the email. Is this feature working or is there something I need to do?

40
Hannah_Wiginton
M
MathiasFlintaNew Participant
asked in Development & APIs
Download attachments via API keeping the original file name

Hi, I would like to download attachments via API or download link keeping the original file name. I managed so far to download all attachments using the URL airtable generates for each attachment using a HTTP get request to the link. The issue is that when downloading through the URL it gives new generic names for all files such as: file (1) file (2) … file(103) Etc. Do any of you know a solution to this? I am currently setting this up in Integromat. Thanks!

1522
M
M
Marc_FletcherNew Participant
asked in Development & APIs
Scheduled running of script App

Hello I’ve built a cryptocurrency portfolio app that uses an automation as follows: The trigger is a “At a scheduled time” set to once every 15 minutes. The Action is “Run a script”. The script fetches Cryptocurrency prices, converts them to £GBP and then writes them to a table for inclusion in some formulas. When I share this base, the automation is not shared, I must provide setup instructions to the recipient so that they recreate the automation. This is true even if the base has been copied to a Workspace with a Pro plan. I see that recently, the scripting App has become free to all users so wonder if I can remove the Automation but replace it with a Script App that will be able to trigger on a schedule, programatically. Is this feasible? Does anyone have any experience, advice or suggestions for a better solution? I can see similar questions were asked in this category but well over a year ago. Many, many thanks

174
M
T
Trent_WarrickParticipating Frequently
posted in Development & APIs
Linking/appending records script

I realize this is constantly asked in variations but I cannot find a solution to the issue. Most auto-linking scripts replace the contents of the field, in lieu of appending the new linked record to the field. I’ve attempted to concatenate the array of IDs, but that throws an error on the field write. //Define the company table and query let cmpTbl = base.getTable("Speaker Calls"); let cmpQuery = await cmpTbl.selectRecordsAsync(); //Define contact table and query let cntTbl = base.getTable("All Interested"); let cntQuery = await cntTbl.selectRecordsAsync(); //Loop through the records and find the Contact ID for (let record of cmpQuery.records) { let cmpid = record.getCellValue("Campaign Name"); let cmpid2 = record.getCellValueAsString("mem"); let cmptest = record.getCellValue("Scouted"); console.log(cmpid2); //Loop through linked table and match ID values for (let cntRecord of cntQuery.records) { if (cntRecord.getCellValue("Campaign Name") =

114
T
A
Antonio_Gaglia1New Participant
asked in Development & APIs
Microsoft Flow integration with Airtable

Hello everybody, heavy airtable user here. While developing the production+ecommerce+shipping tool for my company, I started to crash repeatedly against the microsoft integration walls. Basically there isn’t any integration to push/pull data from airtable to MFlow. The only solution is using third parties integrators like Zapier. As crazy as it’s sound, microsoft don’t provide this integration inside the Microsoft Flow integrator. This is also very condensed in a post on their forum which is 4 years old now, with people still asking for it: https://powerusers.microsoft.com/t5/Power-Automate-Ideas/Airtable-Connector/idc-p/598121#M21464 I hope that maybe some pushing from Airtable itself could work, ending in a long awaited integration, as many of us end up with some company using microsoft soon or later… Hope somebody can answer on this!

610
M
V
Vic_GravesNew Participant
asked in Development & APIs
Async/Await function to loop through and POST to external URL - Works when running externally in node but cannot get it to work in Airtable scripts app

Hello! I have written a script which should be taking Airtable data (the actual use-case is URL redirects data) and posts to Shopify, however, I’m getting really stuck with this final element of my script! I’m using the scripting app in Airtable. I’m fairly confident that this is an Airtable scripting app nuance because when I run this script in node with hardcoded Airtable data it all works as expected and posts my data to Shopify! In the script below, I’m able to get the Airtable data as expected, and I’m also able to POST to Shopify outside of this function. However, I need this URL inside of a loop (forEach) so that I can POST each of the individual data sets to Shopify. For reference, URLSettings() updates the body element of the JSON I am posting to Shopify. I am needing to loop in each item of the array and post one-by-one. For reference, the console.log(result) below gives me an empty array. const hardcodeArray = [ '{"redirect":{"path":"/products/orange","target":"/collecti

755
V
E
Ewan_FarryNew Participant
posted in Development & APIs
Automatic script to combine two fields into one

Hi, I’ve got a view which filters all records with an empty ‘Name’. As I capture ‘FirstName’ and ‘LastName’ separately, I want to routinely combine these into a single text field (a formula won’t work for this case) I added an automatic script, running every 15m which seems to work with one exception. I do not know how to reference the combined ‘FirstName’ and ‘LastName’ field, anything in quotes is treated a string. Sure there must be a way, hope someone can help; let records = input.config().step2Records let table = base.getTable("People"); let view = table.getView("emptyname"); let selectFieldName = **`???????`** for (let record of records) { await table.updateRecordAsync(record, { [selectFieldName]: **`???????`**, }) }

173
kuovonne
A
Assaf_BarnirNew Participant
asked in Development & APIs
Randomizing the results from an API call

I built a small table and am accessing it via Airtable API. Any tip as to how I can randomize the results I’m getting? Meaning: for each API call, get the value of a different row. Cheers

241
kuovonne
Karlstens
KarlstensBrainy
asked in Development & APIs
Needing help with Script

Slowly piecing together a Regex script in the Scripting App, but I’m stuck with table.updateRecordAsync not reading the field that’s active in the loop. If I hard-code the field name in with quotes it then works as I hoped, but if I use the field.name from the loop, it won’t parse. So the below works (but isn’t very useful as I’m trying to cycle through fields rather than hardcode a string); await table.updateRecordAsync(record, {"🔍Test_1": String("test1")}); “test1” will successfully write to each record for field “ :mag: Test_1”. But when I swap out the hardcoded Field name string with field.name it unfortunately fails to parse. await table.updateRecordAsync(record, {field.name: String("test2")}); Running Console log on field.name, it comes up as expected - so I’m not too sure what I’m doing wrong and will appreciate some help. Full code below - and keep in mind that I’m still learning Javascript - I’m finding it tricky to break my old coding method and habits to learn the new techn

145
Karlstens
R
Robin_BaillargeNew Participant
posted in Development & APIs
Can we have API key not bound to a personal account?

Hi! I’m wondering if it’s possible to have an API key not from a personal account but a service account reserve to our apps? Maybe some of you have best practices when dealing with that kind of configuration (staging, production environments etc). I’m on the entreprise plan if it’s relevant.

11
ScottWorld

Badge winners

Show all badges
Terms & Conditions