Development & APIs

Hi, i’m strugling with it 3rd day and read many docs about querying with fetch on JS, but seems like my understanding of web stuff is not enough. I used similar method for fetching from API with JSON, or from simple html site parcing text, but here I can’t achieve desired goal. Site is a base of clients, sorry but for now I didn’t have approve to disclose real name. https://search.somelongdomain.com, reloading to https://search.somelongdomain.com/ClientSearch.php?Accept=Accept it contains form with “Name”, “LastName” etc, then “Start Date”, “End Date” and two buttons, Search and Reset. After submitting “start_date”, “end_date” i press Search and have list of Clients registered within this period, 20-50 names for 2-3 days, and that’s my desired result. output loaded as https://search.somelongdomain.com/NamePick.php, it’s a form with name table and checkbox near each, but that’s ok, i know how to extract my data from any type of text format is html text, site looks a bit old, it doesn’t

Any plans to add support to environment files? I’ve tested but it seems blocks SDK don’t have support. Create React App has support for this. It’s a kinda basic feature and would be super useful. Thanks

Hello everyone! This is probably a simple question, but I could not figure out the answer. I have an Object and two arrays: const arr = [1,2,3]; const arr2 = []; const obj = {}; obj.id = arr[0]; obj.fields = {}; obj.fields["Array items"] = arr; arr2.push(obj); console.log(arr2); //array contains 3 items as expected arr.length = 0; //empty array console.log(arr2); //array is empty As I understand the Object instance keeps only a pointer to the array. Is it possible with an Object to keep a copy of array contents and how to achive that? Thank you in advance.

How are airtableblocks.com domains generated? Trying to whitelist domains for my app and wondering if that is possible.

I’m trying to find the X-Airtable-Client-Secret inside Airtable Account URL. But it isn’t there. Reading this Airtable API Meta I thought I was going to find it inside airtable.com/account but it doesn’t seem so. Where do I find the airtable client secret ? thanks in advance

useCursor does not re-render my component when the active Table or active View changes useBase does not re-render my component when I add or remove tables or when I rename fields This was working a week ago. Any feedback?

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 anyone would like to help! It is a c

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 solved the issue but now updates made in Airtable (outside of the app) are of course not reflected in th

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 integromat, however the variables just show [object Object] as seen here:

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 made, default fetch() requests timeout at the time indicated by the browser which would be 300 seconds in Chrome, but I’m

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 Airtable fix it?

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.updateRecordAsync(record, { [config.numberField.name]: newNumber }) output.markdown(`Updated ${config.numberField.name} for ${record.name} to ${newNumber}`)

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). Is there any easier or brief way to do that? Any valuable suggestion is much appreciated.

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 User field (a linked record field that allows linking to multiple record

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")){ myStringArray.unshift("No Workstation selected"); } await table.updateRecordAsync(record.id, {“Wo