Development & APIs

Hey there, I am exploring AirTable pro trial and I was wondering if there’s a way to obtain user info via API. It seems that you can only query tables using the API, am I right? Also - is the admin panel only available for enterprise users? I cannot find a way to explore admin capabilities using the free pro trial.

Hi there, I have a use case I want to test with airtable. I would like to update some .cjs files that are located on github using airtable data to update the values of certain variables. So for example, the .cjs file might have 5 variables in, and i want to send the value of these from airtable to github and update the file. the values will have been gathered from various stakeholder using airtable forms and views embebed into confluence docs. is this possible using the airatable API?

Hi everyone :wave: We are currently part of the OAuth Private beta program. We successfully set up an OAuth flow for getting the token to access the Meta API. We’re also able to create a new table and update table’s name although there is no documentation about this features here: Sign in - Airtable, so we’re wondering if this is fully supported and if it’s possible to update a table’s schema (i.e.: adding new fields and update fields type). Thanks in advance.

Guys, why don’t we have the method createViewAsync()? We can create tables now with base.createTableAsync(), but not views. It would be such handy because for each new volunteer we need a new personal view with predefined filters, and the creation of it would be very easy to put on the shoulders of Extension.

Hi all. I have a fairly quick problem. I’m a relative novice to JavaScript and coding, so forgive me if this is a silly question. I found some code that will duplicate a record and copy all fields, with the ability to exclude certain fields. I can fill in my table and exclusion fields, and it works as intended. The original thread is here: Script to duplicate a record with select fields only or create new item based on another Extensions We’re using Airtable as a PIM for clothing and we sometimes do modifications that creates a new style code. A lot of the information is the same (as it’s just a modification), but I don’t want to copy over any linked fields or certain notes on an item. I was wondering if it was possible to create a script that would let you select an item you want to modify and create a new item with select information from the base item. The links are in the same table FYI. I am looking to do exactly what was described in this post. T

I’m trying to create a certain number of new records in a table based on a number in another table. For example, if the # Field in Table A is 4, then I want to create 4 new records in Table B. Is this possible? Any idea how I’d do it with either Scripts or Automations?

From what I can tell, trying several different codes that are supposed to paginate Airtable data in Power BI, some people are getting them to work and some are still just getting 100 records. Has anyone who was just getting 100 records who has now gotten these codes to work describe what change made the code they were using work? Examples of these codes are found in these threads: JSON string only contains 100 rows when connected to Power BI Desktop API Hello! Little bit late to the party, but I got Power BI to fetch the paginated Airtable pages. What has not been implemented yet is a timout to avoid sending too many requests. Here’s the “Power Query” you’ll need: let Pagination = List.Skip(List.Generate( () => [Last_Key = "init", Counter=0], // Start Value each [Last_Key] <> null, // Condition under which the next execution will happen each [ Last_Key = try if [Counter]<1 then "" else [WebCall][Value][offset] otherwise null,// …

Hello, I see that there is an example script of deleting duplicates but I’m a little lost as to how to apply it to my table. Can someone help?

Hello, I am struggling to write the code to retreive the intersection cell of 2 dynamic entries: Lets say I have a table with: Milan Berlin Bruxelles Paris Milan Berlin Bruxelles Paris With the distances at intersection How can I retreive the distance for each user choosing one city in a row and one city in a column? Any help would be great!!

Hello! I feel like I’m so close to getting my script to run- I keep getting the following error with my below code- any ideas on this? Does it have to do with my last line as an await? let table1=base.getTable("August 1 2022 Issues- Onward"); let table2=base.getTable("Sprints-"); let junctionTable=base.getTable("August-1 Onward Sprint Junction"); let firstJunctionField=junctionTable.getField("August 1-Issues"); let secondJunctionField=junctionTable.getField("Sprints"); let joinType="left"; let tableLink=table1.getField("Sprints-"); console.log(); async function createJunction() { if (table1 === junctionTable) { output.text("First table can't be the same as the junction table."); return; } if (table2 === junctionTable) { output.text("Second table can't be the same as the junction table."); return; } if (firstJunctionField === secondJunctionField) { output.text("First junction field can't be the same as the second junction field.") } if (

Hi! I have a problem resizing the Button component in Airtable SDK: I need a tiny button, but even when I set size=‘small’, the button is still too big. I can set the size to a number (size={12}), and it works, but I get the following warning to the console: Does anyone have an idea how to fix it? Will the extension pass the revision on the marketplace with this kind of warning? Any help appreciated!

Hi, I have done my own scripting search app but how to prompt a preview with few fields showing and most importantly to be able to click on it to edit it when it finds it, like in the airtable search app ? Thanks

Hi, I wanted to run this by you to see if I am understanding my situation correctly. Any feedback is much appreciated. I created a browser extension that has a Google Sheets list of names of organizations and people and an Airtable base=>table with more information about each of those organizations and people. The extension checks on any webpage whether any of the names in the Google Sheet occur on that page. If so, the extension highlights those names on the webpage and when the user hovers over or clicks on the highlighted name a popup is generated that shows the information about that organization or person that is in the Airtable base=>table. The extension makes no changes to the Airtable, it only retrieves the data and presents it in a popup. No password/login is needed for the user of the extension. The extension uses the API of a read-only collaborator so the Airtable data are public and read-only. The Airtable is updated with new records and additions to existing records

Hi! I am implementing a webapp using the new framework from Shopify called Hydrogen. Connecting Airtable from my dev environment has been smooth. But, when I deployed it in the platform (Oxygen), I wasn’t able to fetch some data from the airtable and it gives me an error: TypeError: c.default is not a constructor . I would really appreciate if someone can enlighten me about the issue. I have been debugging this for a week. Thank you!

Hello! I am trying to upload a json string to a long text field in a table. In this example, I want to populate the metaData column with: {"json":"data"} Here are various strings I have tried passing to curl via both the command line (-d ) and via STDIN: {"records":[{"id": "reciTUyexGJBrfe3L","fields": {"metadata":"{"json":"data"}"}}]} {"records":[{"id": "reciTUyexGJBrfe3L","fields": {"metadata":"{""json"":""data""}"}}]} {"records":[{"id": "reciTUyexGJBrfe3L","fields": {"metadata":"{\\"json\\":\\"data\\"}"}}]} All of these respond with: { "error":{"type":"INVALID_REQUEST_BODY","message":"Could not parse request body"}} I tried searching these forums, and all of the issues with escape characters appear to be targeted to Formulas, and use the ", which is not working for me.

Hey All! Nice to find you! I am happy I’ve discovered Airtable as it seems to be quite a nice data management platform for my use cases. We are a team of two guys: one that manages data and me, the one who will consume this data via RESTful API in a web application. I’ve created four tables in base and linked them appropriately. All good for now. What I want when accessing the API is to have the links fully expanded (with all the data) and not just the ID pointing to a reference ID. Would that be possible? So, basically instead of (see Rewards key): "records": [ { "id": "rec2aPmtsQyMWL0gL", "createdTime": "2022-10-10T10:23:38.000Z", "fields": { "Type": "type", "ID": 2, "Luck": 1, "Order": 2, "Rewards": [ "reca2ZiYRTk0rqv9x", "recg2oisqku0f9kol" ], [...] I will have an expanded Rewards data: "records": [ { "id": "rec2aPmtsQyMWL0gL", "createdTime": "2022-10-10T10:23:38.000Z", "fields": { "Type": "type", "ID":

Hello I’m trying to query one of my tables and only return a list of records based on a list of record IDs. How would I write the filterByFomula query? I tried to join a series of queries like filterByFormula=(AND((_id%3D'{{record_id_1}}'),(_id%3D'{{record_id_2}}'))) However this didn’t work.

Hello, I am quite new to AirTable but have some JavaScript experience. I am able to script for changes to the data types I need (Date, numbers, single select, short text etc) but this last one has thrown me. In my test table (ConorTest) there are 3 fields Status - Single select Employee Currently Issued the Equipment Employee Previously Issued the Equipment With fields 2 and 3, the value in these fields is linked to a different employee table Field 2 - with “Allow linking to multiple records” NOT selected Field 3 - with “Allow linking to multiple records” selected When the status field is changed, I want to populate the second field with the value for the first (without overwriting what is there) Has anybody done anything similar? Thank you Conor

Hi, I have developed chatbots for different channels such as WhatsApp, Telegram, etc. I am currently using Airtable REST API to fetch the text field and attachment URLs and send them to Users as text messages and media files, respectively. The pieces of information and URLs are fetched at the time of the request i.e. When the user initiates the chatbot. Will the new change affect my chatbot workflow since I am directly fetching the URL every time the user requests the bot? Also, I read and I quote: Using Airtable as a CDN has been and continues to be discouraged in line with this change How can I avoid this? Any help or advice is appreciated .

I have 2 tables, staffs and works. there are 5 staffs. and there is a field called duties in my works tables. I would like to write a script to assign the duties in my duties field. I am using the linking record but I don’t know how to use the built-in methods to do so. can anyone help me thanks.

Does anyone know how set up a script to edit text fields (imported from xcel) - specifically I want a date + time text field to be separated into a date only so that I can convert it to a date field type for future automation processes. Example of what I want on the left and what I am working with on the right. I’m a complete newbie to scripting and pretty new to airtable generally so any advice is greatly appreciated! Update: I managed to work this out using another script for splitting fields — Split text to columns - #6 by Mike_Pennisi

Hi all, I would like to retrieve data from an API and update fields to a table. I have had trouble finding a basic example of this. I have been able to update one of my tables from a python module which really simplifies things but if I could remove the python from the process and simply do it in a script that would be great. If anyone had any links to share that would be awesome!

Hello All, I’m attempting to wire up a script to a button field. When the button is clicked this is what happens: all the fields associated with the clicked button’s recordID are gathered in an object: let data = { "field": "value", "field": "value", "etc...": "etc..." } this data object is then sent to a webhook via fetch post request What I have is this: let pipeURL = "webhook URL here"; let table = base.getTable("GPP Website Leads"); let view = table.getView("Grid view"); let queryResult = await view.selectRecordsAsync(); console.log(queryResult.records) This works, but only returns the recordID and the first field in the view. I’m sure it’s trivial but I can’t figure out how to loop through and get all the fields & associated values for a given recordID. The I could populate my data object with the fields and the values. Thanks for the help!

Update (June 25, 2020): The button field is now available for all users — read more in our launch blog post: https://blog.airtable.com/now-available-button-field :wave: Hey all — I’d like to announce the public beta of button field, a new field type that allows you to create buttons that trigger customizable actions. These actions include: Opening a link based on a URL formula Opening a specific record in page designer Opening an embed in the URL preview block Sending emails with SendGrid Perhaps most relevant to this community — you can use this new field type to run scripts directly from grid view, kanban view, gallery view, and expanded records. This will make scripts more readily accessible to end users and seamlessly integrated with their existing workflows. You can also customize your buttons with helpful labels that describe what your scripts do. When a script is run from a button, the first input.recordAsync call in the script will use the record the button was clicked

Greetings! I’m working on an airtable automation to operate from an interface button. the automation would do the following (the part im having trouble with is the script as the last step): from the rest of the automation im passing three values into the script as inputs: The original project record ID The duplicated Project Record ID a list of tasks that are linked to the original project (this one im not using for the script, but assume it would be more efficient to use this rather than query the entire list of 1000+ tasks. the script is currently “functional” but I’d like to make the following changes and im running up against my JS ability. use the list of IDs to make the script more efficient instead of the query when the fields are being set in that For loop, set the Project field to the new duplicated project as part of that same step. set another field called “Status” to the string “Planned”, otherwise all fields can simply be duplicates. Any help would be much appreciated