Development & APIs

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?

Bonjour j’aimerai savoir comment fait-on pour intégrer notre logo dans un formulaire fiche ?  

I am trying to use an external API to automatically update some fields in my base based on a record ID using the script below.let table = base.getTable("Tracker");let view = table.getView("US");let query = await view.selectRecordsAsync({ fields: ["appNo"],});for (let record of query.records) {let patentStatus = await remoteFetchAsync(`https://developer.uspto.gov/ibd-api/v1/application/publications?patentApplicationNumber=${(`${record.getCellValueAsString("AppNo")}`)}`)let data = await patentStatus.json()But when I run the request the response I get back is an error with the message "Invalid SSL Certificate."If there a way to work around this in Airtable?

Hey there. I’m trying to set up some script to automatically input my Images URL to Attachment. I found some code in this forum but I’m running into errors that I don’t understand. Code I’m running: let table = base.getTable('PhantomBuster'); let query = await table.selectRecordsAsync(); for (let record of query.records) { // if the attachment field is empty if(record.getCellValue('Image URL') == null) { if(record.getCellValue('Attachment') == null) { let recordId = await table.updateRecordAsync(record, { 'Attachment': [ { url: record.getCellValue('Image URL')} ] }}) } } The error I’m running to is: SyntaxError: missing ) after argument list on line 1 at s on line 1 at Generator._invoke on line 1 at Generator.next on line 1 at t on line 1 at a on line 1 on line 1 on line 1 Can anyone help? Thanks

I am supposed to have data from a Typeform populate two different Airtable sheets through Zapier. The first one is an Airtable base that I created for my own use. The second one is a class-shared base. I believe I have set up my Zap correctly because when I fill out my Typeform, the data is correctly entered into my personal Airtable. I set up the shared Airtable the same way, however, I cannot get any data to show up. Any ideas why this is not working?

Hi,We've been using HubSpot integration for several weeks now, but in the last days, the integration has been repeatedly interrupted by Airtable, and everytime we reconnect it, it was disconnected again after few hours, and finally permanently revoked (see screenshot attached). We've reach out to HubSpot support but they don't know what is happening since everything is working fine in their end and the integration is disconnected on Airtable's end. Regarding auth token and permissions, we haven't done any change in the last days that might trigger this interruption.Could you please assist us on how should we proceed here in order to re-run this integration again without facing new interruptions? Thanks in advance!

Is there a way to automate a New Grid View when there is a new record in view? Here’s the flow: A new record is in view Create a view. Use a field from the new record to create the filter for the view Save the view as the Name. I’ve use web scraping tools and Zapier and have had no luck. The web scraping tool I use does not like Airtable. OR is there another way to share just a record with someone? We use the shared grid view to give our contractions information (what we owe them, their log in to our app, etc.). We automate everything but just this step. Thanks in advance! :slightly_smiling_face: I’m a business owner, not a coder. I feel I’m in over my head on this one. :worried:

Hi, I have 20 records in my Base that were accidentally overridden by an Integromat automation. I need to restore the records to a previous version, but “Undo” will work, and there is no Snapshot for that time period. I can see the previous edits in the Activity Log for each record, but it looks as if I can’t access this data through the API. Is there any way to restore records to a previous version based on edits in the Activity Log of a record, rather than a Snapshot? If there’s not a way to do this within Airtable itself, is there any third party software that you can recommend to extract this data? Thanks for the help!