Development & APIs

I create some summary reports for a client. Data is read from a view I iterate through the records to generate the HTML/Markdown for the email.However, to get the formatting correct, I have to use this odd amalgamation of markdown and HTML. Using one or the other alone results in unpredictable results. When using markdown to create the 2nd or 3rd level header worked on the first record. Each subsequent record simply had the "## " in the email.Also, I can't use markdown or HTML to get a horizontal rule... annoying. Any answers for this. Not critical but nice to have.  for (let i=0;i<recordsLockReady.records.length;i++) { let fileString = recordsLockReady.records[i].getCellValueAsString("File").replace(/"/g,''); let coeDateString = recordsLockReady.records[i].getCellValueAsString("COE (Estimate)"); let daysToCOE = "-n/a-"; if(coeDateString != "") { let coeDate = new Date(coeDateString);

I’m trying to setup a simple API but I’m not exactly sure what APIs to use. I want to check for a unique value in a field (userID) and return the RecordID. If recordID exists, overwrite record with new data If recordID doesn’t exist, create new record with data At the moment I’m stuck on 1. I’ve tried List Records, using filterbyFormula & the API Encoder tool, Retrieve a record, I just can’t get the single results returns like I’m after. Can someone please provide me with an example API request to for number 1? If you could help with the others that would also be really great but at the moment 1 is where I’m stuck. I know it’s a really simple API setup but I’m new to this and have been trying for hours. I have also posted to the Airtable forum but my posts are

Hello! I have a custom extension. I haven't made any changes to the code recently but today calling expandRecord() starting throwing this error and crashing my extension: TypeError: Cannot read properties of undefined (reading 'parentBase')I've confirmed that it's being passed a valid-seeming record object.Here's what my code looks like, it's defined in the top level on my component. 🤔 🤔const expand = (record) => { console.log(record) expandRecord(record) }Let me know if you need any other information. Thanks for your help! 

I’m trying to create a custom block, but when I run: block run I get: Error: listen EACCES: permission denied 0.0.0.0:9001 I’ve checked and there’s a system task already listening to this port, so I’m not able to just kill it. Is there a way to change the listening port so that I can make this work?

I am updating the "File" field of a record.  The cell is a long text field with rich formatting enabled.When I PATCH with this body:{ "fields": { "File": "~~[2022-23 letterhead doc34.docx](https://contoso.sharepoint.com/sites/ServicePlans/Shared Documents/General/Worksheets/2022-23 letterhead doc34.docx?d=w16af26ee9f084a6ba700aaa4bb4467a4)~~" } }Airtable returns the below:"fields": { "File": "~~\\[2022-23 letterhead doc34.docx]\\(https://contoso.sharepoint.com/sites/ServicePlans/Shared Documents/General/Worksheets/2022-23 letterhead doc34.docx?d=w16af26ee9f084a6ba700aaa4bb4467a4)~~\n", ... }Notice the \\ before the opening bracket of the hyperlink markdown.  This breaks the markdown and results in a visually unappealing field:   Expected behavior is a strikethroug

I’m using Airtable as a database as that’s where my clients data was already. Integrating in a react app using node/express/webpack deployed to heroku. When I bring in data from a long text block from Airtable, some characters are automatically escaped with backslashes - these are not visible in the UI of the airtable database. When I console log within the server it appears as below - Name: ‘Power Pose’, Notes: ‘INSPIRED BY: \n’ + Want to learn more about body language and how much our body impacts our mind? Watch Amy Cuddy's TED Talk, "Your Body Language May Shape Who You Are." https://www.ted.com/talks/amy\\_cuddy\\_your\\_body\\_language\\_may\\_shape\\_who\\_you\\_are\n, ‘Area of Improvement’: [ ‘Self-Awareness’, ‘Presentation Skills’ ], ‘Number of People’: [ ‘Solo’ ], Description: ‘Find a quiet space where you can be alone. Set and start a timer for 2 minutes. Spread your arms wide, making a “V” with your arms. “V” for th

Hi, I would like to know if it is possible to make a Mail merge using data that comes from AIRTABLE API and Google docs or Microsoft word template?

is it possible to create an image downloading application using airtable as backend and webflow or wordpress as front end, i just want to check the users mail id (as input) if that is true then they could able to open a record and may download the image if not it should indicate that as invalid emailif email is right - open a record in airtableif email is wrong - error messageif it is possible kindly help me out , i'm a newbie here. thanks for your time

This seems like a very basic question but search hasn't yielded me an answer.How do I set a field with spaces in the name using a fetch() request?  const res = await fetch('https://api.airtable.com/v0/xyz/Estimates', { method: 'POST', headers: { 'Authorization': `Bearer ${process.env.AIRTABLE_TOKEN}`, 'Content-Type': 'application/json' }, body: JSON.stringify({ "records": [ { "fields": { Client: [client.id], JSON: escapedJson, Total: total, Screens: screens, Outside Only: flags.outsideOnly } }, ] }) });

I work for a nonprofit that has begun to use Airtable extensively. We house almost all our data in it and we use Make to integrate it with almost everything we use.  However, we have one major system that is not currently integrated and that requires a meaningful amount of double entry.  We are going to need to build a custom API integration. We have spoken with the technology team at this company and they are happy to work with us to do so. They recommended we get someone who knows Airtable well to build the integration and said they will provide the guidance needed for their side.I have built all our Airtable systems and integrations using no/low-code, but I am most definitely not a developer! I think this will be a fairly straightforward project for someone who is. If you are interested in this project, let me know and I'll send you my email and details. 

Using node Airtable calls, when running a the fetch calls, randomly calls will return an error with FetchError: request to https://api.airtable.com/v0/**************/Popular%20Searches%20Filter/recG77zPA5fNrb05z? failed, reason: getaddrinfo ENOTFOUND api.airtable.com Doing basic call base('Card Data').select({ view: "Selected View", pageSize: 3, }).eachPage(function page(records, fetchNextPage) { // code here fetchNextPage(); }, function done(err) { if (err) { console.error(err); return; } });

HelloThe need is quite simple : portfolio management -> based on the value of a field, I want to assign a record to a collaborator / if project is in a list of regions, then it is assigned to toto.Following lot of examples, and assembling pieces of codes (i'm not dev), i came with this :  // set the table const table = base.getTable("Saisons") // get the record from the trigger const config = input.config() const trigger = config.triggerID console.log('trigger',trigger) const allrecords = await table.selectRecordsAsync() const record = await allrecords.getRecord(trigger) console.log('record',record) // get the formula value const region = record.getCellValue("Region (from Dpt-Reg) (from Bénéficiaire)") console.log(region) if (['Normandie','Bretagne','Hauts-de-France','Pays de la Loire','Centre-Val de Loire'].includes(region)) { let update = await table.updateRecordAsync(record, { 'Suivi': 'toto1@ds.org' })

HelloHere is a case we're stucked with :For a given company, I need to list projects that are located in the regions covered by the company.For example: company A covers regions 1, 2, 3 - company B regions 2,4project Alpha is located in region 1project Bravo is located in region 2project Charlie is located in region 4Companies are in a table, Project in another one, list of Regions is a linked field to another table for bothIn Compagnies table, I've a field where I list covered Region (linked value) and a field with Projects (linked values) - I want to run an automate that fills in the Projects value(s) based on a Region value(s).At the end example should be :Company A - cover regions 1, 2, 3 - project Alpha, BravoCompany B - cover regions 2, 4 - project Alpha, CharlieAutomation will :for a given company, find the list of region coveredrun a repeating

Hello,I am trying to debug why a certain script I wrote for automations failed because it takes more than the allowed 30 seconds. It seems that Airtable JavaScript environment doesn't support parallel execution of asynchronous tasks. Is that correct ? What can I don if I want to perform this kind of code: await Promise.all([ updateRemoteDB(), updateRemoteDB() ])Thanks,Yaniv

Airtable states that the API request limit per second per base is 5 . So is that for a single IP or all IP's combined ? if somebody can explain in detail the api rate limit as of 2023 , it would be highly appreciated...

I’m attempting to integrate Airtable OAuth into an application of mine but the Airtable endpoints to fetch access tokens keep giving an “invalid_grant” error. I’ve already looked at this post and haven’t been able to solve my problem with it: https://community.airtable.com/t5/development-apis/oauth2-problem-with-token-request/m-p/142198#M11746 Step one: The user clicks on a link and gets redirected to Airtable OAuth. Here’s how I generate the link:```const state = crypto.randomBytes(100).toString('base64url');&nbs

Hello Airtable builders,We have been heads down working on a tool that we think you will love building with.Today we are launching SQL as a better Airtable API.Previously, we launched our first sync between Airtable and your Postgres database right in this community. We’ve been floored by all the tools, applications, dashboards, and businesses the community has built on this sync.After working with thousands of Airtable teams, we heard a common suggestion: it would be amazing to write to Airtable through the database. Instantaneously creating, updating, and deleting records with nothing but SQL.So

Hi We have received a notification in our Airtable account that "API keys will be deprecated by the end of January 2024". We have integrated our Airtable and Salesforce account using Zapier tool. Does this Deprecation notification affects the current integration happening via Zapier?. I saw the below comment in Airtable help article that we don't need to do anything, and Airtable will take care of the third party tools(Zapier).Note: We are working with third-party integrations to migrate to using OAuth for integrations. No action is required on your part until they complete the migration, after which you can stop using your API key and use OAuth to connect instead.  Please assist me. "

Hi Team,I have 1 table for base.I will pick a 2 record to be swap.I want the FirstName,MiddleName,LastName records will only be swap. There other records belong the FN,MN,LM will still remain.My Script:let table = base.getTable("Work Station");let result = await table.selectRecordsAsync({sorts: [{field: "Station Number"}]});let record = await input.recordAsync('Pick a record', result);if (record) {    output.text(`You picked ${record.getCellValueAsString("Employee Name")}`);}let record

I'm a new user (still on the trial period before going to Pro). I'm trying to import records using the .csv import extension. However, I keep getting the message that I can't import the records because the "table is locked".I've searched the help, looked around here, and opened a trouble ticket 4 days ago to which I have yet to receive a reply about this.In the help, I've found how to unlock a view, but not a table. Can someone please refer me to the solution here? I've looked under every link with no success.Thank you.

I would like to build a mobile app that tracks user's habits and stores the data in AirTable account of the user.I want to use react-native framework because I want the app to be able to store the data in different services (eg. google sheets). At the moment it isn't clear to me if the AirTable API policies will allow me to insert records into user's tables? My initial tests came accross Cross-Origin Resource Sharing issues. Can somebody enlighten me if what I am after is in principle possible?Thank you.

I have several hundred Jotforms integrated into Airtable. Based on AirTable's announcement about eliminating the API key and changing to two other methods, I contacted JotForms and was informed that they ONLY support the API key.As of August first, I won't be able to create new Jotform integrations and as of Next February, all of my existing ones will stop functioning.Does anyone have a workaround? it can't be a manual solution like copying and pasting because I use it to create real-time leaderboards from the results of the Jotform answers so the results have to get into AirTable instantly.Thansk for any help!

Hi! Maybe someone over here can point me in the right direction. I am trying to build a custom extension, but the moment I add the extension airtable.com becomes “not secured” causing CORS issues with my extension. At the beginning I thought it might be my code, but I tried it with the “Hello World” extension and the same issue, the moment I add the localhost connection the site switched from secure to not secured Any ideas what I might be doing wrong or what else I could test? This is happening with Chrome, haven’t tested yet with other browsers. Thanks in advance

Hello, AirTable forum!I am trying to figure out how to update an AirTable, using the Scripting extension and drawing from an external API (LegiScan). The issue I am running into is that first, I am incredibly new to JavaScript, and second, single- and multi-select options are causing me some trouble. I have reviewed a number of posts in this forum about APIs, as well as the "Cell values and field options" documentation (https://airtable.com/developers/scripting/api/cell_values) but I cannot figure a solution in this case--this is likely my newness to and lack of skills with JavaScript! (I previously mainly coded in R, which is...not the same.)My code can pull the data (and reformat a date), but I cannot update any field that is single- or multi-select, and I am also struggling to declare multiple fields to update (this is, I think, just an issue tied in with the single- and multi-se

I received the following prompt from Airtable's IDE, but I don't understand what it is asking me to do?Could someone please give an example as to how I would pass options.fields to selectRecordsAsync()? TIA!"Calling selectRecordsAsync() method without passing options.fields is discouraged.  Passing options.fields allows you to request just the fields you need."