Development & APIs

Hi I have an automation script, and run into a problem, it is not fetching the right recordId in the script, but it does in the previous step. Anybody with a larger brain that can se what I have done wrong here?All the BestJesper

Hi all,  We are a small nonprofit (team of 14 people), who have been using AirTable for the past year and a half. We love its many functionalities. One thing we're hoping to do is integrate some emails into AirTable. Specifically, we want to write a record to an AirTable base when an employee CC's a certain Google Group email. Has anyone done something like this in the past? Would love to see examples if you are willing to share. Thanks,Alex

Hello everyone!I have a database with multiple linked tables and I have a JSON response with which parts I need to update corresponding records in those tables. To achive that (as I'm thinking) I need to solve a simple problem of zipping two arrays into one. Say, I have [rec1, rec2, rec3] and [val1, val2, val3]. I need to get a zipped array [[rec1, val1],[rec2,val2],[rec3, val3]]. How could I make this transformation with Make? Any ideas?Andrey

Hi Community,I am developing an airtable base with interfaces that manages requests logged by a contractor to a consultants on a construction project and also allows the consultants to respond.I need help with it to add some features on it (Kind of out of my depth).Kindly reach me on meisternbim@gmail.comIt's very urgent.Thanks.

I can’t seem to get <RecordCard />s to play nicely as flexbox child or reliably fit 100% width of its container. The default width of a record card is set to 568px wide, which wouldn’t be much of an issue if this were taken care of in the class applied to record cards. Instead, the width (and height) are set with inline styling. Since the width default property won’t take “100%” or “auto” as valid inputs, I can’t use either of those. Setting width to {-1} kind of works by removing the inline styling and getting it to fill its container, but all the record’s fields disappear: I could apply a class with width set to “auto!important” to override the inline styling, but “!important” is not generally good practice. Anyone have some advice?

Hi,I'm getting this error when trying to append to a linked field. The code in question is: ModelRange.updateRecordAsync(record, {'Models List': [...record.getCellValue('Models List'),{id : BMRecord[0]}]}); I'm pretty sure that 'record' is indeed a record object, as it's obtained from  let query = await ModelRange.selectRecordsAsync(); let record = query.getRecord(another[0]); where another[0] is a record ID. Let me know if the rest of my code is needed to diagnose the error, although I can imagine that I'm missing something obvious.Thank you!

Hello, I am trying to write some automation that should call some function in our server through a script and pass as input the image data that is stored in some field. How can I pass the image data ?The url I get there is private and  inaccessible through the server. I tried to convert it to base64 but FileReader is not available, also to pass the binary data using FormData but it is unavailable as well .Any help will be much appreciated.Yaniv

Hey thereI created a simple invoice document extension for a table. Now the new year is coming I created a new table and when I duplicate the extension, choose the new table the extension is empty. I guess the connection/affiliation to the fields are incorrect.My idea would be to create an extension template so I can duplicate it and use it for multiple tables. Is that possible or is there an easier way?

Hi all, I need to know if it is possible to somehow create a process to receive incoming data from a form on an airtable Wix site, There will be a form on my site to fill out and I would like this data to be passed to airtable. if it is necessary to write code or if there are tools dedicated to this function, any help and advice is valuable. Thank you.

Within an HTML form, my users must submit a photo that is critical for validating accompanying data in the submission, but I cannot get Airtable to recognize my attachment as an image.The form is processed with Google Apps Scripts, saving the image to my Google Drive (w/ public permissions), returning the newly created url. I then pass that URL to Airtable via a webhook and the file is uploaded in the appropriate field, however, I cannot get Airtable to recognize the file as an image. Instead, it's given a type of 'text/html' with the name of 'convert' (the name is of no concern, only mentioning it in case it helps to expose the issue).Ive tried creating/saving the file to my Drive as a blob & base64 -- I've tried setting the file type upon saving to Drive and I've tried without -- all successfully saving as images to Drive, but not once recognized as an image in Airtable. I've tried sending the Drive url as-is and I've also tried removing some of the included paramters.I'm at my w

Hey all!I'm trying to embed some search functionality on my personal training website, so that users can search for trainers in our team by postcode or specialisms, and then click through to the URL of that trainer once they've found them.My understanding is you can't currently embed interfaces using Airtable.I've started using Glide recently, and it offers this functionality but unfortunately it looks like you have to pay for the whopping £250/month business plan for the privilege. Eek.Does anyone know of any other platforms that offer this functionality, e.g. Softr etc? It may be worth a small subscription fee if I can find the right platform.Thanks in advance! 

I have successfully gotten airtable to upload a PNG and a PDF from Dropbox. But when airtable processes the file, the type is listed as text/html If I include a type field, I get an error: { "fields": { "Type": "Test", "Comment": "", "Attachments": [ { "url": "https://www.dropbox.com/s/XXXXXXX/robots.png?dl=1", "type": "image/png" } ], "User": "", "Part": [ "recFI6JhdkwTCeB9q" ] } } And I receive this: { "error": { "type": "INVALID_ATTACHMENT_OBJECT", "message": "Invalid attachment object for field Attachments: {\n \\"url\\": \\"https://www.dropbox.com/s/XXXXXXXX/robots.png?dl=1\\",\n \\"type\\": \\"image/png\\"\n}" } } But if i just strio out the “type” there is no error, just the type is wrong.

Hello everyone! Relatively new to scripts, but I think I am starting to get the hang of it.Basically, I am trying to convert a currently overloaded automation into a script for easier maintenance and better customization. Overly simplified automation process:If record is updated > set [Ticket Status] = [Status] for that recordThe script so far: let table = base.getTable("Quick Adds"); let inputConfig = input.config(); await table.updateRecordAsync(inputConfig.RecordId,{ "Ticket Status" : inputConfig.Status }) console.log(`The value of Status is ${inputConfig.Status}`); If I remove the "await" line, everything runs and it outputs the status value. When I run the script with the addition of updating the second field, I get a "Error: Field "fldjRCz6y0ku2XxIY" cannot accept the provided value." for line 3.inputConfig.RecordID is the @ Airtable record ID fieldinputConfig.Status is the Status field

I am currently developing a restaurant app in Bravo connected to Airtable, and I could use some assistance. I've created a script on Airtable that selects a random record from my database of restaurants. The objective is to display the image of a randomly chosen restaurant from Airtable when a specific button is clicked within my Bravo app.I'm facing two challenges:I need to make an API call to my Airtable script, but I'm unsure how to obtain the API URL for the script. In the image enclosed it's said "your script code (including any sensitive data or API keys) will be visible in shared base links" but I don't see the result of the Airtable script in Bravo. Is it due to my billing plan?I'm struggling with data binding to trigger the event in Bravo and execute the script.Your guidance on these matters would be greatly appreciated. Thank you in advance for your assistance!

Hello,Looking at the current Airtable fields API, there doesn't seem a way to view or modify the filters for count and rollup fields. If I look at the field options for either of these field types, this does not seem to be supported. Is there a possibility to create a rollup field with a filter programmatically, and/or to see which filters are applied on an existing rollup field?If this is currently not feasible, do we know if there are any plans to implement this in the future?Thank you in advance.

Hi, I am super new here. I want to create a database for ecom owners with linkedin contact and etc.My question is how do I create an airtable where I can show a preview like only 20 / 5000 entries. If they want to view the rest they have to subscribe?Would really appreciate your help. Thank You

I'm not authorized the table in my vs code using nodejsAirtableError {error: 'NOT_AUTHORIZED',message: 'You are not authorized to perform this operation',statusCode: 403}

I was wondering if there is a way to fetch data of all automations that are created in my account, as well how many times they were ran. I tried to find an API for this, but didn't found.

HI everyone,I am a beginner and am trying to connect airtable to make.com and chatbotbuilder.ai.I need to construct my API URL and I'm not understanding where I need to go to find it.I also need my API Key (Is this just the TOKEN ID?)I know these are very simple questions but thanks for any help in advance it is much appreciated! 

Hello Airtable community,I'm developping a custom extension for my base. I would like to put in background of the an image.I've tried with a stylesheet without success actually. Is there a way to do it ?Many thanks,PP

Hello, I am trying to write an Airtable automation Script where I am trying to create a new record to an existing table that has 4 fieldsFriendly Name (String)Platform Name (String)Platform Type (Prefixed Value)Data (Self-reference Linked Records field) When I run this code where I am setting all the values except the "Data" field because I don't want the new record to be linked to any other record   const data = { "Friendly Name": d, "Platform Name": d, "Platform": {name: "Launch"}, } const record = await table.createRecordAsync(data) I keep getting the same error ERROR Error: Field "fldtUMUOntLLXvVx8" cannot accept the provided value. at <anonymous> on line 121 at <anonymous> on line 137 at main on line 43  where fldtUMUOntLLXvVx8 is the field ID for the "data" field.  Can someone help me understand what I am doing wrong. I just want to create the new record without any interlinking

I created PAT as followed in documentation and copied it's token but I can't use it.I do get an "Error 403" in Make when I use my PAT there and I also get "Invalid Personal Access Token" in Xano.I checked the documentation regarding it and it seems I don't understand how to use it since I only wanted to use the template as base here in airtable and use it's table in Xano as a test data.

I've been trying to update a multipleCollaborator field without overwriting. Specifically I have a lookup field with user IDs and I'm trying to copy the same IDs (hence collaborators) to another (empty) collaborator field.This should be relatively simple and yet i get a "TypeError: record.getCellValue is not a function or its return value is not iterable" // This script downloads all the Auto-Requester's Collaborator IDs and re-prints them in Requester const config = input.config() const recordAT = config.recordAT const autorequester = config.autorequester const requester = config.requester const table = base.getTable('Deliverables') console.log(autorequester) for (var arID of autorequester) { let queryResult = await table.getView('All All').selectRecordsAsync({fields: ["Requester"]}); let record = queryResult.records.find(r => recordAT) console.log(record.getCellValue("Requester")) await table.updateRecordAsync(recordAT, { 'Requester' : [ ...

Hello, I just made an API request to Airtable that failed, and I don't have enough traceability data to inform me about the details of the request for which the API request failed (e.g.: the different fields and values in the request body).Is there any log store where I can see all the requests (or at least just the failed ones) made to my Airtable base via the API? Or is there any way to query for these failed requests via an interface/API?

MySQL or PostgreSQL or MongoDB or some KV Database? (include table fileds and view and record)SQL or NoSQL?And what is the structure of the table of database?