Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,656 Topics
  • 11,709 Replies
3656 Topics
C
captParticipating Frequently
asked in Development & APIs
IF Statement to stop script from running if a field has value

Hi I managed to get a button to run a script to populate a linked field with a unique value, thanks to the exellent advice by @JonathanBowen The link to the topic is here As the populated field only ever has the value pasted by the script or is empty, I wonder if I can adapt the script to only run if my target field is empty and display a warning and abort if it isn’t? For ease, here is the script… let repoT = base.getTable('Repo'); let sourceT = base.getTable('Source'); let record = await input.recordAsync('Pick a record', sourceT); // let name = record.getCellValue('Part 1') + '-' + record.getCellValue('Part 2'); let name = record.getCellValue('Data'); // create the record in the repo table let newRepoRecord = await repoT.createRecordAsync({ 'Name': name }) // set variable for today's date let now = new Date().toLocaleDateString("en-GB"); //note that newRepoRecord is the record ID of the created record // see this by logging the result: console.log(newRepoRecord); // n

232
C
D
Dominik_BosnjakInspiring
posted in Development & APIs
Old issue fixed - "Can only send 15 mutations every 1000ms"

Happy Thursday! Regarding this old issue: Can only send 15 mutations every 1000ms - Development and integrations / Scripting app - Airtable Community Forum The underlying cause has been fixed, as per Airtable support. I stumbled upon it in a completely different scenario and reported it around a month ago. You can verify by clicking and holding either arrow button of an input.config.number element inside the Scripting app settings UI. Doing so would have thrown an error before (after around 15 reactions, I suspect :slightly_smiling_face: ) and it doesn’t any longer.

60
D
J
jacob_angeloNew Participant
asked in Development & APIs
Linked Records and updaterecordasync

Ive looked at numerous other community posts but don’t seem to be understanding this. I want to update a linked field with a room location. The location is being provided by users selecting it from a list via recordasync, and I’m storing it as a string with .name. This unlinked field updates without issue: sourceTable.updateRecordAsync(recordID,{'nonlinked location': roomName}); but i can’t get the linked table to update no matter how I format the portion after the :. I’ve tried sourceTable.updateRecordAsync(recordID,{'linked location': [{id: roomName}]}) and other variations of that to no avail. I believe it has to do with the location being passed as a string to the linked array, but I’m not sure how to format either the input or the updaterecord to accept the change. The script is meant to accept a room choice, then the user enters an Item Number and the script updates the location of that item with the room chosen in step 1. let location = base.getTable("Rooms"); let sourceTable

942
J
L
Liam_HarrodNew Participant
posted in Development & APIs
Round-robin Lead Assignment

Hey guys – quick question. I have multiple sales representatives, and I’d like to be able to auto-assign them to a lead when it comes in. Is there a way to accomplish this in Airtable?

50
L
A
ATUserNew Participant
asked in Development & APIs
Updating a record field using a script

Hi Airtable community, I’m a complete novice at scripting, so bear with my ignorance here. I have a table with three fields: Email, Converted Email, and a Button. I want the button to trigger a script that encodes whatever’s listed in the Email field to base 64 and push it to the Converted Email field. I’ve gotten this to work so far using this script: let table = base.getTable("EncodeEmails"); let record = await input.recordAsync("Converting record", table); let b64 = btoa(record.getCellValueAsString("Email")); output.inspect(b64); This outputs the base 64 converted email in the scripting app, which is great. But I want that result to push to the Converted Email field in the record. I’m not quite sure what to do next. This is what I have so far, pieced together using examples: let table = base.getTable("EncodeEmails"); let record = await input.recordAsync("Converting record", table); let b64 = btoa(record.getCellValueAsString("Email")); let recordId = b64.record[0].id; await table.u

2602
A
R
Robert_AndrewsKnown Participant
asked in Development & APIs
Various attachment image dimensions via API?

Is there any way to control the image sizes I get served from an Airtable Attachment field via API? My API docs tell me I can access “thumbnails” in sizes “small” (width 72 on one image), “large” (width 1024 on one image) and “full” (3000 on one image)… But… “full” is not a thumbnail at all, it’s the source image. “large” is too large. “small” is just too small. It feels like there’s a missing middle size here. But it’s not supplied. Is there any way to constrain the size of an output image?

232
R
S
SBNZNew Participant
posted in Development & APIs
Avoid script exceeding exec time limit

I have an automation that runs a script, when a record enters a view. When I run the script as a test (in the automation setup mode), there’s never a problem. However, if the automation triggers, the script is always stopped by execution time limit. Any idea how to fix this? It’s usually only a couple of records int he view that triggers, so it shouldn’t be heavy computing at all. //Copy Values to a linked field //Declare tables var activeTbl = base.getTable("Delivered"); var activeView = activeTbl.getView("Createing Link to Prepared") var linkTbl = base.getTable("Prepared"); var linkView = linkTbl.getView("Prep for PD"); //Declare queries var activeQry = await activeView.selectRecordsAsync(); var linkQry = await linkView.selectRecordsAsync(); //Loop through your active table records for(let activeRec of activeQry.records){ //Declare field in the active table you'd like to match let actField = activeRec.getCellValueAsString("Referenz") //If a Number, use getCellValue inste

93
S
P
Pablo_FusterNew Participant
posted in Development & APIs
remoteFetchAsync responses return wrong character encoding (fetch does not)

When using remoteFetchAsync with my own server API the response.json() has clear character encoding issues: Promoción desde solo 29€/día. Calling the API in browser or Postman returns as expected. I spent some time checking Headers in the request, the server response encoding etc… But when I used the normal fetch routing the API through the https://cors-anywhere.herokuapp.com website it worked and returned the correct characters! Is the server used in remoteFetchAsync not encoding correctly the response?

66
M
V
Vidya_MNew Participant
posted in Development & APIs
call/run script when an record is created

Need help to call/run a script when a row is created in Airtable. The script will do a REST API call to another server. We tried to trigger “When Record Created”. but it’s not running the script. need some suggestions.

72
kuovonne
C
captParticipating Frequently
asked in Development & APIs
Adapting script to paste into linked field

Hello there I would like to avoid user copy and paste in one of our tables. For this is have created a button and modified the excellent ‘copy values from one field to another’ script by @JonathanBowen to my needs. This works really well to copy a value from my source field to a target field, replacing the existing value in the target and leaving a create date in the source field. Now what I want to achieve is that that target field is a linked primary field in another table. At the moment users do this manually with copy and paste, but we do not want to introduce the idea of copy and paste as a function, a button would make this more elegant. The idea behind it is that we use one table to build a product by formula from other field values, so that we end up with a full parts code in one field (the source). This is then pasted into the linked field to create a new record in a parts table. However if I change the field name in the code from a standard text field to the linked field I ge

256
C
C
Carmel94New Participant
asked in Development & APIs
Get visible fields in a specific view

Is it possible to get visible fields for a chosen table and view? I checked the Airtable scripting documentation and I cannot find the property to check if a field is visible for that view

452
D
J
JonathanBInspiring
posted in Development & APIs
Export field permissions data

I have several very large bases for which I need to manage the field permissions of multiple collaborators. It would be extremely useful if there was an app/script that exported the data on who has what permissions for every field. At the moment I’m compiling a “directory” of this information manually and it’s every time consuming! Does anyone have anything that could assist with this?

10
J
P
PageMonkKnown Participant
posted in Development & APIs
BaseProvider - Uses and Examples

Hi all, I see a BaseProvider in the API documentation . By reading the docs I am not able to understand what it is designed for. Are there any samples that show how to use it? Has anybody used it before or if you are aware of any github projects which use this, can you please share them? Thanks in advance.

10
P
C
Cem_MericNew Participant
posted in Development & APIs
Airtable + Integromat + Webflow

Has anyone successfully integrated these (Airtable + Integromat + Webflow) where file attachment deletion is working? i.e. If I remove/delete an attached file in Airtable it gets removed in Webflow as well. Thanks in advance

21
J
C
Charlotte_GenevNew Participant
posted in Development & APIs
Is it possible to pull a field description via either API or Airtable scripts?

I’m trying to find a way to pull the field description (described here: Adding a field description – Airtable Support) via the REST API or Airtable scripts. Is there any way to access this data outside of the web interface? Thanks in advance!

131
kuovonne
J
James_LibertoNew Participant
posted in Development & APIs
Updating Records Issue

Hello I am trying to create a script to enter in new information if needed or change information on a record if needed based on user button. I cannot seem to get the updaterecordasync to work. For the first one I just tested it by automatically changing a field ‘employees’ and giving it a set value, which I have been unsuccessful at getting to work. Ideally I would like to take user input and put it into the record field. I have attempted this on second part of the if statement with no luck either. Thank you for any help.

42
D
J
Jared_IngoldParticipating Frequently
posted in Development & APIs
Limit results or use maxRecords with Scripting App?

after using the API documentation it’s confusing trying to find info for the scripting app. I was expecting to be able to use maxRecords to grab the first record but that doesn’t seem to work. What am I missing here? let queryResult = await table.selectRecordsAsync({ sorts: [ // sort by "ID" in ascending order {field: "id"}, // then by "Title" in descending order. {field: "title", direction: "desc"}, ], maxRecords: 1 });

192
D
G
Guillermo_MoralNew Participant
posted in Development & APIs
Create script that finds duplicates within a cell

Hi there! After searching around for a while, I have not been able to find a script with the function of finding duplicates within one cell. I have found workarounds with Airtable automations, the only task holding me back now is the script. In this case, I want to be able to find and copy duplicated values from a cell (formula cell) into another cell (link to… cell). Image 1: Here you can see the structure of the table. Column 4 (Concatenated (FORMULA)) combines the values from column 2 and 3 (Outcome 1 and 2) into one cell. I wish to identify the duplicates within cell “concatenated” and return the duplicated variables to the column cell “Duplicate” (Sample 1) (Notice that the cell “Duplicate” is formatted as “link to…” cell). IMPORTANT: IF there is more than 1 duplicate, I want to return all duplicates into cell “Duplicate”. (Sample 2) I wish to make this process automatic. Outcome 1 and 2 are results we receive automatically from an online form. Airtable automatically concatenates

233
D
N
NikthegreekNew Participant
posted in Development & APIs
Is there a way to bypass or increase the Airtable API request limit?

I read the documentation and discovered that Airtable has a request limit for its API. We expect about 50+ people to use our mobile app on the first week of release and the number of users is probably going to increase after a month so this “5 requests per second” seems very limiting for the app. The chances of users sending requests simultaneously is pretty high and this will make the app unusable. Is there a way (maybe a premium plan) to exceed that limit without the 30 second wait penalty? Thanks!

204
M
A
Alex_ColletNew Participant
posted in Development & APIs
Error: connect ETIMEDOUT 54.210.4.251:443

Hi Airtable community. Since yesterday i’m facing an issue with the app I’ve been developping. I haven’t made any modification to my code and it seems to only happen since i upgraded my computer to a faster CPU (I think it’s unrelated but still mention it just in case) I have a method responsible for retrieving all the records from a table. async function getTableAsArray(baseId, tableName, view, maxRecord) { let table = [] let jsonTable = {} jsonTable['name'] = tableName jsonTable['records'] = {} base = new Airtable({ apiKey: 'API-KEY' }).base(baseId); await base(tableName).select({ maxRecords: maxRecord, view: view }).eachPage(function page(records, fetchNextPage) { // This function (`page`) will get called for each page of records. console.log(tableName) console.log(records) records.forEach(function (record, i) { if (i == 0){ console.log('1000ms') } Object.entries(record.fields).forEach(([key, value]) => {

110
A
E
Eric_Goldman1Inspiring
posted in Development & APIs
Add GraphQL and Type-safety to the Airtable API

When you are building on Airtable using Javascript - two things can help you build faster with less errors: :globe_with_meridians: GraphQL :closed_lock_with_key: . Type-safety Prisma is an amazing next generation ORM the brings type-safety and GraphQL to the table. So we wanted to see how Prisma would work with Airtable and wrote up a step-by-step tutoria: Sync Inc Docs Prisma - Sync Inc Docs Sync Inc replicates Airtable to a Postgres database, giving you the best of both worlds. In the tutorial, you’ll build a Next.js application that shows about 10K records from an Airtable base. It’s fast. And with Prisma, you can see this is just the beginning: Check it out, and would love to hear what you think.

90
E
D
David_LewisNew Participant
posted in Development & APIs
Fields parameter in input.recordAsync not working

Hi there, I am working on creating a user cms for our web app. My goal is gather a record’s information from a button click. I am currently getting the record based upon the click but I am only getting the ‘id’ and ‘name’ as part of the returned record object. Here is the code so far let table = base.getTable("Users"); let fieldsToInclude = table.fields.filter(field => field.name !== "Update User"); let record = await input.recordAsync('Update user', table, {fields: fieldsToInclude}); console.log(record, fieldsToInclude); The console output is: {id: "recmKNtwayYQNFu0K", name: "Kelly"} ▶(9) [Object, Object, Object, Object, Object, Object, Object, Object, Object] 0: Object id: "fldMqI2JmcuRkwOru" name: "First Name" description: "" type: "singleLineText" options: null isComputed: false ▶1: Object ▶2: Object ▶3: Object ▶4: Object ▶5: Object ▶6: Object 7: Object id: "fldVQSI2xjMjdunEi" name: "Initiative" description: "" type: "singleLineText" options: null isCo

143
kuovonne
R
Ronen_BabayoffInspiring
posted in Development & APIs
Support for date and datetime-local input types?

Hey, Wanted to know if there should be support for it. I just tried to use them but style is not what it should be I think. See attached screenshot of a block with the most recent version of the blocks package (v0.0.47): Thanks, Ronen Babayoff Superblocks.at

64
M
Z
Zim_OneNew Participant
posted in Development & APIs
Distinguish single and multiple record join field in Block API

Hi all, I realized that for Join Field (previously called Foreign Key field), regardless of whether it is defined as only allowing single or multiple records, is plainly exposed through the Block API as a ‘Multi-Record-Join’ FieldType and there’s no meta data available from the FieldOption as well. That creates many problems trying to handle the join field correctly. Ideally the field type should expose that difference (just like you wouldn’t call Single-Select field Multi-Select). But at least, is there anywhere we get some meta data exposed in the fieldOption or fieldConfig? Great if anyone knows what to do. Or if one of the API team member stumble upon this and take the feedback. Thanks.

61
Justin_Barrett
A
Anthony_BerthonParticipating Frequently
posted in Development & APIs
APIs Airtable x Mangopay

Hi, how to integrate & connect APIs of Airtable & Mangopay (PSP) ? what are the steps ? thks !

00
A

Badge winners

Show all badges
Terms & Conditions