Development & APIs

Hello! I wrote a script that creates multiple days worth of events people can book at a time, but it takes into account some settings to determine how long those slots are, when the lunch break is so it wont create a slot then, etc. I'm also making an automation to create a new day's worth of these every day at midnight, so that after we run the manual script once we can leave the rest of it to happen automatically. I'm wondering if there's any way I could grab the settings from the manual script for use in the automation. 

Here is a script that will count records per table and output the result as a little CSV output. It is a little quick and dirty and will take ‘some time’ to run if you have large record counts. Hope it is useful to someone. let tableCount = base.tables.length; let totalRecords = 0; for(let i = tableCount - 1; i >= 0; i--){ let name = base.tables[i].name; let table = base.getTable(name); let result = await table.selectRecordsAsync(); totalRecords += result.records.length; output.text(name + ' , ' + result.records.length); } output.text('Total Records in ' + base.name + ', ' + totalRecords);

Hi everyone!Nice to meet you.I am trying to load rich text content through api, but it's broken.But when I put the content with HTML tags, format is working properly.https://prnt.sc/r3ys_DfPjzFKBut my client is not a programmer. He can't add content with HTM tags.So I want to load rich text content as I entered without any HTML tags.Please help me.Thanks.

Hi everyone!I am trying to build an airtable extension, but when I create a new extension from scratch, I keep getting an error even if it's a fresh project(Hello World project), and airtable.com is running with http. Not https.  https://prnt.sc/vez_k5mb4PQ8https://prnt.sc/wXpGYOFcv3p2 https://prnt.sc/7xxP2ahjpOYV  Please let me know, how to solve this issue.

Hello, I have created a custom Airtable extension to dynamically update AirTable data. When I install an extension setup from a base a baseID and blockID are automatically added to the .block file and all table names are fetched based on the baseID by useBase hook. But when I will deploy it and users will install the extension, how will the baseID and blockID be set? Or how do I set the default configuration of Airtable to get baseID and blockID?

I have an airtable base that I have read-only access to. I created a personal access token (PAT) and gave it read-only permission to that base.I am using an angular app to display that data on a web interface, but I'm having difficulty successfully using the API. I have added both my airtable base and PAT to my environment variables, and have been using the auto-generated documentation to try and actually list the records. I continue to get a 'FetchError' detailed here:FetchError: request to https://api.airtable.com/v0/{BASE}/{TABLE}?maxRecords=3&view=Grid+view failed, reason: self-signed certificate in certificate chainat ClientRequest.<anonymous> (C:\EPandA\scorecard-metrics\code\backend\node_modules\node-fetch\lib\index.js:1505:11)at ClientRequest.emit (node:events:513:28)at TLSSocket.socketErrorListener (node:_http_client:502:9)at TLSSocket.emit (node:events:513:28)at emitErrorNT (node:internal/streams/destroy:151:8)at emitErrorCloseNT (node:internal/streams/destroy:116:3

I followed the directions from this handy Airtable Support Page: Sending Airtable data to Microsoft Power BI & Power Query to get data from one of my tables to Power BI. It worked perfectly. Then I transformed one field/column on Power BI by mistake, meant to transform it from text to number but instead I chose binary. I am quite new with Power BI and SQL–anyways I tried to ctrl + z to revert but I wasn’t successful. So instead I just closed it all out and left it unsaved, but of course when I opened it, the mistake change was still there. So then I exited out of Power BI and started a completely new Query, basically redoing everything I did from the Airtable Support steps above, but now the Table_ID parameter always gets a triangle with an exlamation point after I copy in the M Query and click “Done”. I also get the following error message: “Expression.Error: A cyclic reference was encountered during evaluation.” I’ve restarted my computer and tried everything again, and still get

An Airtable user tagged me with a question offline today. It caught my attention. … has Airtable (or have you) made any progress in using Vega Lite for non-table-based data?I believe he's referring to the ability to blend Airtable data with external data to product visualizations. This is a data-sciency thing that touches on aggregations.Allow me to reframe the narrative.Analytics designed to expose findings about data sets is typically based on aggregations. I often refer to these as viz-ready data.Aggregations are post-processes that are typically applied over collections of transactions or observations that are detailed. It's the data no one wants to look at except for perhaps auditors or data scientists designing aggregations.Airtable has rollups and other mechanisms to create aggregations. They're weak, poorly implemented, require new fields and keys, and almost always slow.Dynamic aggregations in a late-binding process (at viz-time) are needed because data changes

Dear talented Developers, I hope this message finds you well. I am writing to you today as a Ph.D. student in entrepreneurship at the University of Calgary. I am part of a research team led by Dr. Mohammad Keyhani, conducting a study on the no-code / low-code revolution. Your expertise as an Airtable extension developer is highly regarded, and we would be honored if you would be willing to participate in our study. Your knowledge and experience would be invaluable to our research, and we would greatly appreciate a 45-minute interview to gain deeper insights. However, if a 30-minute slot would be more convenient for you, we would be grateful for your time nonetheless.https://calendly.com/mahdieh-s1994/interview  I provide a calendar link or work with any preferred scheduling tool that you may have. Please rest assured that our study has been approved by the University of Calgary ethics board, and we strictly adhere to ethical guidelines to ensure the confidentiality

Hi everyone, I have a main base, I want whenever I create new record in main base, the other specified base will be updated, and whenever I edit or create new record in that specified base, the main base also be updated. It looks like sync but I want to way to provide task into the base I want. Thanks for your helping.

Hello!  Does anyone have a simple example script of using Python to connect to Airtable using a personal access token (PAT) to get data for a specific table?  Thanks!!

Followed this to the letter with a little help from Airtable Query .  Tried multiple tables keep getting the same error.Expression.Error: We cannot convert the value null to type Record.Details:Value=Type=[Type] 

Hello dears, Hope you are fine. Actually i’m new to Airtable and now i’m trying to connect Airtable with R to retrieve some data , then make some amendments on it , Then upload it again to its tab. Or insert certain rows into base tab. the code i’m trying is TravelBucketList = airtable(BASEID , tables = c(“tab1”,“tab2”,“tab3 BI”,“tab4”,…)) Subset = TravelBucketList$tab1$select_all() the error appeared is Error: HTTP error: 404 NOT_FOUND and what can write if the tab name has a space ?

Hello,I have a table for keeping track of our product demos that our sales team uses. I created a button that triggers a webhook in zapier and provides all of the information such as: The demo, the current employee who has the demo, their email, etc. When the webhook is triggered it sends an email to the last current user of the demo that their demo is being requested, but I cannot seem to figure out how I can catch the information of the user that is clicking the "request demo" button.  Also, our sales team uses a shared view of the demo page and it has a domain access restriction, so I know that in order for them to view the table, they have to log in using their work email. Any solutions to catching this information would be greatly appreciated. It was a big win to figure out how to get the email sent notifying the salesman that the demo is being requested, but its pretty pointless if they do not know who is the person requesting it.

Hi,Hope you are doing wellI downgraded my account to free one about 4 months ago and upgraded it again todayBut all the attachment urls are not availableI am not sure this is due to newly added expiration feature or other issuePlease help me if you have any ideaThanks,Alex

Good day Airtable Community,I would need your assistance on this matter.I have clients who would accomplish a certain form done via Zoho, and I wonder if I can show if client has completed the online form via Airtable and Softr?Thanks 

Hi,I've seen issues opened about this two months ago but we're experiencing this issue now.I tried leaving the script for an hour and the state doesn't change, though if I run a test of the automation, everything works. The status page shows there are no incidents.I've also tried creating a new automation that only runs the following script and it still gets stuck -   

I am working on building a base that tracks the daily open and close times of a facility with a variety of function rooms.  Ideally it tracks the room number, the time the room was opened, the time the room was closed (with an automation tracking hours used-rounded to half hour), and who the client is.   There are a number of other ancillary items that I would like to include eventually, but this is the primary function we are looking for.  I don't really like the default Date field and have been playing around with datetime_format and datetime_parse, but can't seem to get the outputs right.  Also while I am building this, I am not necessarily the end user.  What options do I have for presenting this to my colleagues to enter the data in real time?  Appreciate any advice and feedback as I work through this project.

Hello!I am trying to open an airtable attachment (m4a file) in Python but the attachment url does not have a filename. Thus, I am unable to open it. import requests base_id = base_id table_name = table_name url = "https://api.airtable.com/v0/" + base_id + "/" + table_name headers = {'Authorization': 'Bearer API_KEY'} params = {"maxRecords" : 50} response = requests.get(url, params = params, headers=headers) airtable_response = response.json() fields = airtable_response['records'][0]['fields'] url = fields['Recording'][0]['url'] filename = fields['Recording'][0]['filename'] r = requests.get(url, allow_redirects=True) file = open(filename,'rb').write(r.content) 

I have a field in a table whose values are links to records from another table. However, when I access this field via API, I'm getting some record IDs that do not correspond to any record ID in the whole base, and as a result I cannot obtain the values displayed on the web UI via API. What might be the problem here?

Hello. I had been running this script via a Button for many months... until today, when it stopped working. I am now getting an error message. Any debugging help would be appreciated. Thanks!let oob = '{"task": "IL"}'; let response = await remoteFetchAsync('https://hooks.airtable.com/workflows/v1/genericWebhook/appjM4uZHzs1Cbg3f/wfl3DsIZym7Q43Qw1/wtr9v3u61f4huzcgQ', { method: 'POST', body: oob, headers: { 'Content-Type': 'application/json', }, }); console.log(await response.json()); 

hello,i want to use old version of airtable.is it possible?

Hello everyone! Thank you for taking the time to review my question. I am using the Airtable “Find Record” automation feature to find records based on certain conditions. Once the feature finds multiple records, it selects the “Top” or “First” record that meets the condition criteria. I am trying to have it randomly select from the results, rather than default selecting the same record that was on top or first. Does anyone know the direction to look in or the process to make this possible? Thank you kindly in advance!

My ideal solution would be toPress a button in Airtable, which would call the Atlassian API to create a Confluence page (based on a template) in our Confluence Cloud instanceUpdate the Airtable record with the new URL from Confluence (into a specific field)We would also like to be able to then add child pages to that page later in the workflow but first I want to solve this first problem.Any ideas?

Hi, I would like to know how to create a cron job with NextJS and Vercel. I tried it like I did with another API but with Airtable it fails to compile. This is the error : Failed to compile. ./node_modules/airtable/lib/airtable.umd.js Dynamic Code Evaluation (e. g. 'eval', 'new Function', 'WebAssembly.compile') not allowed in Edge Runtime Learn More: https://nextjs.org/docs/messages/edge-dynamic-code-evaluation Import trace for requested module: ./node_modules/airtable/lib/airtable.umd.js > Build failed because of webpack errorsHere is the code that creates the error :export const config = { runtime: "edge", }; var base = new Airtable({ apiKey: process.env.AIRTABLE_API_KEY }).base( "{base}" ); const table = base("Orders"); export default async (req: NextRequest) => { // To set two dates to two variables var date1 = new Date(); // To calculate the time difference of two dates var Difference_In_Date = date1.getDate() - 74; date1.setDate(Difference_In_Date