Development & APIs

I have a scripting app that will post to a Discord channel hooked up to a button field. Works fine if I use it in my logged in Airtable environment, even in a Gallery view. However, when I share that same Gallery view outside of my logged in environment, the scripting app button shows as disabled. I didn’t have this problem when it was a URL button instead. I can’t find any documentation on this or anyone else having this issue. Thanks for any ideas or insights!

Hey team! We are Bitskout, a UNESCO awarded software platform that allows users to create smart plugins powered by no coding & no training needed A.I. and add them to the tools they use. We are thinking about building the next integrations and several of our users use Airtable and we decided to check it out. I can’t seem to find a definite answer about how to create a custom action - that’s usually a way we integrate with other tools like Asana or Monday.com. This is what we want to do: Is it possible? If yes, please point us to the documentation or an example. Thanks! ilia P.S. Use case examples for Asana and

Hello, I’m using postman to create records in a table with data coming from another system. I am trying to use the JavaScript code provided in the API documentation (see below), however I’m getting the below error. Any help would be appreciated. Thanks! Error { “error”: { “type”: “INVALID_REQUEST_MISSING_FIELDS”, “message”: “Could not find field “fields” in the request body” } } JavaScript provided in API Docs var Airtable = require(‘airtable’); var base = new Airtable({apiKey: ‘removed’}).base(‘removed’); base(‘Table1’).create({ “Session_Title”: “test”, “Timestamp”: “tes”, “Duration”: “test”, “Coach_Emp_ID”: “test” }, function(err, record) { if (err) { console.error(err); return; } console.log(record.getId()); });

There might be a very simple way to do it or not but can anyone help me? I want to add a new column in my table using the api from my python module. How can I do that?

Hi We use a script to create airtable records through API. Attachement (pictures) are stored on a public webserver. The URL is passed by API request and Airtable dowload the attachement on his own cloud to be available in the attachment field. This solution worked properly for a year maybe. Since december 2019 we get some “broken files”. It seems that Airtable fails at downloading the attachment ant the attachment appears whit a generic icon instead of a picture preview. The picture can’t be downloaded properly. It is very inconsistant : we have records with for exemple 4 pictures in the attachment field and one of them appear broken. Deleting the record and recreating it the same way may fix the record. The picture is always available on our webserver. As we have a long history I could determine that this problem began to occurr on last december. I read some similar issues on the forum that have been fixed by “patching” the airtable with the

Is there a method on base(‘tableName’) that can get the length (number of records) of the table? Here is part of my code: var Airtable = require('airtable'); var base = new Airtable({ apiKey: 'myApiKey' }).base( 'myBaseId' ); base('tableName'). Here are the methods I see when typing: I also saw that someone suggested this: const table = await input.tableAsync('Copied'); const primaryFieldId = table.fields[0].id; const queryResult = await table.selectRecordsAsync({ fields: [primaryFieldId], }); const recordCount = queryResult.records.length; console.log('recordCount', recordCount); However, I’m getting an error saying: SyntaxError: await is only valid in async function (also, I wasn’t sure if input was a variable that was set somewhere

I’m working on a rather bulky script, and because I’m trying to keep it clean I try and create functions for repetitive tasks. But it seems that using functions inside the scripting block also results in a poor logging behaviour in the output screen. Take the following code: let firstCreatedFieldID = await base.getTable("Test table").createFieldAsync('test', 'singleLineText'); console.log(firstCreatedFieldID); let secondCreatedFieldID = await base.getTable("Test table").createFieldAsync('test', 'singleLineText'); console.log(firstCreatedFieldID); It neatly outputs the created field ID of the first command, and outputs the expected error of the second command. But now, if I functionize this script – which is this example seems silly, but in a larger script it of course makes total sense – like this:

I need a script for updating multiple records all at once for my automation that is scheduled to run monthly. I am running a counter system that is adding for every run, then every month i want to reset that counter to 0. The field here is a number field and everyone based on a view needs this counter changed to 0 whats my script? thank you!!!

Hey all, Happy Friday I’m wondering if it’s possible to import CSV files with script and outside of Airtable? We have guys in the field that use Stacker but it would be nice instead of them manually creating 4 records, to only have to upload the file via one record. I found this resource Importing a CSV file using Airtable scripting | Airscript Thanks

I’m trying to use the scripting app to: Get all of the records from one table (this Table is called “Incoming”) Copy all the records from the Incoming table to a different table called “Copied” Here is my code: let tableIncoming = base.getTable('Incoming'); let tableCopied = base.getTable('Copied'); let query = await tableIncoming.selectRecordsAsync(); let arrayOfIds = query.recordIds; let records = query.records; let recordsWithFields = []; console.log('query:', query); console.log('arrayOfIds:', arrayOfIds); for (const record of records) { let newRecord = { "id": record.id, "fields": record, }; recordsWithFields.push(newRecord); console.log('recordsWithFields', recordsWithFields); } ///// let recordsObject = { records: recordsWithFields }; console.log('recordsObject', recordsObject); await tableCopied.createRecordsAsync(recordsWithFields); However, I’m getting the following

Has anyone managed to accomplish this? I don’t have the best JavaScript skills and am wondering if someone has already created a script like this.

I’m looking for a simple script that I can add to a base that when run, manually triggers an automation I’ve set up that is turned on. For background into, I’ve created an automation that works, but the automation will only apply to future record updates. Is there a way to run a script that triggers my new automation to run manually and update all records that match?

Hey Airtable community, I am having trouble automating a script that triggers when the quantity field is updated of a new record. The trigger action is that a record is inserted into another table (Inventory Quantities) with the id of the current table (Products) and quantity set to 0. I had no issues when I set the field type of Product ID to number, but when I switched it to a linked record thats when the trouble started. Please find the code below as per suggestions and documentation on how to handle linked records: let ProductsTable = base.getTable("Products"); let QuantityTable = base.getTable("Inventory Quantities"); let query = await ProductsTable.selectRecordsAsync({ sorts: [ {field: "Product ID"}, ] }); let record = query.records[query.records.length-1]; let productID = record.getCellValue("Product ID") + ''; let newRecord = await QuantityTable.createRecordAsync({ "Product": [{id: productID }], "Quant

So, basically. Using the .NET api, when I create a record in a table, I can see it when I open my airtable table in the browser but when looking after it using the API (by Id, or searching a field) I can’t find them. Thanks in advance.

I’ve been trying to automate the deletion of sensitive data when a record comes into a certain view or meets certain conditions. No success so far… There are 2 obstacles (to my limited abilities in this field): Only a few cells need to be deleted, not the whole record. The deleted cells are attachments, so it won’t work to update a record with an empty cell. I’ve tried, but the attachments remain where they are, even though the tests run successfully. I’ve read a bit about scripting, but this is beyond my understanding. Does anyone know a way to achieve this, even for a noob as myself? TIA!

Hello, I am currently trying to to have cell A1 (Barcode Cell) autofill a linked cell B1 (Pallet #) based on a script. I would think its a simple “copy/paste text” situation, but that is not the case. Would anyone be able to figure this one out?

Greetings! :wave: I am a newbie here and have just started to explore Airtable! I have got a requirement to have a dynamic table which includes the alerts and a few metrics from google cloud monitoring, Is it possible to have such a thing built using Airtable scripting? Appreciate if someone could share some thoughts/suggestions on this. Thanks!

Hi! We’ve released a new version of the SDK, 0.0.46, which contains three new functions: base.unstable_createTableAsync() Creates a new table in the base with specified name and fields table.unstable_createFieldAsync() Creates a new field in the table with specified name, field type, and field options field.unstable_updateOptionsAsync() Updates the options of a field (e.g. adding or renaming choices in a SELECT field) Refer to FieldType f

Hello! I’m attempting to dynamically pass data through an API with the utilization of an Airtable button that triggers a ‘Run Script’ Automation. Essentially, the script will take the email of the record which triggered the automation, pass it through the API and the rest is covered. My biggest challenge is that I need to encode the email value in the API URL, however, I cannot figure out a way to modify the ‘readonly’ attribute of the input variable I’m attempting to use in this case. Anyone know of a method to bypass the ‘readonly’ attribute? Or if you have a different solution to get the records email in the script, I’m all ears! Code for reference: let email = input.config(); var encodedEmail = encodeURIComponent(email); fetch(“https://api.sendinblue.com/v3/contacts/” + encodedEmail + “”, options)

I have a database with many places and their coordinates and I’m looking for a script to know all the places within x kilometers from one place. Do you know if this is possible with Airtable? Thanks in advance. Thibaud -

Hi, I’d like to delete a record when a checkbox is selected. I’ve set up the automation but have zero knowledge of scripts. What is missing here? let table = base.getTable("Room Reservations"); let inputConfig = input.config(); let recordId = inputConfig['recordId'] await table.deleteRecordAsync(recordId);``` Thanks so much

Hi guys I hope some of you scripting geniuses can help me. I have a button In a task list and want to add a button to add a new row in that list under that project instead of clicking the “plus sign” underneath the row. Can someone help me with the script? Sinve I have the button and record picker script we know what row we’re at so to add a row/task shouldn’t be so complicated? But its complicated for me… The script look like this know : // Change this name to use a different table let table = base.getTable(“Tasks”); // 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); if (record) { // Customize this section to handle the selected record // You can use record.getCellValue(“Field name”) to access // cell values from the record output.text(You selected this record: ${record.n

Hello! I’m trying to edit a script that I already have. To do so, I need to be able to get values from a Link to Another Record. The linked record is on a different table. I’ve been using .getCellValue() for most cases, but it doesn’t seem to be helping me here. Right now, when I run the .getCellValue, it returns an Object, and when I run .getCellValue().values, it outputs “function”. How can I get a specific field off of the linked record?

I’m trying to figure out a formula for listing records that have have a linked field with the Record For Example if i have a Post Table with a Customer field that is an Array of customer Id’s such as [‘rec23jia’, ‘rec234i’], I would like to get this record back if the Customer Array field contains the value rec234i Heres my thought SEARCH(‘rec234’, ARRAYJOIN({Customer}, ’ ')) but this doesn’t seem to be working. When i do the opposite SEARCH(ARRAYJOIN({Customer}, ’ '), ‘rec234’), i actually get undefined values, so it’s almost as if the ARRAYJOIN function isn’t doing what i think it’s doing.

Say I need to get 5, 10, or 50 records, and I have their record_ids. Is this style of syntax a bad idea? { filterByFormula: "OR(RECORD_ID() = 'reca9IDlX0gvu32ml', RECORD_ID() = 'recgh3XeMcdmX8uPj', RECORD_ID() = 'reczBZBWZG06DOsCO', RECORD_ID() = 'recXvnMcZKmxyBtUi')" } I’m generating the innards of the OR with code. Thanks in advance.