Development & APIs

Hi, everyone! I need some hints to solve the scripting problem. I am not a programmer and only know easy html. Please let me explain what I am trying to do and see if you can help. I have setup a sync of a table 禮儀選曲 from Base A to Base B, so both Bases has the same set of data in this table. I have created a VIEW for any records meeting the filtering criteria in both bases. I have setup an automation to create a record in a table 選曲表 of Base B triggered when any record(s) appear in the VIEW. The data of the new records are from the table 禮儀選曲. The recordID of the original record is also stored in the new record. Until this point, everything work fine. I need to update the original record with the recordID of the auto created record. Since the automation cannot update record in another base, I have to use an API request to do this. I am just don’t know how to write this script to make it work. Please see my script and attached screenshot. Thanks for anyon

I haven’t been able to figure out the syntax to update a multiple linked record field through a script. I want to add to the linked records. I’ve looked through the multiple posts that address similar questions, but somehow none of the changes are working. :see_no_evil: Any help appreciated!

Any help on this issue would be really appreciated! I’m making a simple app to create quotes. I’ve got everything up and running to edit fields with the <Input /> component and for anything other than text it works great e.g. function updateRecord (quote, recordFields) { quotesTable.updateRecordAsync(quote, recordFields) } <Input name="Hire Start" type="date" value={quote.getCellValue('Hire Start')} onChange={(e) => updateRecord(quote, {'Hire Start': e.target.value})} /> However, when the input type is text (or currency, anything that can be typed quickly), there’s a very noticeable delay in the update to the cell value which makes input glitchy and, if you type fast enough, inputs get dropped. I then switched to controlling the <Input /> with a state object, only writing back to Airtable in a useEffect() that watched the state object. This

Does Airtable allow to read the content within/ inside the documents/ attachments with its own APIs?

The problem I’m having is that I use airtable for my financial reporting and because its a relational database if I (or someone on my team) changes data in one base itll change all my past financial reports… Is there any workaround for this? Possibly an app that can capture the dynamic data and make it static so I dont have to copy/paste each month into a google spreadsheet…?

Hi all, I’m new to javascript/airtable scripting and I’m trying to add the content of a form to a webhook when it is submitted. (Check in date, Check out date and Number of Adults) At the moment I have an automation to trigger when a form is submitted with the action of running a script. This is the script: let table = base.getTable("Managed Service"); let view = table.getView("Check Availability"); let url = "https://hook.integromat.com/[hidden]?"; let checkInDate = table.getField("Check in date"); let checkOutDate = table.getField("Check out date"); let adultsNumber = table.getField("Number of Adults"); await fetch(url + "&checkInDate=" + checkInDate + "&checkOutDate=" + checkOutDate + "&adultsNumber=" + adultsNumber); console.log(url + "&checkInDate=" + checkInDate + "&checkOutDate=" + checkOutDate + "&adultsNumber=" + adultsNumber); When the script runs I get the webhook pushing to i

Hi everyone, I’m executing a post request via the customer script app pointing to an integromat webhook to trigger an automation. The integromat scenario takes a while to run (approx. 45 seconds), as it duplicates heavy Google Slides presentations. The scenario ends by a the simple webhook response such as this one: { "body": {"message":"Scenario successful."}, "status":200 } I’m receiving the following error: Unexpected token A in JSON at position 0 This would normally indicate that the JSON string is malformatted and can’t be parsed. But a few tests, it looks like the await response.json() line is executed before the response is actually returned from integromat (it waits ~40seconds for a response before moving on). I have tested a mock scenario (running in a few seconds) returning the same json string and it works just fine. According to the researches

I’ve got a Scripting app script that uses createTableAsync(), and it’s been working fine for months. Today when I run it, I get an error of the form: j: No table with ID tblPJSEYaC7kb5yIF in base ‘Untitled Base’ at main on line 1 The following script demonstrates the error. It has just one line, taken from the createTableAsync() documentation: const tableId = await base.createTableAsync("Tasks", [{name: "Title", type: "singleLineText"}]); I expect that this line would execute without an error, and tableId would end up with the ID of the created table. Instead, the Scripting app stops with an error message in the console, halting the script prematurely. (The table is created, for what it’s worth, but the script stops and does not complete the rest of the operations.) Why have I started getting this error with createTableAsync()? Is there a way I can fix it? Or can Airtabl

I have an airtable base with ~1000 records. Each row record has a start and end date as well as additional information. I need to transform each record into multiple rows so that a record with a 3 month plan is shown in 3 rows, on a monthly basis (always 1st of every month)

Hello, I’m using pory.io and I tried to implament a “like” system in my table - a button with script that when pressed it increments "“likes” col in the row it has been pressed. But when using the button in pory.io it sends me to the table and opens the row details. The code: const config = input.config({ title: 'Add 1 to a number field', description: 'A script that lets you increment a number', items: [ input.config.table('table', { label: 'Idea Table', }), input.config.field('numberField', { label: 'Likes', parentTable: 'table', }), ] }); const record = await input.recordAsync("Pick a record", config.table) const currentNumber = record.getCellValue('Likes'); const newNumber = currentNumber ? currentNumber + 1 : 1 await config.table.updateReco

Hello everyone! I am trying to get an array of unique items which are objects of two keys {id: "record ID", name: "name of record"} To filter out duplicate items I use rather complicated way. I define 3 arrays: one for keeping collected data possibly having duplicates and later for cleaned data two others for keeping filtered ids and names Code looks like this: let d = []; let u = []; let v = []; d = [{id:1, name:"a"},{id:3, name:"b"},{id:3, name:"b"}]; console.log(d); u = [...new Set(d.map(d => d.id))]; v = [...new Set(d.map(d => d.name))]; d = []; let m = 0; while (m < u.length){ d[m] = {id:u[m],name:v[m]}; m++ } console.log(d); As you can see I am using a Set to filter out duplicates. Unfortunately, this works only for simpler arrays (or I do not know how to use it in my case

I have a view that is being grouped by two fields. When I do myView.selectRecordsAsync(); I get a flat list of records, though. Do I have to redo the grouping in JavaScript or is there a way for this to return a nested list that’s the same structure as my grouped view?

I wanted to know whether we can get the record which fulfills a particular condition in JavaScript (backend) or basically node.js and if yes then how? I want to use it to retrieve some user data.

Hello all, I’m working with a dataset where a user has permission to access multiple accounts, and an account can be accessed by multiple users (there is a many-to-many relationship between users and accounts). I’m importing this dataset into Airtable as a CSV file via a script that does two things: If an account in the dataset does not already have a record in the Accounts table in Airtable, it creates one If an account in the dataset already has a record in the Accounts table in Airtable, but the User field (a linked record field that allows linking to multiple records) does not contain a link to a linked record for a specific user (set in a variable elsewhere in the script), then it adds that user to the User field The issue that I’m running into is that after doing a lot of searching I’m not sure how to correctly write the following actions into my script: Filter records on the Accounts table where the

I have a view that has over 200 records enter on a specific date around 10 AM. This view is used to trigger Zapier to send a sendgrid email template. The issue is that Zapier will only get the oldest 200 records (which are all updated via csv import every morning) so anything over 200 won’t trigger. Because there is a large volume of records all triggered at once, Zapier holds them, so I can’t use the update record step after the sendgrid step to clean them out of the view as they run to ensure I get through the whole list. Anyone know a workaround (other than switching to integromat)? Any help is greatly appreciated. Have a send scheduled for Monday - hoping to figure this out this weekend.

Hello everyone, Now this is a strange one: I obtain a date object from an entry by a user, then I use that date to fill in a cell in a new record… output.text(HandoverDate is ${handOverDate}); let table2 = base.getTable(“Timeline”); let recordIds = await table2.createRecordsAsync([ { fields: { “Start date”: handOverDate, “Project”: [{ id: projectsDict[projectName].id }], “Milestone”: { name: ‘Launch’ }, “Task start date”: launchDate, “Task End date”: launchDate }, }, … The output text shows the actual date inserted by the user (it is processed a bit earlier in the code)… but the value in the ‘Start Date’ column is exactly one day earlier… I have also tried different dates and the behaviour is consistent (across months, etc…). I want to add that this portion of code is as is: I haven’t hidden any lines for this post. Any suggestions?

Good morning, i have a problem with my script. I want to update a record from a script button and i write this code: // Delete a record let table = base.getTable("Clients"); let record = input.recordAsync; table.updateRecordAsync(record, {'Name': 'Update'}); This doesn’t work and i don’t understand why. The only message i get is This script did not use the record from the button field. To use a record from a button field, call input.recordAsync in your script Anyone can help me please?

I’m trying to use Tailwind CSS with Airtable, but I’m not quite sure how to properly integrate the CSS. For context, I’m an experienced backend developer but my frontend experience consists of simple HTML and building simple React components. I know little about different frontend build systems. I know that it’s possible to import Tailwind from the CDN, but my understanding is that requires an HTML view to add the <a> tag that handles the import. Since Airtable doesn’t expose the HTML, I’m unsure if that is possible. Does anyone know of a very simple guide that walks through creating an Airtable app with Tailwind (or any custom CSS), bundling/building it if necessary, and uploading it to Airtable?

Hey everyone, I am new to airtable scripting and try to update records in a multiple select field (Users) the same way I do in a single select field (Workstation). It works in the singleselect but for the multipleselect I get the following error message: "j: Error: Failed schema validation: must be an array at main on line 19" As far as I can tell the root as well as my value are both arrays. Also the multiple select field appears to be in readonly and I cant figure out why. Here is my code. I really appreciate some help. Thank in advance. let table = base.getTable("Bookings - FoxOMS"); let query = await table.selectRecordsAsync({fields:["Location"]}); var myString = new String(); var myStringArray = new Array(); for (let record of query.records) { myString = record.getCellValueAsString("Location"); myStringArray = myString.split(","); if(!myStringArray[0].includes("Edit")){

I don’t see anything in the Developer docs for Apps or Scripts which has the option of setting a table’s or field’s permissions. There are methods to see if the table or user has permissions to make changes, but none to set them through the API as far as I can tell. Use case: I have created an archive of a large base with many tables for posterity prior to deleting a bunch of data. I’d feel better with the archive copy locked down to prevent any modifications. It would be great to be able to for-loop through the table’s and fields to lock them down in order to prevent record deletion, new record creation, and modification. Is there a way to do this programmatically or only through the GUI?

I’m trying to purge a KeyCDN url in a script and get the following error, “Request cannot be constructed from a URL that includes credentials”.

It’d be great if there was a required?: boolean field on the <Label>, <FormField> components in the apps sdk. When set to true, this would add a red asterisk like the one seen here:

Hi guys :slightly_smiling_face: Happy Friday! I was trying to adapt one of the available scripts. However, I failed badly. Opposite to the script I shared above, I’m using only two tables and in the main, I don’t want to create a template but I want to take a record (only a product name field) from the first table and incorporate it into the second table and assignee this record to a specific client (for that column, I’m using a single select feature). Those two tables are linked to each other by the product name column. In other words, the first table is containing all our products, while the second table contains multiply of these duplicated records but each of these records is assigned to a different client. Each client’s view is tailored and depending on their profile we share only products that are relevant to their profile. As our li

Currently my business is subscription based all through my company’s app with the database set up in Airtable (with payments in Stripe). I would like to add the ability to purchase a subscription from the website as well, and have it connected to the current Airtable database. Is this a doable task for a beginner or better suited for a developer? Thanks Brad

Airtable forms are not sufficient for my client’s need. There are several complex editable PDFs which they need populated from Airtable bases, but the scripting app questioningly denies access to the DOM (which is at least documented), but also the BOM (not documented). I can successfully populate the PDFs, but I can’t do anything with the stream. It would be great if I could open a browser window and dump it there, but without BOM access that is not doable. Any ideas to get around this report generation miss that Airtable has?