Development & APIs

This category is for developers to discuss building custom extensions and connect with each other. If you’re looking to get access to the developer platform in order to build custom apps, fill out this form. and you’ll be granted immediate access. And Apps are the new Blocks! Read more about our announcement here. Share what you’re building, and learn more about what other people are building! You’ll occasionally see Airtable developers hanging out here to provide support.

Hello, I am attempting to update a record with an attachment via scripting automation and it appears that the attachment is getting uploaded properly but immediately deleted automatically. Screenshot: Was wondering if anyone might know why this is happening. Is the upload URL improperly formatted? I have done projects similar to this before but this is the first time I have run into this issue. Thank you for the help.

Greetings, folks: All I want is to create the next record: let nuevoRegistro = { 'ALUMNOS': [{ "id": regAlumno.id }], 'ANHO': [{ "id": registroAnho.id }], 'CENTRO': [{ "id": registroCentro.id }], 'isAlta': { name: "Yes" }, 'CLASE': { name: clase }, 'CURSO': [{ "id": regCurso.id }], }; With the following function: let crearRegistros = async function (tabla, nuevoReg) { return await tabla.createRecordAsync(nuevoReg); } And what do I get when I run this? await crearRegistros(tabla, nuevoRegistro); U: Validate this value before parsing I couldn´t find any info about scripting errors. I hope someone did and would like to share what I’m doing wrong. Thanks!

Hello! I’m trying to build a linked record editor. I’ve discovered that Airtable’s own grid component (the same layout as the Grid view type) isn’t available to use in the UI kit. Is there any way to embed Airtable’s grid component in the app? Thanks!

Hi, If I have a column with the field type “URI” it doesn’t actually check that the inputted data is a valid URL. Is there a way for me to define a custom field type with the API/Apps. The ideal situation would be a custom field type that is validated by Regex. Thanks in advance (:

Hi all. We have a custom-app in which its returned some data. We would want to bind this flow, so, when user selects something at the custom-app, the referred record(s) are picked at the table. We tried a lot of ways with no success. Custom-app data comes from an i-frame. We are able to have the records array but we still are not able to pick records as it is shown in the screenshot. Thanks in advance

I’ve got a script that chunks through API requests out to a 3rd party, and instead of outputting a ton of status text, I thought it would be a great UX if they could see the progress of those requests and be able to stop them early, all in the same button. Is this possible to update an input button’s label after it has been sent to the UI? If that isn’t possible, is it possible to update an output string similarly? I’ve tried a few things that might have worked normally outside of airtable, but haven’t had much luck as most of these communication objects don’t return themselves to be overridden later. Would be happy to hear any weird ways this can be accomplished as well (another table in the base that contains the value, etc). It doesn’t have to be elegant, just has to be update-able haha

We’d like to create an outbound notification by sending (http POST) a message to a 3rd party API endpoint on certain events. We are looking to use the built-in triggering and scripting features of Airtable. Has anyone tried to do something similar? Thanks!

Hi, I would like to see an integration with Microsoft Teams. As this is our preferred CMS at work.

Hello. Nice to mee you. I have this probrem.Preformatted text please let me know. //get table info let table = base.getTable("A2_複製"); let queryResult = await table.selectRecordsAsync(); let record; let stocks = new Array(2); //I wanna set to array[i][0~1], but I can't... Error tell me "TypeError: Cannot read property '0' of undefined" for(let i = 0; i < queryResult.records.length; i++){ record = queryResult.records[i]; stocks[i][0].push(record.id); stocks[i][1].push(record.getCellValue("*印刷型番")); } ; console.log(stocks);

Is there a way to delete tables in a base programatically ? The blocks API does allow creation of tables, the destroy although works via the REST API when called with the cookies Will there be a base.DeleteTableAsync ? or can we use sessions in some way to get the cookie and make the REST API call, still have to explore on sessions

Hello, I use Airtable to organize the list of traditional folk tunes I play on my fiddle. As well as the typical tune metadata (name, style, key, composer, etc.), I paste in a PNG of the music score and a “snippet” of the first couple bars. I’d like to instead have the music rendered in a cell using abcjs that references another cell that has the raw abc music notation. Looking at library documentation, seems like this should be an easy thing to do(?), but I’m not much of a programmer. Does anyone want to take a stab at this “for fun”? :grimacing: I’d appreciate any tips to get me started; I’m eager to improve my coding skills and could use this project as a vehicle. Thanks! Tom

I’m guessing if it was possible it would have something to do with using typescript but I have not been able to figure it out. I did download node and tried to install the airtable npm but kept getting a “connect EBADF” error. Not sure if any of this is actually gets me closer to my desired goal but this was just me attempting things.

How can I test changes to a base, and then deploy them to a live environment? I’m building a fairly complex base for a client. Once the project is live, there’ll doubtless be a need for further enhancements, bug fixes, etc. I need to be able to test those changes safely, and then once proven, deploy them to the live base. I can’t see any way Airtable handles this right now - the only option I can see is to manually note all the things that I’ve changed in the test base, and then repeat those changes on the production system, while it’s live. Any suggestions?? Am I crazy trying to use Airtable for a production system?

I would like to know if it is possible to trigger script when a record is updated. I can see the [ useWatchable ](Airtable Blocks SDK) hook is avaiable, but I don’t know if it will run on background or not? For example If I update record using a API then would it would trigger ? Here is what I want to achieve :slightly_smiling_face: When a record is updated in a table ==> Trigger APP to run calculation ==> ADD/update entry in another table. For first table there are number of source to update record… Please advise if thre is an better optoon available.

Hello! The API seems to not return the profilePicUrl on the Collaborator field, even doe the collaborator has a profile picture. Does anyone have the same problem?

I’m a developer and plan on writing A LOT of different scripts. Let’s say I create a script that sums the values of a column. I plan on using this script (function) in multiple scripts. Is there a way I can essentially call this script in separate scripts instead of having to copy and paste code all the time? In other words, can I create global functions? Can I call a script in another script? The same concept applies to global variables. My script will use the name of one of my columns. But if I change the column name, my script won’t work. I have to manually edit the script and change the column name. Global variables, or at least global to the table (doesn’t have to be the entire base), would enable the script to update automatically.

I’m not a programmer, I’m trying to update a record based on the conditions selected. I’m battling to understand the ‘await’ function. I believe it’s a promise and that it splits the code until the conditions are fulfilled? I kept getting an error if I put the await inside the if conditions. I’ve re-written this a few hundred times and tried looking up what other people have done and now I’m throwing in the towel. Below is the full script, any guidance would be hugely appreciated. // Change this name to use a different table let table = base.getTable("Game Tracker"); // Prompt the user to pick a record // If this script is run from a button field, this will use the button's record instead. let record = await input.recordAsync('Select a record to use', table); let seats = record.getCellValue("Employees"); let segmentSize; await table.updateRecordAsync(record, {"Segment": segmentSize}) if(seats) { if(seats > 300) { segmentSize = "Enterprise"; } else if (sea

I am attempting to write multiple linked field values to a sigle new record. When I invoke the createRecordAsync method on the table, more than ten records (all with the same cell values) get written to the table. When I define the function as Async and use an await, no records end up getting created. Code snippets below. let operatorNamesField=tableOperators.getFieldByNameIfExists('Operator Names'); let operatorNamesRecord=useRecords(tableOperators, operatorNamesField); let operatorNameOptions=operatorNamesRecord.map(operatorNamesRecord=>({ label: operatorNamesRecord.getCellValueAsString(operatorNamesField), value: operatorNamesRecord.id })); //note: all of the select field options are formatted as above, but not shown for brevity <Select value={machineId} options={machineNameOptions} onChange={setMachineId} /> <Select

Hello, Is any of you guys familiar with the new native script url to attachement ? It is looking pretty good, working really smoothly. But it seems to have a cache issue : the image captured is the same throughout the day. Do you know how long the cache is preventing a fresh image to be attached ? Does anyone knows how to edit the script in order to have a fresh new image everytime ? Thanksfor your help. Hereafter the script code : let settings = input.config({ title: "Convert URLs to attachments", description: `This script will download all attachments from a URL into an attachment field. The source field can be a URL field or any text field containing a URL. Each cell should only contain a single URL.`, items: [ input.config.table("table", { label: "Table" }), input.config.field("urlField", { parentTable: "table", label: "URL field", }), input.config.field("attachmentField", { parentTable: "table", label: "Attachment field",

Is it possible to access a base outside of a base in which an app is installed? That is, if my application is integrated in one base, can it use something similar to the useBase hook on outside bases to which I have access?

hello, i am fetching data from table and prefer to filter them before displaying, to do like operator WHERE in SQL, how can i do this with airtable?

Hi I need your help today. I would like write a script to update à LinkToFild with multiple Record Links. I write this script but “await tableLudique.updateRecordAsync” doesn’t work. Can you help me ? let inputConfig = input.config(); let rentedgames = inputConfig.listingrent; let proposedgames = inputConfig.listingpropose; let tableLudique = base.getTable("Profil Ludique"); let recordsPulpo = await base.getTable("Liste jeux de PulpoLudo").selectRecordsAsync(); let record = inputConfig.record; console.log(proposedgames); console.log(rentedgames); for (let rentedgame of rentedgames) { for (let proposedgame of proposedgames) { if (proposedgame == recordsPulpo.getRecord(rentedgame).getCellValue("Référence")[0].id) { proposedgames.splice(proposedgames.indexOf(proposedgame), 1); }; }; }; console.log(proposedgames); console.log(rentedgames); await tableLudique.updateRecordAsync(record, { "liste des jeux à proposer": proposedgames, }); Thanks for

I created a table that has cells with email templates I want to send. The email templates in specific cells have tags that reference specific records I have chosen. I am trying to pass the email templates to an If Then statement in a script but the output it puts is with the tags instead of the record information. Below you can see the script, followed by the output, followed by the output I want. Do you have any idea how to fix this? SCRIPT // Change this name to use a different table let deals = base.getTable(“Deals”); let templates = base.getTable(“Templates”); // Prompt the user to pick a record from deals then from templates // If this script is run from a button field, this will use the button’s record instead. output.text(“Templates matched with Records”) let record = await input.recordAsync(‘Select a record to use’, deals); let temp = await input.recordAsync(‘Select a template to use’, templates); // You can use temp.getCellValue("Field name") to access the template var select

Hi, I am currently connecting to airtable data via the API. I am able to sort my response in certain fields using desc and asc. However for non text fields in particular single select fields where in the UI you would sort First-Last. What would the parameter be for sorting these fields?