Development & APIs

Hi, Could someone demo this script showing how to properly create the parent/child and template tabs to utilize this script? I am having difficulty getting it to properly work. Thanks.

Hello Airtable Community,I'm working on a script in the Airtable Scripting App that processes a table with 1700 records. The script is designed to fetch records from the table, generate tracking links using the Impact.com API, and update the records with the newly generated tracking links.Unfortunately, I'm experiencing an issue where the script gets stuck at the "Fetching records" step. The script does not proceed to fetch any records or send API requests, and no further logs are displayed. I've tried various approaches, including fetching records in smaller batches, but the issue persists.Here's the latest version of the script:let settings = input.config({ title: "Add Impact.com tracking links", description: `This script generates Impact.com tracking links for the specified Envato links and adds them to a new field in the same record. To use this script, you will need an Impact.com API key, affiliate ID, program ID, and media partner property ID. You can learn more about the

I want to Create Record by API and one field "Multiple choice" throw error.I want to add "Other" value and I get "Value not found in options in parameter"And when I try add this option I get error, even if it's one of valid option In other cases like "SP z.o.o.", "SP akcyjna", "SP komandytowa", it work well.  

I’m pretty new to JS, but trying to learning all the time. Some of the first code I wrote in the scripting blog has gotten supper hard to update, so thought to experiment to write small modules to keep divide up the code. However it seems I can’t put buttons into functions? let test = function () { let firstClick = await input.buttonsAsync( 'What do you want to do?', [ {label: 'Check todays rate', value: 'today', variant: 'danger'}, {label: 'Convert currency', value: 'convert', variant: 'primary'} ] ) } this gives me an error saying ‘SyntaxError: await is only valid in async function’ does theis mean my button can only be used in the global scope?

Hi,I need to lookup a value from shipping rate tables based on the weight value from another table.I have two tables I need to look up data from, an example of one is below, The other is the same structure but different data.This is my source table containing my weight values.I need to select a value from the 2nd column on the above table, when the weight in my source table is between two row values.For example, if source weight is 7.75kg, it should return 53.3 for the rate.Hope someone can point me in the right direction 😁Thanksjohn

We are assessing AirTable for our Website and it works great. The last thing is a full text search.The only way I've found is to list all the records with a filter such as:filterByFormula=OR(FIND("search phrase", Field1), FIND("search phrase", Field2))Is this the way to achieve this or is there a more efficient way?

My app is using OAuth integration to authorize access to Airtable. However, if users want to switch account, they need to log out first. Are there any log out URL ? I cannot find it in Airtable. 

Hi, I am trying to find a workaround to Airtable's limit of 20 syncs coming into one base at a time. I have two bases, and I would like around 30 tables from the first base to sync with the second base. Can anyone recommend the best approach, in light of the limit? I could write a script to sync the relevant tables each time it is run, but this would be very laborious. I have heard mention of webhooks as possible solutions to similar problems but I do not know much about these and whether they would be suitable. 

I have created an app using Wized that allows a user to type the name of a city into a web form and get back the current weather conditions for that city.  I've saved the various weather icons into an Airtable base.  My Wized app uses an API call to Airtable to fetch the name of each icon and display the associated icon (PNG) file in a div on my web page.The problem I'm having is that when I run the API request, I get back this error:{"error", "Error: configuration does not exist"}Status code: 500Server errorI understand what 500 errors mean but I can't figure out why I'm getting this error. I'm calling the correct base "Wized Weather" and table "Weather icons" in my request.I'm using the correct personal access token for my workspace.I have a Pro plan paid account so there shouldn't be any account issues.I've attached a screenshot of the entire request below.Can anyone tell me why I'm getting this error?  Are there some permission settings I need to update to

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?