Development & APIs

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!

We all know about ChatGPT. It’s profoundly expanding the possibility of creating some very smart systems. Pervasive and near-free access to LLMs (large language models) inch us closer to AGI (artificial general intelligence), which can be applied to apps and data in several ways.Airtable, of course, is readily able to enjoy the benefits that services such as OpenAI provide to developers. Integrating the power of LLMs for text and code completion is almost trivial. These are magical capabilities, but they aren’t the only capabilities.Most AI experts and analysts agree - AI will become pervasive in all solutions, and the ones that create the greatest customer value will blend application data, user context, and LLMs to create extremely relevant and powerful outcomes.Rows That Have MeaningAirtable search is not a pleasant experience at all. The findability of discrete records in a table is terrible. Locating key data across multiple tables and bases is almost impossible. I have explored t

Hi All, I could use a little insight into what's wrong with my formula.It's scripted in my API, using Airtable.js with Next.js.The following works with only the second two fields, which are multi-select, but ignores (or seems to ignore) the text input field "Title." const records = await table.select({filterByFormula: `OR(FIND(LOWER("${req.query.title}"), Title) > 0,FIND("${req.query.module}", module) > 0,FIND("${req.query.lessonprogram}", program) > 0)`,sort: [{ field: "RecordId", direction: "asc" }],}).all(); If I try to use AND, I get nothing: const records = await table.select({filterByFormula: `AND(FIND(LOWER("${req.query.title}"), Title) > 0,FIND("${req.query.module}", module) > 0,FIND("${req.query.lessonprogram}", program) > 0)`,sort: [{ field: "RecordId", direction: "asc" }],}).all(); However, through the REST API I get the JSON results I want, using AND (even if Title is an empty string): https://api.airtable.com/v0/<appID>/<

We plan to use the Shopify App called Stocky for our purchase orders and transfers between locations. We would like to connect the data from Stocky to Airtable, and in Airtable analyze stock, sales and purchasing. In the lack of technical terms; we would like to see incoming stock on created purchase orders in Airtable.Does someone know if that's possible? Thanks!

Bold headline, right? An existential threat to what exactly? Well, um, everything compute-related. But let's narrow this missive down to, Airtable itself (for example).Unless you live in a cave, you're aware of ChatGPT. It's in the process of roto-tilling pretty much everything compute-related. While not generally seen as a threat to much, we all see the writing on the wall; the computing world will change profoundly with LLMs, and the rate of advancement AGI has demonstrated in recent weeks and months that changes are happening quickly.Yesterday, OpenAI opened the kimono to reveal yet another massive game changer; [GPT Plugins](https://openai.com/blog/chatgpt-plugins).Let that sink in.While all aspects of this new GPT capability are significant, one flies in the stratosphere of all other possibilities - ***to run computations***. While everyone is drawn toward "*access up-to-date information*" in a mesmerizing mental trance like a Star Wars tractor beam, the most stunning part of the

we built this on airtable and we want to have users update their profiles by summiting it for each listing.they could do this by either1) Claiming the profile and submitting their informationorWe are open to other ideas. How would you go about doing this?Any Help would be appriciated thank you in advance.

I have a table with fields "Name" (primary), "Description", and "Notes". I'm writing a small script in the scripting extension that requires users to use a record picker to select a record. Right now, if you use the search bar in the record picker, it only searches within the "Name" field. I'd like to be able to search in Name,Description, and Notes so that I can pull up a record based on the description or notes if I don't know its name. Is it possible to reconfigure the record picker? Relatedly, I found in the API that it's possible to add an "options" argument to the input.RecordAsync call, but I can't figure out where in the API the options are explained. Anyone know where I can find this?

I have a task that requires itertools. but I am having no luck. is it possible to import from itertools? or any other library for that matter? thanks

Hi this might be a fairly beginner question, and more programming specific than Airtable but if anyone could help, I’d appreciate it. When I make a request to my base and main table, I’m able to get a response but within it are only ID’s of linked records on other tables. I can’t figure out how to get the actual data within the arrays. For example, instead of IDs in the authors array, I’d like to get the actual data within the Authors table there. I figure I’d make a request to the Authors table, and then have to group them together with map & find somehow. Same for Genre. {1 id: "recYt9GrRjvpVcX0p" fields: { subtitle: "How We Misthink Money and How to Spend Smarter" Thoughts: "Best book ever yay" Start Date: "2021-01-11" Status: "Completed" End Date: "2021-01-14" Authors: ["recquUajrIfbpR6vU"] Genre: ["rechPpsFS3LQyaZkg"] title: "Dollars and Sense" Days to Complete: 3} I’d appreciate the help.

I'm going to try and over-simplify what I'm trying to do. Here's the current set-up of my table. - I have three rows, Apple Picking, Pear Picking, Cherry Picking. For each row I have the following fields, Blank Start Date, Blank End Date, Apple Picking Start Date, Apple Picking End date, Pear Picking Start Date, Pear Picking End Date, Cherry Picking Start Date, Cherry Picking End date. See screenshot below "Before Script" for example of how this looks like in AT at the moment and the values in each field.- I would like to run a script that would populate the Blank Start Date and Blank End Date with the appropriate values. For example, for Apple Picking, I'd like the script to pick-up the Apple Picking Start Date and populate it in the Blank Start Date field.  See screenshot below "After Script" for example of how this looks like in AT at the moment and the values in each field.If there's a formula I can use to do this, happy to do that do just wasn't sure if it was possi

There's a lively conversation about querying data that is not ideally shaped to answer the desired question over on Table Forums. It is related to an earlier time shortly after scripts were made possible in Airtable when I recommended (in 2020) that a script should be afforded the ability to become a custom formula. I'm not the only developer who has thought about this.@kuovonne provides an approach to answering the question that started the conversation. But I have and still would love custom formulas to do this.Imagine a different approach that requires only your data and one API call to OpenAI that costs about 1/60th of a penny.Given this GPT query:This is a straightforward idea, but when performing queries across data tables that may not be ideally shaped, we will increasingly see LLMs provide answers where scripting or formulaic approaches are complex and require skills and added development time (of course).gptPrompt("Given this list of dates, determine which is the latest:"

I’m trying to create a home page for my Confluence space with some headline data from a table I’ve got in AirTable. I’m ultimately trying to create Power BI type cards on the page, showing a count / total of records in a view in AirTable. I’m not even sure how to get that headline data out of AirTable, let alone import it into Confluence. I’ve asked the question on the Confluence forum as well, to see if it’s better to approach it from that direction.

I have a Lambda function which is trying to create records in an Image Assets table. One of the fields (Race Name) is a linked record to another table in my base. This table is also synced to another base. The code seems to successfully find the Race name from within this other base using the record_id but there is something preventing it being created and I can't work out what it is? Here is my codeimport axios from 'axios'; // Utility function to get random stage const getRandomStage = () => { const stages = ['DISCOVERY', 'REMIND', 'OFFER', 'FINAL OFFER']; return stages[Math.floor(Math.random() * stages.length)]; }; const createImageAssetRecords = async (baseId, tableName, airtableApiKey, raceName, recordId, imageNum) => { const platforms = ['Etsy', 'Pinterest', 'FB Image Post', 'IG Image Post', '1080x1920']; const airtableUrl = `https://api.airtable.com/v0/${baseId}/${encodeURIComponent(tableName)}`; const createRecordPromises = platforms.map(async (platform) =&gt

Hello, I am using AppGyver as my front end. From a multiselect field in AppGyver, User A chooses “red”, “blue”, “green”, “purple”. I want to pull all records from my Cloth table which have those 4 colours From a multiselect field in AppGyver, User B chooses “pink”. I want to pull all records from my Cloth table which have pink. I do not know in advance how many criteria the user will select. I know i can sort by multiple fields using an array → ?sort[0][field]=day&sort[0][direction]=asc&sort[1][field]=name&sort[1][direction]=desc (of course the whole query parameter needs to be encoded) But i don’t know how to do that for filters through API cause API filtering is done through filterByFormula → and if i were to use an OR function, i need to know how much filters there are in advance e.g. user will choose 1 colour, or 2 colours, or 3 colours etc Could someone kindly teach me how I can get this done in AppGyver linking to Airtable? Thanks!

I am trying to use createrecordsasync but am getting this error: “No overload matches this call” All the parameter types are correct. I’ve switched them, created variables, double checked, etc. What else can I check? No overload matches this call. The last overload gave the following error. Argument of type ‘{ Client: { id: string; }; Term: { id: string; }; Eating_Count: number; Eating_Nutrients: string; Nutrients_Eating_Ids: string; Type_Not_eating: string; Not_Eating_Count: number; Not_Eating_Nutrients: string; Not_Eating_Nutrients_IDs: string; }’ is not assignable to parameter of type ‘{ Name?: string | undefined; fld5FO4eGWlC7DMPI?: string | undefined; Note?: string | undefined; fldgbYNn7xXOXZ1Gy?: string | undefined; Term?: readonly { id: string; } | undefined; fldJxWEonOumMn0g3?: readonly { …; } | undefined; … 9 more …; fldZSv8PUr3LGCm1T?: string | undefined; }’. Object literal may only specify known properties, and ‘Eating_Count’ does not exist in type ‘{ Name?: string | undefi

Hi,I need to build a script to parse a webpage. At first run it crafts POST request to search for item, the page returns a table-like list of several matching items with their statuses. (I'm on that stage now).  I need to choose item(s) with certain status, enter their links and get info I need.So far I parsed such pages using my own functions, but it feels like I re-invent the wheel. Is there any 'best practice' or free working solution for such action?. I just need an example using only script extension (I saw examples of using DOMParser() but I would like to stay inside Airtable without establishing additional servers, node.js etc)Note that I receive text, not JSON. Also, page doesn't require credentials.Example of functions I'm using now (POST options omitted):  const myurl = 'https://sampleurl.com'; const [tagA,tagZ,tagX]=[`id="items">`,`</h3>`,`</span>`] //single item start/end/exclude const [DIVIDER,WASTE]=['mw-headline',`<span `] //items di