Development & APIs

function blabla(){  // Replace the placeholders below with your own API keys and table information  var airtableApiKey = '-';  var airtableBaseId = '-';  var airtableTableName = '';    // Get the active sheet and the range of cells containing your data  var sheet = SpreadsheetApp.getActiveSheet();  console.log(sheet.getName());   var dataRange = sheet.getRange(3,1,sheet.getLastRow(),5);    // Get the values in the range as a 2D array  var data = dataRange.getValues();    var apiUrl = 'https://api.airtable.com/v0/' + airtableBaseId + '/' + airta

Hi there,I am trying to figure out a way to automatically select linked records via another field.I have two types of records:Property listings that are in a project(condo building or gated community) and listings that are NOT.Project properties I'm able to use Lookup fields to select linked records showing the District of the property.Listings outside of a community we must select the District manually.Now I need an automation to select the District on the linked records. It MUST Be a linked record as I will then sync with a Webflow real estate website and you cannot sync anything other than linked records if you want the. Webflow field to be a reference field.I figured out a script but I get this error message. I think it has something to do with the script not being able to select in the  Linked record. Please advise Error message:  Error: Field "fldQe8Zq6eDEjs99l" cannot accept the provided value. at main on line 43Script pic attached

is there a way to update multiple records including upsert on linked records?  // fld4nItZFaesqE3hi: 'Pet-Dose' is a linked record chunk=[ { id: 'recDZL0CMwcu8nh0w', fields: { fld4nItZFaesqE3hi: 'Pet-Dose', fld6kqVwPYlYRsI73: 0.715 } }, { id: 'recoAcgIEbo0vXqRv', fields: { fld4nItZFaesqE3hi: 'Pet-Dose', fld6kqVwPYlYRsI73: 1 } }]; //update records chunks.forEach(function (chunk) { airtable.base(baseID)('Artikel').update(chunk, {typecast:true}, function (err, records) { if (err) { console.error(err); return; } }); }); 

Hi everyone! We’re excited to announce a new beta feature for the scripting block: script settings! With script settings, you can define settings for your script: a title, description, and settings items (table, field, view, text, number, and select). From your definition, we render a settings UI. Users of your script can update the settings and run the script without needing to modify the code. You can sign up for the beta via this form. You’ll only be able to use script settings if you’ve signed up for the beta: if you’d like to test it out with your script users, please have them also join the beta. Please submit any feedback/issues here. Read on for more information about how to use script settings! To start using script settings, add an input.config() call to the top of your script. Use it to specify the various settings for the script. let settings = input.config({ title: 'My script', description: 'This is my script that does some things...', items: [ input.c

Using Airbyte, I was transferring data from Airtable to Google BigQuery. I was able to transfer some data, but some columns are missing. There were more than 70 fields (columns) in the original table, but only 17 have been transferred to GBQ. Several of the missing fields, as described in the documentation, are entirely empty. Unfortunately, about 30 columns with data are missing as well. Originally, I assumed that Airbyte was not correctly transferring all of the columns. Therefore, I tried a different connector, but I got the same result. Is there anyone who can explain why these columns are missing, and how to resolve this problem?

Hi!So I have a "Newsletter" table that has a linked records field that links to an "Events" table. I want to prepare my Newsletter with all the Events between today and 30 days from now. So I'm trying to link those Events to a newly created Newsletter.Since the "Find records" automation module doesn't provide a sorting feature, I'm externalizing my automation to Make via a webhook.There I use the "Search records" module that returns the list of Events I want, in the chronological order that I need to link back to my Newsletter.The problem is I cannot figure how to update multiple linked records. I've tried an array of IDs and an array of ojbects with "ID" parameter without succes.I'm getting these errors:The operation failed with an error. [422] Value "["recp52K5lovXI8Q8p","recMylG9MZx6O1kCj","recSgsOeULsCZhOzj","recG5cVdLPJTXxyN1","recXhysdl7joff667"]" is not a valid record ID.The operation failed with an error. [422] Value "[{"id": "recp52K5lovXI8Q8p"},{"id": "recMylG9MZx6O1kCj"

Hello Guys,We want to prevent some HTTP Methods for an API. We are using a contact form which is beeing used on our web site. We want to prevent all the HTTP Methods except the POST method.I have searched the panel, but can't find anything useful. Is it possible to prevent calling APIs for specific methods?Best Regards

I'll just leave this image for now in case PKM (personal knowledge management) and its relationship to Airtable matter.

Hi, I am new to Airtable. It appears to be a good product with zero support. I was hoping to find someone who can train me. I have a lot of questions and with each question, I seem to go down a rabbit hole watching video after video and it is taking way too much time.Is there anyone who can help tudor me? I would pay (of course). Things I need help on:creating a form that will populate 2 tablescreating a form that will update information on a table. (not overwrite)And this is just today.Thanks. Kira 

I'm missing two fields plus two new ones (4 Total) I have created in PowerBI from Airtable Base's. I'm extracting data from many Bases's, and only have a problem with a certain one. That data isn't special, the fields are simple "Single Select" Fields.I get no error's in the PowerBI query, it just doesn't show the four fields.

Hi allI've just got into scripting, and have fallen at the first hurdle. I thought this would load an array of all my records as objects, with each field in the object with its value as a a key value pair. let table = base.getTable("Contacts");let query = await table.selectRecordsAsync({fields: table.fields});console.log(query.records); However, it only seems to load the record id and record name. All other fields do not seem to be within the object.I have tried specifying the exact fields in {fields: table.fields}, and then console.log(query.records[fieldname]), but this also returns undefined. I'm coming from Python to Javascript, and I'm not a proffessional. Am I doing something dumb? Thanks in advance.

Heya, I’m trying to pass through an Airtable duration field as a string to Zapier but it gets converted from hh:mm:ss.ss to sss.ss Is there any formula I can use to preserve it as a text string value? Or alternatively a way to format the sss.ss back to hh:mm:ss.ss in Zapier? Thanks!

Hi there. I have created a time tracking app and used Airtable as backend. While it works perfectly for all get API requests I have troubles with post requests.Users need to fill in a duration that they have worked. While everything else works absolutely fine I can't work out how I can create an API Post request where the user can input the duration using h:mm format and not seconds. I can work around it in Airtable using the formula but it is not practical to have App users type in their work time in seconds.Is there a way to create a working post request? I am slowly starting to loose hope in Airtable. thx in advance

Hi!I am populating a table with plain text from user input via "Softr". I am now analyzing these entries via the Google Cloud Natural Language API to gain insights into Sentiment, Entities etc. and outputting this data into separate tables for each dimension I am analyzing.How can I make sure to automatically link the analysis in the API output tables to the original entries in the "Entries" table? I would need to do this to identify the analysis data back to the user that has entered the text.Thank you guys in advance!

Hi folks,I have a dataset that I want to import into a CMS for blogging.In order for it to import and display correctly, the field in Long Text needs to be in Markdown - Code Block format so that it can hold a large chunk of HTML rich text.Is there a way via Script or otherwise to automatically convert cells to be Markdown - Code Block by default, rather than clicking into each field, selecting all the text, and manually choosing Markdown - Code Block?Before state: Ideal state: Greatly appreciate any help!

I am developing an extension to manage orders based on an ‘Orders’ table and a (linked) ‘Order Line Items’ table. My next objective is to allow line items to be re-ordered by the user via drag-and-drop.I assume I can achieve this by adding a integer field to the table which gets updated by the drag event (?), but since this actually also is a native Airtable UI functionality and you can order records via drag-and-drop when your table/view isn’t sorted – I’m wondering whether someone knows anything of a custom order index being accessible or anything?I’m guessing not, since I can’t find anything like that in the API docs…But maybe you have other ideas to achieve this other than the one I mentioned? Or experience with a similar feat and you’ve got a js library you’d like to suggest or something?

Since the AirTable API was limited to 100 entries in PowerBI, we have manually inserted a code found on that video: How To Fetch Unlimited Entries in Airtable To Power BI via API - YouTube Now, data is falling into PowerBI? However, we connot set up automatic refresh of data. Do you know how can this problem be fixed? Meaning autonmatic refresh of data after unlocking the 100 entries limit. Thanks!

I've used Zapier on and off for the last couple of years for small purposes. This week I used it for something important, and I'm wondering if the approach I took is the best way to solve the problem.I have a list of people (about 120) that I needed to send and email to. The email contains a link to an Airtable form that I want them to fill out. I defined a date-time modified field in Airtable that I used to trigger the zap in Zapier. The zap then connected to my client's Google Workspace/Gmail account to send the emails out. I was a little worried about how well Zapier would perform, so I triggered smaller batches of records, about 30 at a time. In the end, it worked fine. We had to do a follow-up email, and I used the same process, just with a different body content for the message.I didn't ask Zapier to do anything other than connect (record by record) to my client's Gmail account and send each message. After each batch went out, I marked those records as "sent" by hand (easy in Air

hey,I would like to have a field or fields that inside them will be a table that workers will need to fill while they are filling the form.for example, I have some items that i need to have control on the expire date and the pressure of them, so i need that in the form I will have a table with the names of the items as a column that already will be there and two columns for pressure and expiring date that they will fill. after that I need it to be inside a field. Thank you for your help.

My team of 7 disciplines uses airtable, each having their own base.   Each discipline has the same structure, but different syntaxes to describe their tasks.   Every time I create a new tool or script I have to set it up in each base. I could really use some advice on how to manage these scripts.   Ideally a real approach would be to have some shared library that automations could access.  It seems a bit absurd to me to have to copy and paste redundant scripts across each base.

when i create records,got a reeor about Authentication,the message is:{“error”:{“type”:“AUTHENTICATION_REQUIRED”,“message”:“Authentication required”}} this is my code and data: url = “https://api.airtable.com/v0/appjiuXPDkRCdDkhs/Pipeline” h = { “Authorization”:“keyE5yxxxxxxxxgb0x3”, “Content-Type”:“application/json” } data_list = {“records”: [{“fields”: {“Name”: “a”, “Priority”: 3}}]} print(requests.post(url,data=json.dumps(data_list),headers=h).text)

I want to create a unique share(public) link for each record, so I will send created link to each user, so each user can be edited only one record.Is it possible?Thank you! 

I am making a Vue.js project using Airtable API. have been trying to load more than 100 records using pagination, but when I use the offset value provided in the JSON file (itr3SD4RZBfi8WqqN/rec2JbRgoFjMrwofM), I get the following error:Uncaught Error: Airtable: invalid parameters for `select`:* the value for `offset` should be a numberHow could I solve the problem?

Hello Airtable community,Can anyone help me with sorting the list of records based on the created time via api? I would like to to get the order where the recently created record stays on top.Thanks in advance !

I'm issuing the following request to Airtable from Retool via the Sequin Proxy:{    "request": {        "url": "https://proxy.sequin.io/api.airtable.com/v0/{BASE_ID}/sample_requests_raw/{RECORD_ID}",        "method": "PATCH",        "body": "{\n \\"fields\\": {\n \\"Status\\": \\"my_status\\",\n \\"my_multiselect_field\\": [{name: \\"my_multiselect_field_value\\"}],\n }\n}",        "headers": {            "User-Agent": "Retool/2.0 (+https://docs.tryretool.com/docs/apis)",            "Authorization": "---sanitized---",            "Content-Type": "application/json",            "X-Retool-Forwarded-For": "49.37.243.51",            "x-datadog-trace-id": "2270676987214102529",            "x-datadog-parent-id": "168354330109794