Development & APIs

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

Hello All,After discovering Airtable through a colleague in a similar area, my office has been using it to manage temporary staffing. Despite the trend towards (and admitted usefulness of) low-code and no-code third party solutions, I am lucky to have a formal computer science background and as such have found the ability to weave varying levels of hard code into my organization's platform in a way that (mostly) integrates well with extant declarative tools and elements uniquely useful.Getting to the actual issue at hand, I am putting together a solution through an instance of the scripting app to run on the press of a button that takes select fields from the input record, concatenates them into a large string, and hashes them into a (semi)unique password to be used in a separate email validation process.Collision is a non-issue and the hash has no need to be cryptographically secure, but it is important that the resulting value, which is stored in a plain text field, remain immut

H, I have the Creator account, with no collaborators.Questions:1.  Can I set up API tokens, for myself, without losing my Creator account?2.  I use Make for my bases.  Do I still need to set up an API key for all the different scopes?  I will be using all the general scopes for my many bases.I am trying to do this the easiest way, instead of creating individual keys for each scope.  If I am understanding this Beta version correctly. Thank you,Mary 

Hi there!I've written some code where I'm trying to cycle through separate columns and based on the values in the columns output a different color. Then I want to send that color information to webflow. I think I'm close but I'm getting an error and can't figure out what to do differently.Here's the code: let table = base.getTable('Trust Fall Table'); let query = await table.selectRecordsAsync(); let records = query.records; for (let record of records) { let field1 = record.getCellValue("INTEGRITY-Q1"); let field2 = record.getCellValue("INTEGRITY-Q2"); let field3 = record.getCellValue("INTEGRITY-Q3"); // Repeat for all 20 fields... let color; if (field1 == 1 || field1 == 2 || field2 == 1 || field2 == 2 || field3 == 1 || field3 == 2 || // Repeat for all 20 fields... ) { color = '#ffffff'; } else if (field1 == 3 || field2 == 3 || field3 == 3 || /*...*/) { color = 'DB3F32'; } else if (field1 == 4 || field1 == 5 || field2

How do I connect Zapier now that API keys are no longer offered? I used the third party integration route listed on the help page but Zapier isn’t one of the programs listed.  I set up a personal token but after doing so it advises not to share with third party apps.  Last route is OAuthentication which, quite frankly, is much too complicated for someone who isn’t a develop and doesn’t have access to an Airtable consultant.  Why is this being made more difficult for the average user? Changes like this make me want to pull our entire account.

Hey All,Here is what I'm trying to accomplish. Basically using Airtable as an estimating tool for construction. I've created a "catalog" of parts and services that I need to pull from the catalog into an estimate table. I've tried this several ways including a junction table but the problem with that is I need to be able to overwrite the catalog price at times when the price of something spikes but doesn't merit being changed in the catalog table.My solution is to create a field in the Estimate table that runs a script to look up and copy a record from the catalog table to the estimate table.I've got the record look up working but is it possible to copy a record over with all fields?

The Miro integration was announced almost a year ago and works great - for one way integrations: https://community.airtable.com/t5/announcements/new-feature-announcing-airtable-s-miro-integration/ba-p/128357However, I would really need a two way sync, or at the very least a smart hack to achieve something similar.The best solution would obviously be a two way sync of the Content field. (This being the primary field I guess it could cause issues.) The second best option (pending better ideas) would be to have a second Content field. One possible ugly hack (for my use case) would be to use a huge number of Frames (acting as IDs)  and have the Content field editable from Miro. This could work but since I need 180+ Frames for the current case I don't really think it is feasible.Think of building an org chart in Miro (where names can change) and still wishing to link these to more data in Airtable.

My company is a housing authority and we have inspectors go to apartments to perform regular inspections. We are building an AirTable to track and coordinate inspections, however, I have been asked by the Inspections Department who are used to using DropBox if it is possible to link up DropBox to AirTable.In other words, Inspectors are uploading the Inspection Report to Dropbox and then use Integromat or some other method to read the report to obtain the unit address or other information that would allow that report to be uploaded as an attachment to the appropriate record in the Airtable Base. Is this possible?   Or is another solution possibly creating an extension that will replace Dropbox and allow for Inspection Reports to be dropped into the base and put into the correct record attachment field?

Hi,I am new to AirTable. I'm using is as the backend for my Flutter App. I see in my docs, that to upload an image or a file to the airtable, using an API, i need to provide a link to the image or file.This is what my docs say:To create new attachments in Picture and Resume, set the field value to an array of attachment objects. When creating an attachment, url is required, and filename is optional. Airtable will download the file at the given url and keep its own copy of it. All other attachment object properties will be generated server-side soon afterward.Now, my question is, is there anyway to upload an image or file directly to the airtable? Meaning, if I understand correctly, to upload an image to the table, I first have to upload it to my own server, then get a link for that image, then send the link into the table. Is there a way to avoid this, and just upload to the airtable, and get the download link from there?

I'm in construction.  I need a place that I can take notes on my interactions with vendors and subs, and then display those interactions in timeline and calendar format.  I'd like the input screen to be on my iPhone so I have the ability to dictate my meeting notes.  I'm looking for something very bare bones.  The CRM and project management tools I find are waaaaay more than I'm looking for, and I haven't been able to dumb them down.I thought a table with contacts, a table of projects, and an input table connecting them with meeting date and notes could be enough.  But I haven't been able to figure out how to get it to report in calendar and more importantly timeline view.  And the data entry screen on the iPhone isn't great.  (Help!)

Hi Airtable team, I currently use an automation linked to a single select "status" change to manage communication with candidates that have applied for a role at our company.Eg. if I change the status to "dismissed", it triggers the automation to send out an email to let the candidate know they are no longer being considered for the role they applied for.I do not want to send them a dismissal email right after our call and would rather wait the next day to do so. Now, to avoid for me to check back on this person later and also to offer an appropriate response time despite weekends or leave, I wish I could schedule the status to change within a certain timeframe.Thanks for considering my request!