Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,657 Topics
  • 11,709 Replies
3657 Topics
M
Marcus_SinclairNew Participant
posted in Development & APIs
Call url with Script

I want to create a very simple script. What I want it to do is to call a URL (the URL being called activates a sync between Airtable > Shopify. What is the code to call a URL?

192
D
J
J_ShockleyInspiring
asked in Development & APIs
Search Each Value in a List within another Array List

I’ve done a ton of searching and can’t find any answer to the possibility of using an Array (list) in one field of a base as a search input for another field. I do not want to ARRAYJOIN(values) as I am not searching for the total string, I want to take an input SEARCH list of any values, and search each list item independently within another field. I’ve built a complex Theater scheduling base where there are company members, teams which contain company members, staffing which is a member, availability of each member, and junction tabled them to fit into a scheduling table that is connected to a Show table (date,title) My goal is to be able to compare the list of members on a team against their individual availability. Is it even possible to search each item independently (Team Member) that is within an ARRAY/List (Team) within another field that also contains ARRAY data (Member Availability)? I’m assuming this will need scripting to take the input search list then go one after the oth

5311
kuovonne
H
Hadley_ParumNew Participant
asked in Development & APIs
Updating record when matches with other table

Hi all! I’ve been working on utilizing scripting within automations for a project. When a record in a table “MPList” is updated, I want to see if that record’s sort name matches any sort names in another table “memList”. If there is a match, I want the trigger record (from MPList) to be updated. I’m attaching my code below, and I think that one issue I’m running into may be with the input.config() process. The “toMatch” string in the test output window displays the ID, Name, and color for the text field it was pulled from. So, I’m not sure whether the Name of toMatch is correctly being tested for equality with the “Sort Name” field from the other sheet on line 9. let toMatch = input.config().toMatch; let mpList = base.getTable("Imported"); let memList = base.getTable("Members"); let query = await memList.selectRecordsAsync(); let result = false; let member = false; for (let record of query.records) { if (record.getCellValue("Sort Name") == toMatch) { await mpList.updateRec

97
Justin_Barrett
D
Danik_YurkevichNew Participant
posted in Development & APIs
Get linked table data

Hello! I have two tables: visualSKU and visualSKUTypes. Column “type” in visualSKU linked to visualSKUTypes. How can I get full query of linked table? Instead of record id in “type” I want to get full data of visualSKUTypes:

22
Justin_Barrett
N
nRhythmNew Participant
posted in Development & APIs
Table with summary information

I have a table, and I made a view with some grouping. The schema of the table is [Survey, Question, Category, Person, Response] Now I want to be able to extract the table with those groups and summary statistics and use that elsewhere in another part of my workflow, outside Airtable. The API allows filtering, but not grouping it seems. How does one accomplish this? Another option is somehow I can make the summary statistics into their own view/table? so it would look like [Survey, Category, Average Response]? Then I can query for that table and read those records and use them where I need them. smiles

61
E
C
Clement_LapierrParticipating Frequently
posted in Development & APIs
LinkedIn Content Scheduler - Simple but unoptimized workaround for time and date

Hello everyone, I’ve been trying to use Airtable as a social media content planner for weeks now, and realizing this is pretty much one of the first use cases everyone thinks about when learning of automations. I finally reached a solution that works, although an experienced user might object that it is far from perfect in terms of optimization/number of runs. I wanted to detail it here, to help any new user create their own planner, and hopefully to centralize tips and tricks and to get improvement advice from experience users ! Speaking of this, thank you so much @ScottWorld and @Justin_Barrett for your many posts all over the place, that helped a lot. Before we continue, please keep in mind that this is the first time I’m using Integromat :winking_face: Again, I’m eager to see your advice if I’m doing something wrong ! First of all, I’m using Integromat’s default template for social media as a base for this project. The whole thing is pretty comprehensive, and I would recommend to

00
C
T
Torus_GlobalKnown Participant
posted in Development & APIs
How to make Airtable an "approved" app so I can create automated records via Zapier

Hi, how can I make Airtable an “approved” app so I can create automated records via Zapier? I’ve finished the zap in Zapier but I get the following message (screenshot) Any help is greatly appreciated. Thanks!

00
T
V
vei_tsiNew Participant
asked in Development & APIs
Problem with fetching fields from table

i started an app and try to show table fields in my app i used a code from guides as axemple, but when i request fields by their names it shows as undefined, but field record.id is displayed ok i have table with wields Title, Price etc, but only record.id have value in app, but in table all fields have value my code import { initializeBlock, useBase, useRecords, } from '@airtable/blocks/ui'; import React from 'react'; function HelloWorldApp() { // YOUR CODE GOES HERE const base = useBase(); const table = base.getTableByName('events'); const records = useRecords(table); const events = records.map(record => { return ( <div key={record.id}> {record.Price || 'not named record'} </div> ); }); return ( <div>{events}</div> ); } initializeBlock(() => <HelloWorldApp />);

210
kuovonne
N
Nathaniel_HammeNew Participant
posted in Development & APIs
Creating multiple Records with a year change

Hey guys, So I have an accumulated vacation table that uses an employees start date and a duration formula to determine how much vacation / sick time they have earned based on their years of service with us. What I would like to do is create an automation that is capable of creating a record for every “active” employee when the calendar year changes. This would essentially create 50 some records on 1/1/20xx detailing an employees accum. vacation and sick time. I have to have a record for each annual year becuase I use another table to track an employees attendance in regards to Birthday, vacation days, sick time used that subtracts hours used vs hours accumulated. Thanks for any tips in advance!

20
N
C
captParticipating Frequently
asked in Development & APIs
Updating a field in linked table in just created record and open the record

Hi This relates to this Topic This is the code I have: let repoT = base.getTable('Repo'); let sourceT = base.getTable('Source'); let record = await input.recordAsync('Pick a record', sourceT); // let name = record.getCellValue('Part 1') + '-' + record.getCellValue('Part 2'); if (!record.getCellValue('Repo')) { let name = record.getCellValue('Data'); // create the record in the repo table let newRepoRecord = await repoT.createRecordAsync({ 'Name': name }) // set variable for today's date let now = new Date().toLocaleDateString("en-GB"); //note that newRepoRecord is the record ID of the created record // see this by logging the result: console.log(newRepoRecord); // now take the newly created record ID // and set the linked field from this let updatedRecord = await sourceT.updateRecordAsync(record, { 'Repo': [{id: newRepoRecord}], 'Part Created': "Part Entered " + now }) } else { console.log("Repo

126
C
M
Mas11New Participant
posted in Development & APIs
Need help to convert HEX Colour Codes to a Colour Name

Hi there, I’ve found a javascript code to convert HEX codes to a name. However, as I am not a javascript coder, I need help to make changes to the code so that it works when i run it as a script in Airtable. Here is the link: https://www.w3schools.com/lib/w3color.js

72
M
G
Gaby_BurkardNew Participant
posted in Development & APIs
How to get detailed error messages from users

Some of the users of my custom app are getting the “Sorry, an error occurred” message, but I can’t reproduce the problem on my computer when I follow the same steps-- is there some way for me to access, or else for them to send me more details of the error like you can see in development mode? Thanks!

42
kuovonne
V
Vitezslav_AckerNew Participant
posted in Development & APIs
Airtable.js always returns all results even if pageSize is used

Hi, I am trying to use a pagination in my code, but the airtable.js client always returns all results even if pageSize is used. Moreover, if I use pageSize it will query the data from airtable database one page at a time until it reads them all. How to stop this? I have intercepted the outgoing requests and these are the urls the client calls GET https://api.airtable.com/v0/applDJB1ThaWVcIJD/Moc%20Data?pageSize=2&maxRecords=5 GET https://api.airtable.com/v0/applDJB1ThaWVcIJD/Moc%20Data?pageSize=2&maxRecords=5&offset=itreHdPlZHyg9RWB3%2FrecBtmAdzmYqi9F8t GET https://api.airtable.com/v0/applDJB1ThaWVcIJD/Moc%20Data?pageSize=2&maxRecords=5&offset=itreHdPlZHyg9RWB3%2FrecENdiDVazobA9fH my code: async list<T extends TableNames>(baseId: AirtableBaseId, table: T, queryParams?: QueryParams<Tables[T]>): Promise<MetaTable<Tables[T]>[]> { return this.airtable .base(baseId)(table) .select(queryParams) // <- { maxRecords: 5, pageSize:

71
V
Karlstens
KarlstensBrainy
asked in Development & APIs
Changing a Button Field label

I’m still fairly new to scripting, and going through the learning process. I’m assuming the below error means that scripting can’t access the details that it needs to? Error N: Can’t set cell values: Field ‘Button’ is computed and cannot be set My example code below; let myTable = base.getTable("ButtonTable"); let myTabeQuery = await myTable.selectRecordsAsync(); for (let myRecord of myTabeQuery.records) { let getButton = myRecord.getCellValue('Button') console.log(getButton); let getSelect = myRecord.getCellValue('SingleSelect') console.log(getSelect); let newName = "💚"; await myTable.updateRecordAsync(myRecord,{Name:newName}); let newSelect = "💚"; await myTable.updateRecordAsync(myRecord,{"SingleSelect": {name:newSelect}}); let newButton = "On"; await myTable.updateRecordAsync(myRecord,{"Button": {Label:newButton}}); } Is there any method to update Labels?

562
kuovonne
L
Leo11New Participant
asked in Development & APIs
How do I retrieve records from a view rather than all the records from a table?

I am using GET to retrieve data from a table in a base. Rather than getting all the records, I would like to get the records filtered by a view. My query looks something like this: https://api.airtable.com/v0/appXXXXXXXXX.../TheTableIWant?fields%5B%5D=FIELD1&fields%5B%5D=FIELD2_ETC What would the query look like to get a view?

2606
L
J
Julian_WanParticipating Frequently
asked in Development & APIs
Mac OS Client Won't Load Scripting Block

Hi Everyone, I’ve been trying to script from the desktop Mac OS client. I believe it’s an electron app. Unfortunately, any time I try to open the scripting block, it just hangs there and continues showing the loading wheel. I can run scripts, but I cannot edit them, I only see the loading wheel. I saw this thread below: Scripting block does not work in Airtable Electron app Scripting app Running an example script from the Scripting block docs inside the Airtable Electron app (on Windows) generates an error. Running the same script in a browser view of Airtable (in my case: Firefox) works as expected. [Scripting Block Error] My issue is similar, but I don’t get an error at all. Any tips on how to fix this? Thank you!

85
J
P
Per_CarlenInspiring
posted in Development & APIs
Running Javascript function when all 100+ records have been retrieved?

Below is the example code from https://airtable.com/api for listing records with Javascript. How should I adjust the code when my base have more than 100 records, and I want to run some code when all the records have been retrieved? (I know that I’ll have to remove “maxRecords: 3,”) If I put my code within “eachPage” but then the code will be executed multiple times (obviously). I’ve tried to put my code in inside an else statement within the done-function but then I don’t have access to the variables and methods like records, record, record.get and so on. var Airtable = require('airtable'); var base = new Airtable({apiKey: 'YOUR_API_KEY'}).base('appInTsFatECjqsT2'); base('Uppställningsplatser').select({ // Selecting the first 3 records in Alla uppställningsplatser: maxRecords: 3, view: "Alla uppställningsplatser" }).eachPage(function page(records, fetchNextPage) { // This function (`page`) will get called for each page of records. records.forEach(function(record)

341
J
V
Vadim11New Participant
posted in Development & APIs
Mass images downloading

Heya! I receive big bunches of links to images from clients. Links could lead anywhere, Airtable included. So I need to download them for further processing and as faster as possible. But when it comes to Airtable I meet some kind of a limit there (which I don’t meet, for example, with Google). So I have two questions: Anybody knows the limit for downloading images per sec/min? Can I ask Airtable to increase such a limit for me anyhow?

11
ScottWorld
S
Sampada_KaushalNew Participant
posted in Development & APIs
Accessing metadata API

Hi everyone, I want to use metadata API to get details of all the bases used in my project. In the documentation it says,“Enterprise Airtable accounts do not require a separate Metadata API client secret.”. But I am still unable to get the response when I hit the following API with my auth token- https://api.airtable.com/v0/meta/bases Reponse- {“error”:{“type”:“NOT_FOUND”}} Kindly help and do let me know if something is missing from my end. Thanks in advance!

20
S
R
Rafael_SilvaParticipating Frequently
posted in Development & APIs
Script to Delete Data

Hello, Could someone help me with a script to delete data from a table passing 1 field as a parameter? For example, I want to delete all records that were recorded yesterday, so I would pass yesterday’s date to the parameter and all data would be deleted. Thanks

249
R
A
Aly_SebastienParticipating Frequently
posted in Development & APIs
Vue2 + Airtable - How can I sort a loop so its not in a random order?

I have a problem I can’t seem to solve with Airtable and Vue2 CLI and wondered if anyone could help? I have set up a base and am using a Vue for loop to iterate through a list of objects. Although my loop works, and renders in the browser. However, the order of the objects are completely random. I have tried a different methods to try and get them in the same order as in the base but nothing seems to work. My code is as follows: In my Vue Component; <div class="timeline-wrapper" v-for="record in records" v-bind:key="record.Title"> <h2>{{ record['fields']['Title'] }}</h2> </div> Then in the script of the component I have; import axios from 'axios'; axios({ url: 'https://api.airtable.com/v0/app123456789/', headers: { 'Authorization': 'Bearer key123456789' } }).then((res) => { res.data.records }); export default { props: [ 'columns' ], data() { return { apiUrl: 'https://api.airtable.com/v0/',

1711
A
Michael_Schmidt
Michael_Schmidt
posted in Development & APIs
useRecords no longer triggering app UI refresh after starting an external handler (mailto)

My app uses data from several tables via useRecords, so normally any table data changes (from other Airtable instances/users or via the in-app “expandRecord” buttons are triggering a UI refresh, reflecting those changes within a few seconds. However, reproducibly, whenever I start an external “mailto:” handler, either by using a Material UI Link component or directly via a component’s onClick, the app stops updating it’s UI when data is changed outside of it. Any record changes sent from within the app still propagate as intended, but useRecords is no longer triggered when records are changed from outside the app (in another Airtable window or via “expandRecord”). Only a manual “Reload app” seems to get things working again. <Link href="mailto:name@example.com?subject=Mail" className={classes.email} > <MailOutlineIcon size="small" className={classes.taskicon} /> </Link> ... onClick={() => {window.location.href = "mailto:name@example.com?subject=Mail"; }} As

51
Michael_Schmidt
K
Kendrick_KirkNew Participant
asked in Development & APIs
Script runs as an app, but not as Automation

I’m trying to update a base every 24 hours hitting a public API using remoteFetchAsync(). When I run the automation code below, I get this error: ERROR ReferenceError: remoteFetchAsync is not defined at on line 24 at main on line 9 The automation: //output.markdown ("# Updating BTC price"); let table = base.getTable ("Fetch"), records = await table.selectRecordsAsync (); //Check difficulty await Promise.all ( records.records.map (async record => { let stock = record.getCellValue ("Ticker"); if (! stock) { //output.text ("Can't update the price without Ticker"); return; } //output.text (`Updating Mining Difficulty of ${stock}...`); // make request to BTC.com var response = await remoteFetchAsync ( `https://chain.api.btc.com/v3/block/latest` ).then (r => r.json ()); // Parse by hand var data= response.data; var diff= data.difficulty;

311
kuovonne
P
PeterBInspiring
posted in Development & APIs
Auto create record of when a Record was used

I have a table of Items and a table called Used, that has just a date time field and a link to Items. In a grid view of Items, when I click a checkbox it should create a Used record for that Item, with date set to now. I also need a way of clearing the checkboxes for all Items, leaving the Used records as they were. I guess I need 2 scripts? What would they look like? TIA.

02
P
S
Sebastian11New Participant
posted in Development & APIs
Gantt chart script: Adjusting successor to predecessor for no-coder

Hey everyone, I’ve found this script online (raw version below; https://medium.com/@greg.business.automated/regaining-control-of-your-airtable-gantt-charts-with-this-simple-app-548a2eb40ebb) Basically it helps update Gantt chart columns (start & end date, duration) given a starting task. However its centered around using successor tasks, which for me is a bit impractial as I’m working with a ‘blocked by’ or ‘predecessor’ scheme. I was wondering what I needed to change in the code for this to allow using predecessor tasks. I’ve been trying to play around with it for the last hour but no luck… Any help highly appreciated!! //Copyright © 2020 by Business Automated //Update dates of tasks in Gantt chart in Airtable. To be used together with the Airtable Gantt and Scripting block. // Select the To Do table and records let table = base.getTable("Table 1"); // <== change here the Table name let toDoRecords = await table.selectRecordsAsync(); let nameOfStartDate = "Start Date"; // &

184
S

Badge winners

Show all badges
Terms & Conditions