Development & APIs

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 for this field. Please see below image as an example for ADOC customer. Also, have a look at the form which is same for every customer. Only values in Source Category field are varying. So, h

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 (let record of query.records){ let choices = record.getCellValue("[U] User Product Feedback"); let options = record.getCellValue("Feedback Tag"); let f

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 satisfied. I have my automation set to “Update record when {Cover} is not empty”, but I can’t figure out the script for the life o

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 this script to create a new record for each of the types (i.e. a record for a graphic designer linked back to the request, a record for a mechanical engineer linked back to the request

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 Airtable isn’t recognizing the full response from the Stripe API?

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.selectRecordsAsync({fields: ["Project Name"]}); let reco

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 = inputConfig.firstName; let lastName = inputConfig.lastName; let userType = inputConfig.userType; let signupDate = inputConfig.signupDate; let SG_API = 'YOUR_SENDGRID_API_KEY'; let SG_URL = 'https://api.sendgrid.com/v3/marketing/contacts'; let data = { "contacts": [ { "email": email, "first_name": firstName, "last_name": lastName, // Custom fields

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 aware that the issue directly comes from AT not reading both Record IDs to update. I do not have access to apps, only to scripts. Please help!

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 script will expand any number that isn’t 1 and change their number to 1, and the second script will just keep changing the numbers, so it just keeps creating records). So, basically, I’ve been turning each one on individually to avoid the eternal expansion. I searched the forums far and wide just to find these two scripts, but they’re just not quite what I need

I looked everywhere but don’t seem to find how to edit my custom extension I’ve released. I only see instructions how to create a new extension from scratch… I can’t find a list of my extensions as well. Please help!

I have a body like this { “records”: [ { “id”: “reccsfBOAsOX5nigv”, “fields”: { “test”: 123 } } ] } How can i skip the “test” (currency type) field? The idea is that i have a condition that shall be met. If not, then do not change the “test” field. Thank you

Hey there, I’m hoping someone will be able to help (my scripting ability is limited) - I want to be able to create a specific number of records in Table 2 based on the Qty field in Table 1. I have a script which creates a singular record in Table 2 from the data in Table 1 but does not consider the QTY field and creates the X number of rows. Would anyone be willing to help please? Thanks in advance