Development & APIs

Hello,since recently I've a bug with embedding's airtable on my website. it says "airtable doesn't authorize the connection".Anyone knows how to solve this bug? thanks  airtable Support hasn't been able to help me

Hi All,I am having an issue with my script:When using an integer value in the condition, the script works.Example: return all records that have a value higher than 9 in the field name "Bedroom": const propertyTable = base.getTable("Listing"); // Read the data from my Listing table const recordsFromproPertyTable = await propertyTable.selectRecordsAsync (); //Filter records matching a condition const matches = recordsFromproPertyTable.records.filter((records)=>{ return recordsFromproPertyTable.records.find((potentialmatch)=> { return records.getCellValue("Bedroom") > 9; } ) }) console.log(matches) When trying to match the field value with a single select or multiple select field, I am getting the following error:This condition will always return 'true' since the types  and 'string' have no overlap."I am pretty sure this is due to the fact that I am comparing an Array with text but I am not sure how to solve this:Return all records tha

Hello,I would like to know if changing my extension name and the dev contact is possible. I tried to find the solution in the code but didn't find any information. Do I have to recreate a new extension with the name I want? (I know I can change the extension name after but I would like to see if I could do it directly)Best regards  

Hey can you kindly tell how to generate Api key for air table . Is air table generating api keys or not? I tried every method i get a personal token but key isn’t generating. I also pasted personal token at the place of api key but it gives error 401 in voice flow

Hi, my currency script can be run manually but fails when run via automation. I'm using the standard, "recommended" currency script.  See attached image. 

I want to download attachments from one of my tables via the API locally:If I open and download the file from the UI, it seems to download them from a S3 server. Is there any way to automatize or mimic this behavior via the API?

Hiya AT community, I was hoping someone would be able to shed some light on my issue, as I haven't been able to solve this one on my own!I have a script that is performing some updates to a stocktake via a script. It will find matching items and then update the value in the number field. My confusion here is that it is working for one field and not the other field, I have tried different strategies to try and get an error or figure out why, but the field ID is defs correct and the field name used instead also produces the same result. Any advice would be appreciated 🙂I'll try add the relevant code to the issue..This if statement works as expected if (newStockMatches){ if(storageLocation == "Warehouse"){ console.log(newStockMatches.id); recordsToAddStock.push({ id: newStockMatches.id, fields: { 'FIELD ID IN STRING FORMAT': newStockMatches.getCellValue('FIELD ID IN STRING FORMAT') + qty // Warehouse fiel

Hi... I can use a little bit of help here from the experts....  We currently have a Google API integration with Airtable  on a project and we have set up routing and it is working well to create and updates routes (route records) within AT for us, but we don't know how to do 2 things we want to do:I don't know how to get an actual link back from Google Maps to the route record (we are using Make for this integration) to just show the route (waypoints) on an actual google mapI am wondering if there is any way to update the route waypoints (drag and drop on the map into a different order) and have it actually update the route records in Airtable when we adjust the route order on the actual map?

in what i am working ?i am working with a bot the bot ask questions and the response have to apered in airtable but its not working i try to fix it with a staff of botpress that is were i do the bot but they told me that it was an error of air tableconst airtableAccessToken = 'patrKShGndYDE36XQ.c35584fd7450be9fba9669453b09eac22583d3aa7d584d5b42ce7ede4da3822b';const variables = {name: workflow.name,email: workflow.email,phone: workflow.phone,budgetforproject: workflow.budgetforproject,service: workflow.service,adress: workflow.adress};const url = 'https://api.airtable.com/v0/appFWL0WUh6Sd78Im/color%20flux%2023';const headers = {Authorization: Bearer ${airtableAccessToken},'Content-Type': 'application/json'};const response = await axios.post(url, { records: [{ fields: variables }] }, { headers });console.log('Variables sent to Airtable:', variables);console.log('Airtable response:', response.data);this is the code i dont know where is the problem can someone help me

I am attempting to authorize an AirTable application to use OAuth with Matillion ETL (an orchestration tool).I am getting a an error while trying to authorize the application, related to the "state" field not being configured correctly. Can anyone help?

Hello, I am creating a json object from my airtable data to send it to a google script: //Table Bail --> xxxxx //Table Locataire --> xxxxx //Table Facturation --> xxxxx //Table Roof --> xxxx //Table Chambre --> xxxxx let url = "https://script.google.com/macros/s/XXXXXX"; const id_bail = input.config().id_bail; //Recupere l'id du bail let table_bail = base.getTable("xxxxxx"); let query_bail = await table_bail.selectRecordsAsync(); let record_bail = query_bail.getRecord(id_bail); //on filtre la base en fonction de l'id du client ////////////////////////////////////////////////////////////////////// let error_log = record_bail.getCellValue("Error_Log") let bail_statut = record_bail.getCellValue("Statut_bail") if (error_log !== null){ console.error(` Oups, une erreur est survenue: \n${error_log}`) } else if (bail_statut !== "Fini"){ //Table Roof let id_roof = record_bail.getCellValue("Roof"); //id_roof associé au bail let table_roof = base.getT

I know that there is already an automation that allows for Airtable to send SMS to Twilio, however I am looking to put together something more advanced. I want to use Twilio Studio to create a flow that would remind clients of their appointments (the client's information comes from AirTable, the date/time, and numbers come for a table) I want it to call landlines or text cell numbers to ask if they want to meet remotely, in-person, or reschedule. then i want the responses to be recorded back into AirTable under the client. How can I set this up?

 Hi, i don’t understand… maybe API KEYS BUGGED ?   

I am running a function on gform_after_submission in WordPress. It creates an new record in a large AT. We are finding more often than not the submissions works in Gravity Forms but the record is not created in AT. I have error checks in my function that makes the AT connection and it doesn't throw anything, including any error from the curl itself. It seems to leave the function formatted correctly and without error. no curl_error.This happens maybe 8 out of 10 submissions. We can find nothing different about the data in this submissions. It seems to be on the AT side of things. No one throws an errorIs there any log where I can see if these submissions make it to AT and are being rejected? I need some help on where to look next! Please and thank you.NOTE: Updating records from the same form works just fine. Never errors. It is the creation of a NEW RECORD that doesn't go.Frustrated. Jon 

hi,i am interested by the update of API key, i have some application where i linked them with some table in airtable, so for that i have this question : after January 2024 the request of getting data from the table in airtable will stop working in my app, so if that true what i need to do, i need to update my application in store or not ?

I'm attempting to setup a Webhook from Jotform to Airtable. However, I'm never able to get past the Test portion.I have:Started the Automation in Airtable, selected When webhook received.Copied the webhook URL provided by Airtable, and pasted into the Jotform Integration Webhook.Submitting the form in JotformAirtable always says This URL has not received any requests recently.I setup a webhook API on https://webhook.site/, and updated Jotform with new webhookSubmitted form again, and immediately received webhook message on https://webhook.site/.This leads me to believe that Airtable is not functioning correctly. Is there a reason why Airtable would not properly accept my webhook? Account type? Form type?

We've removed forms because me and my other users need to input info on mobile most of the time and if one makes a mistake or needs to adjust data, a form is not user friendly (submit form > realise mistake (or not) > open airtable app > find relevant table > edit). However, a spreadsheet isn't *that* user friendly on mobile either. It can be easy to miss an input column. Some columns generate information for the user as they're submitting data, so inputting data is also creating actions for the user at the same time. Therefore, not every column is an input column, and it can be easy to miss one on mobile view.This could quite easily be resolved with colour coding columns - or some way to highlight input/vital columns. It would also make certain complicated tables easier to read and interpret! I use lots of filtered views, but some tables have 15 views for interpreting data - and to be honest, I'd rather have fewer tables, with clear sections so I don't need to fl

I'm writing a script that will update my airtable dynamically with new tags that will sit in a multi-select field. I know that I can use { typecast: true } in my call to airtable, but I'm still getting an issue when updating it. I'm pretty sure the issue is either in how I've set up my object for Airtable or the placement of the { typecast: true } option. Here is the partial method that creates a record in my airtable await this.table.create( batch, // batch of records to be updated, see below for structure { typecast: true }, function (err, record) { if (err) { console.error(err); return; } console.log(record.getId()); } ); Here is the object (batch) that I'm sending through fields: { name: 'a new record', categories: [ { name: 'Item 1' }, { name: 'Item 2' }, { name: 'Item 3' }, { name: 'Item 4' },

Dear Team!Can you please check the below error ?Error while submitting AirTable entry{:ok, %HTTPoison.Response{status_code: 403, body: "{\\"error\\":{\\"type\\":\\"INVALID_PERMISSIONS_OR_MODEL_NOT_FOUND\\",\\"message\\":\\"Invalid permissions, or the requested model was not found. Check that both your user and your token have the required permissions, and that the model names and/or ids are correct.\\"}}", headers: [{"Date", "Tue, 19 Sep 2023 09:31:26 GMT"}, {"Content-Type", "application/json; charset=utf-8"}, {"Content-Length", "251"}, {"Connection", "keep-alive"}, {"Set-Cookie", "AWSALB=f+uz31NlfZTNrWX1gThigET2URThzvJkGvNuDsHJ5Y5CRhVAdfRVj6cmGOMqzTceIj8RkgHwIv1RUwpUGlwK6i9sm2JlZ+Iea5Roi9YqIWmLTiM4nfDEeFA1fORD; Expires=Tue, 26 Sep 2023 09:31:26 GMT; Path=/"}, {"Set-Cookie", "AWSALBCORS=f+uz31NlfZTNrWX1gThigET2URThzvJkGvNuDsHJ5Y5CRhVAdfRVj6cmGOMqzTceIj8RkgHwIv1RUwpUGlwK6i9sm2JlZ+Iea5Roi9YqIWmLTiM4nfDEeFA1fORD; Expires=Tue, 26 Sep 2023 09:31:26 GMT; Path=/; SameSite=None; Secure"}, {"Se

I need to create a fields + network field based on the below image, How can I achieve that in the airtable table?

Hello Airtable communityLooking to you for help / direction with a problem a client of mine has. They are auctioneers, and use Airtable to manage their business, specifially to load properties and other assets onto Airtable, which displays on their public facing site via an <iframe>.The challenges he faces is that every time someone registers to bid on a property, they have to go through the registration process from A to Z. My clients wants a solution where their client registers an account on either Airtable or the Wordpress instance, so that they remain registered for all auctions. Secondly, they'd like to take payments on the site as a deposit for the auction. This is easily done with a simple Woocommerce install, but was wondering if something exists within Airtable to facilitate this payment.Thanks in advance for your kind assistance.Regards,Willi

I have a table that includes about a dozen fields.  I've noticed that the list-records method won't include columns from the table if the columns are missing a value.  Is there a way to include missing-value columns in the results?

Hello,That's certainly a silly question.In the recent past, I created interfaces for which I had full rights. I was able to adjust the position of fields, their size, etc.Today, still with full rights, I've gone back to the same bases and recreated interfaces, but I'm no longer able to modify the layout, size, etc. of the fields.It's very annoying...Here's a short film : https://youtu.be/n4yvkNTfv9cThanks in advance,Erwan

Hello,I'm a new to the AirTable API and trying to automate adding records with data from another API.  I have this function: async function updateCrewRecords(data: CrewDetailsType[]) { const crewBase = new Airtable({ apiKey: AT_API_KEY }).base('appxxx') const table = cewBase('tblxxx') const records = data.map((crew) => ({ fields: { CrewID: crew.CrewID, CompanyID: crew.CompanyID, IsActive: crew.IsActive, Position: crew.Position, }, })) try { // const response = await table.create(records, { typecast: true }) const response = await table.update(records, { typecast: true, performUpsert: true, fieldsToMergeOn: ['CrewID'], }) } catch (e: any) { const errorMsg = `updateCrewRecords(): ${e.message}` console.log(e.statusCode, errorMsg) // throw error(e.statusCode, e.message) } } The commented out table.create(records) works as expected, but the upsert doesn't.  The error I'm getting is:422 updateCrewRecords()

Sendgrid has been working fine, sent emails yesterday, all of a sudden I have a missing root. Got new key, restarted. Tried different tables views. Still emails are suddenly failing and getting the above error. Help!