Development & APIs

Node is unavailable on the server we’re using. So, is there another way to hide the API key using either Vanilla JS or PHP? Thanks!

I am not a skilled in Java script and am struggling with the simplest of a problem. Any help to get me going would be appriciated. Example: // Trying to change content of “Test Field” in an existing record to “Paused” // through a button function in that record. let table = base.getTable(‘ACC Base’); //Test Field is a Single Select Field let field = table.getField(‘Test Field’); let value = “Paused”; // When run from a button field, the script skips the prompt // and automatically uses the button’s record. let record = await input.recordAsync(‘Choose a record’, table); await table.updateRecordAsync(record, {‘Test Field’: “Paused”}); //End

I thought I was getting the hang of this Airtable thing, but I’m stuck on this problem. I’m trying to separate multiple columns from a single row into multiple rows in another table: Airtable Safety Audits - Airtable Explore the "Safety Audits" base on Airtable. Single audits are conducted using the fields in the ‘Safety Audits’ table. In the example there are 3 questions (Q1-3). If the answer to these is ‘NO’, the user is asked if the need to ‘Report A Fault’ (YES/NO). If yes, then they enter the details (Location, subject, photo, etc.). I think I need a script to populate table ‘All Faults’? Any assistance would be greatly appreciated as I have exhausted all of my formula knowledge. I appreciate this seems quite long winded, but the audit questions are part of our compliance records, so each question needs answered (the real audit has about 12 questions). The faults are a bi-product of the audits, and need to be treated separatel

How do I test for an empty Message field when it’s a “Long text” type? This code does not work… let strReplyStatus = ''; if (rsReply.getCellValue('Message') === '') { strReplyStatus = 'Empty'; }; if (rsReply.getCellValue('Message') == '') { strReplyStatus = 'Empty'; };

Trying to update additional fields of an updated record accordingly. Getting “undefined” value for recordId. What would be the problem? let recordId = input.config().recordId; console.log(recordId); let rootTable = base.getTable('uretim-kaydi'); let rootQuery = await rootTable.selectRecordsAsync(); let record = rootQuery.getRecord(recordId);

Is there a way to create a new record and enter a RECORD ID inside of a linked column? I’d like to reference the ID of other tables in my new entry, but am getting this error: According to AirTable’s documentation: “Airtable API performs automatic data conversion from string values if typecast parameter is passed in. Automatic conversion is disabled by default to ensure data integrity, but it may be helpful for integrating with 3rd party data sources.” Will enabling this feature solve the problem?

Hi! Currently I am developing dashboards for customers. The apps/chart will be displayed on a wordpress page using html code generated by Airtable “share”-function. Currently the interaction function prevents me from doing this. I don’t want the customer to be able to see all the records when they click on the chart. Conclusion: I only want to show the graph and not the underlying data. How can I do that?

Hello! I am writing a script that will export all the data from a database into Json files. With the API, I can easily get the column’s name and their values, but can’t get the table’s name! For instance, I have a table named “People” with its attribute: name, address, age, etc… I can get the attributes… but I want to get “People”. So I wrote manually in the script their names, but it’s not very convenient as if, in the future, new tables will be created. Is there any call I can do with the API? A “get” function or do something with the value of the records received? I work with node. Thank you and have a nice day everyone!

Dear Community, I want to automatically link records by linking incomming subscriptions (Table called EmailSubscriptions) to certain dogbreeds (!Hondenrassen). I need to match based on a unique id. This ID is in (EmailSubscriptions the “Kind”) and in the Table !Hondentassen also “Kind”. I want to link thise two automatically when a record enters a view. Using the a automation to run the script. I made this script based on some community scripts but it doesn’t seems to work. Can anyone help? /Define the !Hondenrassen table and query let cmpTbl = base.getTable(“!Hondenrassen”); let cmpQuery = await cmpTbl.selectRecordsAsync(); //Define EmailSubsciptions table and query let cntTbl = base.getTable(“Email”Subscriptions); let cntQuery = await cntTbl.selectRecordsAsync(); //Loop through the records and find the Kind for (let record of cmpQuery.records) { let cmpid = record.getCellValue(“Kind”); //Loop through linked table and match ID Values for (let cntRecord of cntQuery.records) { if (c

Hi all, I am creating a transportation dispatching system. One of the things I’m having trouble with is creating duplicate records. For example, I take person A to the grocery store on Monday and Thursday every week at 0900. I can manually duplicate the record to reflect this, but it would be far less time consuming if I could duplicate the original record indefinitely or for a specified end time. How could this be accomplished? --Thanks!

N: Can’t set cell values: invalid cell value for field ‘famille’. Cell value has invalid format: must be a string this is my script //Replace “Code cable” with column name which has the values you want to look up for (let record of mainTableRecords.records) { let lookupValue = record.getCellValue("Code cable"); //Replace "Name" with column name which is the range to search in //Replace "Famille" with columnn name which value should be returned for (let rangeRecord of lookupRangeRecords.records) { if (rangeRecord.getCellValue("Name") === lookupValue) { let returnValue = rangeRecord.getCellValue("Famille"); //Replace "famille" with column name from mainTable which should contain the link await mainTable.updateRecordAsync(record, {"famille":returnValue }); } } }

That is probably a very confusing title, I will do my best to explain what I want but I am pretty new to coding and Airtable. I already have a Grid View with multiple fields, and I am using the Forms View to add to my Grid View. In my Form I have a multiple select option where I can add multiple pieces of equipment that will be assigned to one project. However, for my Gantt Views I need the Primary Field to only contain one value. Right now I am using a formula to define my Primary Field. I think what I need to do is create a script that will extract the individual values of the array and assign them their own records. You can see from the images that not every record contains an array. Just for the sake of clarity, my Forms View updates the “Equipment # and Description” field, which has the lookup field “New # (Don’t Use)” which is what is used to define the Primary field. Not really an elegant solution but it is what I have so far. My Forms View: My Table, with primary field formula

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

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.

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

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?

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

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?

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

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?

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.

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

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

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?

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.