Development & APIs

Schedule repetition frequency of a transaction or event based (daily, monthly or yearly). Kindly provide suggestions or feedbacks for improvements. Especially, I want to workout more edge case issues. // Query for every record in “Table” let table = base.getTable(“Table”); let query = await table.selectRecordsAsync(); let srcDtl = await input.recordAsync(‘Select the row to repeat?’,table); if (srcDtl) { // Begin logic of creating repetitive transactions // Replace ‘Field’ with name of the field in your table let field = srcDtl.getCellValueAsString(‘Field’); output.markdown("#### You selected “”+field+"" as the source budget"); // Display frequency options let freq = await input.buttonsAsync('Frequency',['Daily','Monthly','Yearly']); // Replace 'Date' with date field in your table let srcDate=new Date(srcDtl.getCellValue("Date")); let nextDate = new Date(srcDtl.getCellValue("Date")); let ctr=0; // Obtain how m

DEAR ALL,Column type "link to another record" with "Limit record selection to a view"✔️When you try to select a value manually, the list is OK⛔When you copy/paste a value which is not in the list/view, it works ! Why ?BR

Hello,Can anyone help me?I'm trying to get the data from Airtable by using this scripthttps://github.com/sleiman/airtable-phpHere's the code<?phprequire 'vendor/autoload.php';$apiKey = 'tokenFromAirTableMyAccountSection';$database = 'AirtableTest';$tableName = 'Data';use TANIOS\Airtable\Airtable;$airtable = new Airtable(array(    'api_key'   => $apiKey

So if you have an Airtable Enterprise account and issue personal access tokens (PATs) tied to a service account.  Apparently, once you create 100 PATs, the interface WILL NOT let you issue any additional PATs tied to that service account:Honestly, this seems very arbitrary.  The workaround is to create *another* separate service account to issue new PATs, but this seems very, very janky.I don't understand why Airtable gates the max number of PATs per service account to 100 total, but it is what it is.  This is mildly annoying.  FYI. 

Hi, I have a client that uses an app working on a Firebird database. I'd like to develop new tools using airtable, connecting to the Firebird DB to extract data. How can I do it?Thanks! Frede

When automating from Airtable, all day outlook calendar events show as busy not free.Why is this basic functionality not available? It's causing issues for our organisation as users are not able to book time when we have an all day reminder from air-table. Other platforms like zapier etc have the ability to alter the state of 'show-as'.Is there anything in place to fix this?

How do I delete this orphaned sync?The original target table in Prospects is gone.

Hello all,I'm developing integrations with other third party providers where I can supply a URL and they ingest that information. However, I was told there were errors with the image.On investigation, the "type" provided by the API (image/jpeg). However, the HTTP Content type is actually binary (application/octet-stream) and the filename is inlined in the content-disposition. I understand this may have been used for file downloads, but this post seems to think this isn't necessary. This seems more like a bug, as really the "type" is provided by the API, so I'm not sure its not set b the content-type. Would this ask be possible? I've been running into this issue several times. My

Thought it's worth flagging the localhost security issue in Chrome again:I've tried setting various flags in Chrome without any luck. Am developing in Safari on Mac for now.

Hi everyone,I hope this message finds you well. I recently accomplished the successful synchronization of my Airtable base with my WordPress site using the Air WP Sync plugin. During this process, I also had to integrate Advanced Custom Fields (ACF).To map the content from my base, I utilized the custom field option within the plugin, and it worked seamlessly. However, when dealing with multiple selection type data from Airtable, I needed to convert it to checkboxes.Here's where I could use some assistance: I am unsure how to effectively utilize the selected options from these checkboxes. It seems that the plugin only compares labels, and I am unable to find any ID or value associated with the selections. I need to perform a verification of the received data but cannot rely solely on the label text.If anyone has experience or insights into working with the data received in WordPress through Air WP Sync, I would greatly appreciate your guidance.Than

Preamble: I’m still working on implementing some features in the Scripting/Custom blocks which I think would remove the need for most of the Airtable API calls the proxy server is making. But even with custom blocks, I think I will still need a “get records for base” call that needs authentication. Setup: Node.js app (12.x), Airtable.js (0.8.1). API key stored in .env file that’s loaded into process.env. My application relies on a setup like @Bill.French described here where there is a central “directory” that has a record per Airtable base. My proxy server can return a list of these records, which in turn gives me the Base ID to make CRUD calls to that individual base. This works great and performs cross-base operations that suit my need. The question: Until now, authentication hasn’t been much of a c

Trying to figure a code flow so that i can move some automation away from zapier and have them automated in scripting. the 1pm in delay just make it doesn’t work for our team.

Hi,I've been trying to learn and build a script with the help of ChatGPT. The script creates a report in Clockify and all works fine until I replace the value input variable from a fixed value to a feiled in the base from a previous step. The value is just a string but is actually a lookup from another table. I've tried to use a formula in another field and use that but both result in the error seen in the screen shot.I feel like I'm so close, any advise ?  

I am using a design tool (DBSchema) that can connect to most Databases in the industry, it typically uses a JDBC connection but has many others.  Does anyone know what drivers AIRtable uses and what the JDBC URL would look like?I could not find this in any documentation.Thanks in advance 

I am creating an inventory management system for a warehouse team. I have a table that tracks the current inventory level and a linked table that operates as "transactions". So the "transactions" table keeps track of added and removed inventory. The inventory table shows the current inventory level for a product using a roll-up. I want to click on a button in the inventory table to open a form where the user can add or remove inventory. I want the product name field to be automatically selected based on which row the button was clicked. So pressing the "change inventory" button on the Product A row will open the form and have Product A selected in the name field.  I tried to figure out how to do this with formulas and automation, but I think that it might need to be done with scripting and I do not know any javascript. I hope that all makes sense.

Hello everyone,I followed the following tutorial (https://support.airtable.com/docs/visualizing-airtable-records-in-microsoft-power-bi-power-query) to connect Airtable to PowerBI Desktop.I followed each step as required, my IDs are all correct, I even went to GitHub to grab the latest updated code. I also modified the authentication system as the tutorial explains it.However, it doesn't work and I get the following error message: "Sorry, we were unable to convert the null value to Record type."Could you please tell me what the problem is? I've looked at other requests on the forum and it seems to me that nobody has had a real solution?Thanks for your feedback,Have a nice day,

There's a public Airtable that I want to access via API, but I don't have admin permissions to the table (just the link to it). Is it possible to access this data? If it helps answer the question, what I am trying to do is create a program that allows the user to paste the airtable link and convert that data into a .ICS file.Thanks for the help in advance.

I need read-only users to be able to click a button and delete a record. I am just about to start learning JS (how many people are saying that now Airtable Scripting exists!) but currently have no coding knowledge! Can anyone help with a script I can run on a button being clicked to delete the relevant record? Thanks in advance!

I am creating a mapping from record_ids to view name. IIRC there is no better way to to do this than list all records in each view and then create this mapping. To reduce the traffic, I would like to return no fields, when I am traversing each view. However this doesn't seem to be possible as of right now. Would it be possible to add this option to API ?

Hello! When attempting to edit an app, I enter https://localhost:9000 into the Edit app dialog box, and I’m getting the following message: As well, I run into this screen when going directly to https://localhost:9000 in Chrome: This did not occur previously. I’m not sure what happened but I don’t know what I’m supposed to enable. There doesn’t appear to be an allow-insecure-localhost flag when I go chrome://flags/#allow-insecure-localhost. Any idea what might be causing this?

I just got metadata api and I’m trying to connect it with my airtable and get data but it is not connecting and keeps throwing me errors. HelloWorld = () => { axios .get( "https://api.airtable.com/v0/mykey" + "/" + 'Table 1', { headers: { Authorization: "Bearer " + 'api-key-from-airtable' } }, ) .then(resp => console.log(resp)) .catch(error => console.log(error)) } This throws the error of Error: Request failed with status code 404 and 404 not found. I tried performing a GET request on postman as well but it still did not work.

When initiating an OAuth authentication, it is possible to provide additional parameters, meant for custom use of the client application.These parameters are correctly passed to your https://airtable.com/oauth2/v1/authorize page, as URL query parameters along the standard parameters (nonce, response_type, code_challenge_method, scope, code_challenge and client_id).However when the redirect_url is called after a successful authentication, the additional parameters are not included. That would be a standard behavior your authentication should support.

Hey All,I'm looking for a way to add files that are not hosted on a public site. The server hosting the files allows for basic auth so I should be able to pass credentials. I'm wondering if it's possible to use `fetch` in an extension to get the file and then add the file to an attachment field. Definitely open to better ideas. Cheers,Collin

I built some scripts a while back using the airtable python API wrapper.  I was able to create new records in a table with linked fields using only the string value of the linked record. This was very helpful since I could upload records to 'Orders,' for example, and Airtable would accept a string, for example a Product SKU, to designate which Product to link to.Since updating to the more recent pyairtable wrapper, I'm not able to do this anymore.  I need to know the record ID of any record I want to include in a linked field.  This means extra steps.  Is there a way to use strings instead of 'array of record ids' as the value for linked fields?

Good morning,Following research to develop an existing project, I decided to try to stay on Airtable for my backend and I must therefore take into account the new standards that you will apply by February 2024. Indeed, I 'uses the plugin on my gatsby site, "gatsby-plugin-airtable", with a version of Gatsby V4.25.7 and this will be a first for me to make use of Token or OAuth system. Unfortunately, I have "little" information regarding the integration of this possible data via this plugin. For now, my API keys are stored in an .env file and imported via the dotenv package into my gatsby-config.js.So I have 2 main questions:1 should I favor the Personal access tokens API or OAuth integration?2 If using the Personal access tokens API is preferable, or easier to set up, should I simply change my API key to the value of the Token