Development & APIs

Folks, I need to make a simple action: When a form is submitted, I need to automatically update a field on all the records on one view to a specific value. How can I do this through scripting?

Hi all, I have two tables that I’d like to link to each other via automation. As the data is flowing in via integrations from 2 different data sources with no common ID, I need to try to map those values. For example In table A I have a field with Name “Abc” In table B I have a primary field with Name “abcd” Now I would like to link those two tables by matching those values that are closest to each other. In Excel that would be done with a “LIKE” operator. How would you approach this in Airtable? Is it possible to do it in automations? And if not, via scripting?

I’m using airtable as a way to keep a product catalog for my company, both out of stock, and currently available products are listed, as to help customers compare products they like but may be out of stock, against our current inventory. Is there a way to script some code to identify specific markers (Flavors, similar categories, etc.) based on user selection/input, and for airtable to automatically recommend a similar product? I’m not well versed in coding, so any assistance would be appreciated!

Hi Team, We have almost 20 air tables,views and each view is attached to 1 air table form. for e.g. Airtable Name: internal_link<CUSTOMER_NAME> Airtable View Name: internal-linking-<CUSTOMER_NAME>-views Airtable Form Name: internal-linking-suggestion-<CUSTOMER_NAME> Likewise, we have 20 tables, views and forms for each customer. Each form is having field named as Source Category which is of type multi-select. The values in this field are different for each customer. Right now, I have provided these values statically by some manual work.Now i’m looking forward to update these values in every form dynamically with respect to each customer. FYI. The data for Source Category field is available inside snowflake database. You can say. snowflake database is source to fetch the values fo

Hi all, I have been stuck on this for awhile now, would appreciate any help! I’ll try my best to explain: I am trying to create an automated tagging solution to read through a text field and tag it in a multi-select based on specific keywords. Where I am running into trouble is after I push items into the array, those items stay in the array and each record thereafter will retain the tags from the previous record even if they do not apply to the specific record. I am also stumped on how to batch the loop. Here is what I have so far: let table = base.getTable('Intakes/Submissions'); const feedbacktype = table.getField('Feedback Tag'); const existingtags = vocchoices.options.choices; const feedbacktags = feedbacktype.options.choices; let query = await table.selectRecordsAsync({fields: table.fields}); let aTags = []; for (

I’m using Python - Airtable Rest API and having issues with Linked Records. Example Here is what I am getting for Linked Records - “recUU4mTrhZ5W1bMp” Instead of getting this, can I get the actual ROW ID. I’m guessing internally it must generate some “AutoNumber” like 1,2,3… how to get this Number instead of this Random some record identifier - “recUU4mTrhZ5W1bMp”

Hello! I’m getting an error with sending a patch request. I’m getting the following errror: { “error”: { “type”: “INVALID_RECORDS”, “message”: “You must provide an array of up to 10 record objects, each with an “id” ID field and a “fields” object for cell values.” } } I’m trying to send an array. I’ve checked my JSON formatting. Not sure what else might be the issue. Here’s the JSON I’m trying to send (with record IDs masked): { “records”:[ { “id”:“recabc123”, “fields”:{ “Reminder Days”:[ “recced456”, “recefg789” ] } } ] }

Using: "https://api.airtable.com/v0/app key/Interview%20Data -H “Authorization: Bearer YOUR_API_KEY” API to fetch all the records, some of my records are missing

Hey there! I am trying to stream data from an Airtable base to a local file. I am working in go and using this client airtable package - github.com/mehanizm/airtable - Go Packages I want to be able to detect whether a record has been modified, without having to use the original data and comparing it to the current data in the base. A solution I explored was to add the “Last modified time” field to all records, which would solve all my problems. But there is no way of doing that through API and has to be done manually. Not a great user experience! I also am aware there is a webhook but am not keen to go down that route. Is there any automated way I can get the “Last modified time” or any information that a change has been made and can narrow it down by the record? Thanks!

Hi everyone! I recently noticed a bug in one of the script I developed. I would like to create some tests in order to avoid future regressions. Has any of you tried to do such thing?

Hi All. Need some help adjusting my script to copy multiple record returns from one table to one record multi select in another table. I have Thinkific lesson completions coming in creating a new record each time. Wanting to then move them to another table with multi select field using email as the lookup. It works in other databases with text and numbers, but I’m a little stuck in this instance. Here is the script… This is the table of Thinkific lesson completed records this is the desired result that I havent been able to achieve yet… Thanks for the help

How to automatically obtain the daily exchange rate and add the corresponding record in the specified table.

I am trying to automatically update over 1,500 attachment names in fields within an attachment field where I only have a single image. Relevant to this post: My table name is: “Books” The attachment field (that I want to update the file names in) is: {Cover} Single line text field: {Title} Link to another record field, with multiple select options: {Author(s)} Currently, each of the {Cover} file names are completely random and inconsistent. I want to incorporate the {Title} and {Author(s)} text into the new name of the {Cover} attachments, but keep the existing image from the {Cover} and not simply replace it. The NEW name for the {Cover} attachments would be: “{Title} by {Author(s)} - MySiteName” If there are multiple authors, ideally, it would have an “and” between their names, but if this is too difficult, the {Title} alone is more than enough to make me sa

I am using this app that @Alex.Wolfe published (THANK YOU ALEX)! , and am hoping to make some tweaks so that I can use linked records fields. Right now the app allows you to create one record in another table for each option in a multiple select field in the source table, and links the new records back to the source record. Which is exactly what I need, but I believe it’s set up so the options from the multiple select cannot be outputted into a linked records field in the second table. Here’s my used case scenario: People will submit a request to have a project staffed by multiple designers. On this request they will select multiple types of designers (this is the multi-select field; i.e. a graphic designer, a mechanical engineer and an industrial designer). Based on what they have selected, I am using th

I’m trying to use an Airtable Automation script to lookup a customer ID in the Stripe API. My fetch call is returning a 200 but the data object is empty in the Airtable script even though the same call has a valid JSON response via curl in terminal. Here’s the full script code: let Stripe_API = 'YOUR_STRIPE_API_KEY'; let Stripe_URL = 'https://api.stripe.com/v1/customers/cus_MQGV6PEdpS1RWJ'; let options = { method: 'GET', headers: { 'Authorization': 'Bearer ' + Stripe_API } }; console.log(options); let response = await fetch(Stripe_URL, options); console.log(response); Does anyone have ideas about why Ai

Hi - I’m not great with scripting but trying to learn. All I want to do is copy a set of data - really just one column, from tableA to tableB, monthly via automation. The column is a linked field in the destination table and so would need to be an array of recordIds when passed. I’m not sure how to cleanly do that and am not familiar enough with scripting to fix it. The below are things that I’ve borrowed or taken from elsewhere & tried to adapt, but I’m not quite there. Can someone point me to my issues? I know for example that I am passing only the first element with “[0]” but I don’t know quite how to cycle through all the elements cleanly. I welcome any code cleanup or suggestions. let sourcetable = base.getTable("Projects"); let sourceview = sourcetable.getView("ProjectView1"); let destination_table_name = "DestinationTableName"; let destination_table = base.getTable(destination_table_name); let query = await sourceview.selectRecords

Hey there, I am currently using the Airtable API by using Make (Integromat). Since the sorting from the base won’t get passed to the output, you need to sort it inside the API call. Now I want to sort my output by two parameters. Unfortunately the sort[0] parameter gets overwritten by sort[1]. I would like to have the sort[0] prioritised, how could I do that? Any input or suggestions would be highly appreciated. Thanks in advance! :slightly_smiling_face:

For context, I have built a Softr app with Airtable as the backend and I want to use SendGrid Marketing to be able to email users of my app but I don’t want to have to manually sync the list of users from Airtable to SendGrid every time a new user signs up for my app. So I adapted @JonathanBowen’s awesome SendGrid email send script example to call the SendGrid Marketing Contacts API for use in an Airtable Automation triggered when a new record is created in the users table. // Set up input variables let inputConfig = input.config(); let email = inputConfig.email; let firstName =

I am Not able to Fetch all the records using API in flutter What i did is used url - https://api.airtable.com/v0/BASE_ID/TABLE_ID?api_key=API_KEY using this i was only able to get 100 records please help me

Hello, The dropdown for “Choose a View” has a narrower width than the max char size of view names. When users name a bunch of views the same initial way, it’s impossible to tell what you’re copying.

Hey there AT community! im currently working on some AT connectors for are company shop floor using tulip and was wondering if there is a way with airtable api to find a record using i.e. a serial number instead of the record ID to point to it to add data to its other columns. I have read that in this case what your using to lookup has to be in a text format field in AT but currently serials are generated using a formula field for us.

The rollup cell values in the Airtable UI appear as single primitive values (e.g. string, number) but when I fetch the field via the API I get an array of length 1 with the primitive value inside of it. Any ideas why? Thanks!

I have inventory that is permanent and gets checked in and out. I have created a form that includes the status change, the inventory ID, and the name of the person who checked it out. We often check out 10+ items at one time, making them all part of 1 transaction. The form form has a multiple select option for choosing every item they are checking out. The form data goes to a transactions table that is linked to a parent table that shows UTD inventory of all of our items at any given time. Essentially, the process would be: form submission → record created in transaction table → update status of selected items in the parent table Here is the current automation I’ve been trying to work with, where it will run successfully: And how it is running unsuccessfully:

I’m coding AT SDK extensions using Visual Studio Code, and most likely I’m missing something but I can’t output to console with console.log() function. There is no output on VSC terminal, debug console or output. I’ve tried running in debug mode, nothing changes. There is also a button “Log component to console” - a small bug icon - on the app editor interface, but clicking it seems to change nothing Thanks ahead for help!

Hello fellow Airtable peeps! Let me start by detailing what I need out of this script I’m trying to make, then I’ll give ya’ll the two scripts I have been using that I’m trying to replace. What I Need In Table 1, I have a field where I input the amount (i.e. “6” or “10”). In Table 2, I want this number to be translated into that number of records and I need them to be numbered. Here’s an example: Table 1: Table 2: What I Have I’m currently using two scripts to accomplish this goal on the second table, but not only does it require two scripts, but if I turn them both on at the same time it will expand the records forever (first s