Development & APIs

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

Hi all, i am trying to build a table for holidays via caledarific API. this is the part of response from json { “meta”: { “code”: 200 }, “response”: { “holidays”: [ { “name”: “New Year’s Day”, “description”: “New Year’s Day is the first day of the year, or January 1, in the Gregorian calendar.”, “country”: { “id”: “es”, “name”: “Spain” }, “date”: { “iso”: “2022-01-01”, “datetime”: { “year”: 2022, “month”: 1, “day”: 1 } }, “type”: [ “National holiday” ], “urlid”: “spain/new-year-day”, “locations”: “All”, “states”: “All” }, { “name”: “Reconquest Day”, “description”: “Reconquest Day is a provincial holiday in Spain”, “country”: { “id”: “es”, “name”: “Spain” }, “date”: { “iso”: “2022-01-02”, “datetime”: { “year”: 2022, “month”: 1, “day”: 2 } }, “type”: [ “Local holiday” ], “urlid”: “spain/reconquest-day”, “locations”: “GR”, “states”: [ { “id”: 324, “abbrev”: “GR”, “name”: “Granada”, “exception”: null, “iso”: “es-gr” } ] }, So , i am trying to fetch data in a “Vaciones table” without succ

I am developing an extension that handle “row changed” by using cursor selectedRecordIds as follow: useWatchable(cursor, [‘selectedRecordIds’]) But the event doesn’t fire in Gantt view mode. Is there any other way to work with Gantt view? Thanks

Hey all, Question for those with API experience. As linked records return the RecordID, do you typically create a Rollup Column to display and retreive the Linked Record name data, or, do you code the solution in your source to retreive the name of each record? Simple two table base layout - an active score board; And registered users; My example code below, heavily influenced by the current Airtable API code samples - when retrieving the ScoreBoard, how best to show the Linked User names? Although I’m yet to refine my find() code block, already I can see that returned names aren’t in any particular order, as opposed to the Player Name Rollup at least being the correct order. So in summary, do you tend to code solutions in the base, or solutions in the API source when working with Linked Records? I can see advantages of knowing and understanding both. Sample code below; const Airtable = require('airtable'); const base = new Airtable({apiKey: apiKey}).base(myBase); base('Score').se

Hello, I believe this is simple, but I don’t understand what syntax is needed. I’m trying to read the results of a single-select field as a string. I’m doing a running total calculation, but resetting it whenever a certain reading is found. The running total part was working, but I can’t figure out how to get the single select output as a string. When I run this, I get: typeof respGroup.records[0] returns “Object” output.text(typeof respGroup.records[0].getCellValueAsString) returns “Function” let table = base.getTable(‘Prints’); let view = table.getView(‘MTBF layout’); let respGroup = await view.selectRecordsAsync({fields: [‘NDD - Responsible Group’]}); //NDD - Responsible Group must be manually filled out! let elapsedTime = await view.selectRecordsAsync({fields: [‘NDD - Elapsed print time’]}); //NDD - Elapsed print time is a calculated field let groupRecords = respGroup.records; //trying to understand how to get the group records into a string format output.text(typeof respGroup.re

Hey there, The state management and reactivity of all of our airtable apps is based on mobx and mobx-react-lite and not on hooks. This allows use to write code that is object oriented and therefore cleaner, more robust and faster and easier to develop and maintain (at least for us). We specifically wrapped your cursor and session objects as mobx based classes and are observing changes by calling the watch methods of those objects and updating class members that are mobx observables. I saw here that you plan to deprecate the cursor and session objects. Please don’t and allow people to decide which state management paradigm and library to use and don’t force them to use react hooks. Thanks

Hi Guys, Previously I was using filtered.pop (thanks to @Alexey_Gusev) to find the last record that has no amount let filtered=(result.records.filter(item => item.getCellValue('Cumulative by Customer') > 0)); let last=filtered.pop(); However when I am adding more data, let’s say different customers, it’s not dynamically filtering those data. The amount $12,203.50 below is based on last amount of $10,253.5 above (they are different customers). It’s supposed to take the last amount of $22,776 instead Is it advisable to build custom index of the data or is there any better method to calculate cumulative sales amount by customer? Thank you.

Greetings! We use Airtable to (among many other things) create reports from surveys that we’d like to be interactive, such that if someone clicks on a bar chart, they’ll be able to explore the records associated with a certain bar. e.g. If someone clicks on the bar representing the number of 30-39 year olds who answered a question a certain way, they’d be able to click on that bar, and see their responses in another pane. So far as I can tell, there’s no way to do this in Interface Designer. Is there another way within Airtable? Or would we need to use another platform? Thanks!

Hello fellow Airtablers! (maybe there’s a better name…?) I staff designers onto projects and I want to create a “Supply Grid” where it shows when a designer is next available, for how long (# of weeks) and what they are off to next after those weeks. Something like this: Many thanks to help from @Mike_Pennisi and @Alexey_Gusev (thank you both!) I was able to create records that help indicate when a designer is available each week (labeled “Open Space”). So essentially, my Airtable Table looks kind of like this (a much simplified version): Where I Need Your Help: Using this data, I want to automatically create the “Supply Grid” (Right now i’m doing this all manually). I’m imaging the steps being something like: From the list of open space records for each designer, identify the open space record with the earliest start date and have that be the “Available Starting” date for the Supply Grid for that designer Identify the # of open space records in a row until it hits a record that’

I have been helped by so many of your community posts, thought I’d post one of my own for a problem I’ve been trying to solve. I use Airtable as a resource management tool to staff designers onto projects. However, I want to also quickly pull data on who is on “open space” (not on a project) each week. (I’m often trying to answer the question "who’s available the week of i.e. 9/5?) My Airtable base is set up with the following tables and links: Designers Table: holds all of our designers Projects Table: holds all of our projects (that designers need to be staffed on) Availability Table: created via linked records between Designers and Projects Unless there’s a simple way I’m completely missing, here’s the work around scenarios I’ve come up with: Create a record for each week that’s labeled “Open Space” and set an automation for that record to be deleted if another record (a project record for a designer) overlaps with any of the open space records. That way I can set the filter to sh

Hello, I have a few custom scripts for my base that I would like to be abstracted from other base collaborators so that they can’t see or edit the code. I would like to have these custom scripts moved into a custom extension with a simple UI. Please email me with your calendar / availability at jake@wholescalingsystems.com I’m ready to hire and will have lots of ongoing projects!