Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,656 Topics
  • 11,709 Replies
3656 Topics
M
Matt_CarusoKnown Participant
posted in Development & APIs
Read-only users updating records from Scripting block

I’d like to have read-only and commenter users able to edit data using the scripting app. Is this possible? It seems the permissions within the scripting app are tied to the user’s permissions, but are there any APIs to have the scripting block act as someone else?

91
kuovonne
S
Sebastien11New Participant
posted in Development & APIs
Automation Script JSON to var?

Hello, My input are: idStock getURL getApiKeylabel getApiKey My code: let table = base.getTable("Stocks"); let query = await table.selectRecordsAsync(); console.log(query.records); let inputConfig = input.config(); console.log(`The value of idStock is ${inputConfig.idStock}`); console.log(`The value of getApiKey is ${inputConfig.getApiKey}`); console.log(`The value of getURL is ${inputConfig.getURL}`); let mergeAPI = (`${inputConfig.getApiKeylabel}=${inputConfig.getApiKey}`); let mergeURL = (`${inputConfig.getURL}${inputConfig.idStock}?${mergeAPI}`); console.log(`The value of mergetURL is ${mergeURL}`); let response = await fetch(`${mergeURL}`); console.log(await response.json("price:")); I want to output my json result to a field.Is it possible?

37
kuovonne
T
Thomas_RNew Participant
posted in Development & APIs
Airtable and Discourse Integration

Hello, we’re looking to into automatic integration to an Airtable table for moderation activity report from admin panel on our Discourse forum. Is it possible to integrate this and are there any examples? Thanks.

51
B
Andy_Cloke
Andy_ClokeKnown Participant
asked in Development & APIs
Blocks SDK suggestion: disabled props for ConfirmationDialog

It would be really useful to be able to set confirmButtonDisabled and cancelButtonDisabled (both booleans) to diable the respective buttonts on the ConfirmationDialog component.

30
E
M
Martin_KranzInspiring
asked in Development & APIs
Markdown Images in Scripting Block!?

Been trying to wrap my head around how to display record attachments (images) in the markdown output of the scripting app. I heard rumours that’s possible :slightly_smiling_face: but haven’t seen any code snippets that seemed to be working []!($URL) produces errors asking for a function called Any hints?

260
M
J
Jyothi_KaturiNew Participant
posted in Development & APIs
Unable to write to table from python

Hello, We have created a new base with full permission. But i can’t write to this new base. Is anyone else having same issue? “message”:“You are not permitted to perform this operation because the field or table has been configured to limit who can perform this operation”

31
R
D
Dominic_RannieKnown Participant
posted in Development & APIs
Retrieve Value From Lookup Table and Write to New Record

Hi, I have two tables. “Margins” and “Orders”. I need a script that would be triggered by an “New Record in the Orders table” automation that would use the value in the “Product” field to lookup a “Margin” value in the “Margins” table, then record this against the new order record, assuming a match is found. In doing this, I hope to preserve the current margin against a new order, something that would not happen with a normal lookup filed as it would simply update all the linked order records when a margin is altered. Would anybody be able to nudge me in the right directly here. I have no experience in Javascript, although I have basic knowledge of Python. How do I select the “Product” value from the latest record(s) in the Orders table and only update those records that have not been already updated previously be the script? Are there examples of similar scripts that anybody is aware of that I could work from? I am guessing that this example posted by @Sam_Cederwall could be a good st

183
S
B
Ben_SherwinNew Participant
posted in Development & APIs
Attachments replacing one another

When adding a file to an attachment field via the API (using Zapier) the file being added replaces any current files already in that field rather than adding it in.

83
P
I
itoldusoandsoInspiring
posted in Development & APIs
Youtube uploaded video link to Airtable via Integromat

In case somebody looks for ways to get uploaded Youtube channel video links to Airtable… You can go Zapier … Or you can go Integromat. However, Integromat doesn’t list Youtube as one of the available integration options. I’m not sure why is that. Is it because Youtube is not a business app? I found link to automation template and that enables to get the Youtube app. https://www.integromat.com/en/integration/79-post-new-youtube-videos-on-facebook You need to create API credentials for Youtube (it’s a bit pain, the description here doesn’t match anymore)… https://support.integromat.com/hc/en-us/articles/360025257393-Connecting-YouTube-to-Integromat-via-Google-OAuth-Client The “Search Records” module needs a Formula {YOURFIELDNAMEINAIRTABLE}=“NAMEOFTHEYOURUBEVIDEO”. In this scenario the name of the Yourube video matches the name of the record in the Airtable field. Set the limit of number of records to return to “1”. If multiple videos have same title, I believe higher number would res

20
I
A
Alexandre_HusseInspiring
posted in Development & APIs
Input scripting

Hello, as far as I understood I cannot pass an input when I call a script. Am I right ? I have a table A with 3 fields id, name, description I have a table B with 3 fields name, id (link with the table A) and single select (template, todo …) Each time there is a new record in A I want to create records in B with b.id = a.id for each record b.template. for those records the single select will not be template but todo. I hope it is clear :frowning: Thanks for your help Alex

93
G
G
Go_Ask_NickNew Participant
posted in Development & APIs
Wrong input records pulled? Help

I have a ledger for tracking inventory movements. When I create a new line with a 502 movement I want to run a script. The script has an input variable which is a list of linked records from another base. I want to read those records and get some data from them and then automatically create some new lines in my ledger base. I am trying to pass the values from the subcontracting records lookup The problem is when I read the subcontracting records it looks like it is reading multiples of the same record ID and when it writes to my ledger it links the incorrect material codes. Can someone help me with what I am doing wrong? //sets up the tables and input var let subcontractingTbl = base.getTable('Subcontracting'); let ledgerTbl = base.getTable('Ledger'); let inputConfig = input.config(); let mapOutput = 0; let compPosted = 0; //loop thorugh, read the subcontracting components and writes to ledger for (let i = 0; i < inputConfig.subcontractedRecord.length; i++) { let subconInpu

10
G
N
Nathan_HeironimKnown Participant
posted in Development & APIs
Scripting App: Input date with default time(s)

Background: Hello, any help with this is much appreciated. I’m pretty new to JavaScript, but learning quickly. So far I am proficient with variables, functions, scopes, oh—and commenting things to death! Problem: I’m trying to create a script that creates a new event that automatically fills in some recurring contextual information in an [Events] table. However, I cannot find anything anywhere about entering/recording the time of day into a {Date/Time} field when running a script. The event is always at the same time 12pm-1pm (EST in my case) but the date is what needs input(ed) by the user running the script. So Far: // identify base and table info let table = base.getTable('Event List'); // user input "Event Name" let eventName = await input.textAsync('What\'s the name of this event?'); // Create new record with default event criteria in the [Event List] table let recordId = await table.createRecordAsync({ 'Event Name': eventName, 'Event Type': { name: "My Cool Event" }, 'S

85
N
L
Lee_ThomasInspiring
asked in Development & APIs
Patch Request from google apps script

I just can’t find the right way to format my request. I’m trying to update a single field in a single record. but keep hitting - INVALID_REQUEST_MISSING_FIELDS",“message”:"Could not find field “fields” in the request body Getting data is fine. After a few hours trying different things I’m asking for help what am I missing? Any help appreciated API and Base ID Blanked out function apiCall(){ var API_KEY = ‘XXXXXXXXX’; var root = ‘https://api.airtable.com/v0’; var baseId = ‘XXXXXXXXXXXX’; var tableName = encodeURIComponent(‘Travels’); var recordId = “recSaJTXSBu1g8CBd” var endpoint = ‘/’ + baseId + ‘/’ + tableName + ‘/’ + recordId; var params = { ‘method’: ‘PATCH’, ‘muteHttpExceptions’: true, ‘Content-Type’: ‘application/json’, ‘headers’: { ‘Authorization’: 'Bearer ’ + API_KEY }, "fields" : { "Declaration link": "https://docs.google.com/spreadsheets/d/13V8gO7511yJ0830IpiKXtfYfKeuVVSJ8uqbXR-9Ne8w/edit#gid=0" } }; var response = UrlFetchApp.fetch(root + endpoint, params);

203
Justin_Barrett
T
Taylor_JohnstonKnown Participant
posted in Development & APIs
Scripting (or formula building) assistance request!

Hi – In an effort to save weeks worth of research, I’m hoping to find someone who may know the most efficient way to build out an automation process. I have no experience with computer language or programming and am officially waving my white flag. :rofl: I essentially need to build a custom numerology app. I need to be able to press a button in my Airtable and run a program to break down each name (first, middle, last - each in separate columns) into individual characters and assign each letter to a number. There are more steps to the process as a whole, but this is my primary need for assistance. I’m fairly certain this can be done with a formula by splitting the text string (name) into individual characters; however, I don’t know how to make this a dynamic process (for the len and/or mid functions) nor do I know how to run a split function without a delimiter. If anyone has any suggestions, all feedback is appreciated! As briefly mentioned, there are more steps to this process and

08
T
E
Emar_VegtNew Participant
posted in Development & APIs
input.fileAsync() - work on file before parsing it

Hi all. With my custom CSV importer script, I’d like to do a few operations before the .parsedContents method should look at the file. Examples: My file uses a comma for decimal notation. .parsedContents simply removes them, so 4,5 becomes 45 but it should become 4.5 I’d like to take a closer look at date formats used in the file, because they may vary, and even if .parsedContents correctly identifies it as a date, the format may be DD/MM/YYYY or MM/DD/YYYY. The Javascript methods .readAsText() or .text don’t seem to work even though the documentation states that input.fileAsync() delivers a File object which is a Blob. Any clues?

20
E
D
Dominik_FischerNew Participant
posted in Development & APIs
CORS issue with Custom App

Hey! I’m currently making the first steps with the Blocks SDK and having problems with fetching data from our Shopify Backend. I’m trying to do it like this (frontend.js): let url = https://xyz.myshopify.com/admin/api/2020-01/orders/${record.getCellValue("Shopify Id")} let response = await fetch(url,{ method: ‘GET’, headers: { ‘Content-Type’: ‘application/json’, ‘X-Shopify-Access-Token’: ‘xyz’, }, }) return await response.json() Whenever I trigger this function, the console logs say: Access to fetch at 'https://xyz.myshopify.com/admin/api/2020-01/orders/123.json' from origin 'https://devblock---123xyz.airtableblocks.com' has been blocked by CORS policy: Response to preflight request doesn't pass access control check: Redirect is not allowed for a preflight request. Any help with this will be much appreciated :slightly_smiling_face:

151
E
T
Taylor_SavageInspiring
posted in Development & APIs
Accessing the metadata API

Hi everyone, As part of our ongoing effort to make Airtable more and more extensible, we’re beginning to expand access to the Metadata API. The metadata API gives you read-only access to a list of a user’s bases, as well as the specific schema of each base - things like what tables exist, what fields exist on those tables, etc. Usage of this API currently requires a unique developer token, in addition to the user’s API key for whom you are looking to pull the metadata. You can view the metadata API documentation here, and request a developer token here. We are considering in the longer-term simply rolling the metadata API functionality into the main Airtable API - this would require some deeper underlying structural changes, however, hence in the short-term we are bridging the gap by issuing individual tokens. As always, we’re eager to get your feedback on what you’re looking to do with this and all Airtable API’s. The metadata API contains some known gaps - most obviously, that it is

33512
N
R
Rose_Haft1Inspiring
posted in Development & APIs
Find() Not working

Despite having standardized the look-up field, my table is giving very distinctly different answers in the formula field. An image of the formula field + look-up field are below. What could possibly be going wrong? What can I test to fix? My formula is: FIND(‘T003: Symptom’, {Rel_lookup_Terms_Type})

141
Justin_Barrett
R
Rose_Haft1Inspiring
posted in Development & APIs
Possible to see which view in form question in scripting for automation?

Hi there - Is it possible to determine which view in a form is being used to help determine what happens in an automation? For instance, my form is choosing items from a drop down list that is pre-sorted in a view. I want to run an automation based on that pre-sort. Is that possible?

95
R
E
Eugene_KimInspiring
asked in Development & APIs
How to only watch records that were updated

Hello, My app keeps data on my server in sync with changes made to Airtable. My question: What is the best way to subscribe to record updates when using the blocks API? The useRecords hook simply returns all of the table’s records when a record is modified so it doesn’t seem the best way to keep track of updates. It looks as if the best way to do this is to write a custom useWatchable on all the records of the table so that I receive individual records as they get updated but I’d like to know if there’s a more elegant solution than this. I’d also like to know if there’s a native way to get notified via callback or event when a new record is created or if I’ll have to keep track of this on my end. Many thanks

110
E
A
Ahmed_ElagamiKnown Participant
posted in Development & APIs
Add a number of days to a date script

Hello Everyone, I am trying to convert a string value to a datetime ? or how can I add a no of dates on a date format? Example, I have a date 08/16/2020 I would like to add 5 days to be 08/21/2020 in Scripting block I have this script, to create all number of eps and create the date assigned to that specific episode I have the start date value, and I have No of eps value. I tried to use a moment to add a duration of days, but it’s not working for me moment.duration().add(1,date) let importTable = base.getTable(“Titles”); let importQuery = await importTable.selectRecordsAsync(); let episodesscheduletable = base.getTable(‘Episodes Schedule’); for (let record of importQuery.records) { let rowcount =0; rowcount= record.getCellValue(‘EPS’) while (rowcount>=0) { if (rowcount===0) { }else { //let now = new Date().toLocaleDateString(""); let date =record.getCellValue(‘Start Date’) var rightNow = new Date(); //rightNow=date. let Pattern=record.getCellValue(‘Release Pattern’) let fullName = r

312
A
K
klonawayInspiring
posted in Development & APIs
Integromat : AirTable <-> GoogleCalendar two-way sync?

Hi, AirTablers (yup, It’s now a verb) ! I’m trying to build a clean two-way sync between AirTable and GoogleCalendar. My choice is Integromat because : (1) full two-way CRUD functionality out of the box (2) first useful paid plan much cheaper than Zapier for my use case. I have good coding background, but I’m still new to those codeless integration tools, and I was wondering if someone could help me build Integromat scenarios for my use case ? I have read this and that, but nothing really helpful. My logic so far is to use two scenarios : Watch GCal => C/R/U/D in AirTable (using URL of GCal event as a field in AirTable) Watch AirTable => C/R/U/D in GCal (using AirTable record ID as description of GCal event) My main concern is to avoid infinite loops, and to make sure my scenarios are as simple as possible (you should see the weird lines of Node.js I write sometimes…). Any input would be highly appreciated !

138
M
J
Joe_PinoNew Participant
posted in Development & APIs
Script that types "(A word)" into {FieldX} within the record

Hey all, I have a button that “Runs script”. I want the script to type "(a word)" into {FieldX}, obviously in the same record as the button that was pressed Thank you!

107
J
L
Lee_MandellKnown Participant
posted in Development & APIs
User input from a drop down list populated from values in a single select field

Is there a way to get user input from a dropdown list? I would like this list populated from the values in a single select field. Lee

131
JonathanBowen
D
Digital_BoNew Participant
posted in Development & APIs
[urgent] React Nextjs app Invalid airtable api key with .env

Hello, I’m new to Airtable and I’m trying to build a React Next.js app with Airtable as an api. here is the relevant code in pages/index.js export async function getStaticProps() { var Airtable = require('airtable'); var base = new Airtable({ apiKey:process.env.API_KEY }).base(process.env.BASE_ID); const table = base(proces.env.TABLE_NAME); my .env: API_KEY=xxxxxxxxxxxx BASE_ID=appDAc9CXCfSiBuV8 TABLE_NAME=Content even when I’m running the app locally, I am getting error 401 that the airtable API key is invalid. If I print the process.env.API_KEY it is totally fine so the .env does work. When I copy the same key and paste it into the code, everything works fine!! It seems like Airtable has a strange problem, maybe with next js or something because I can’t get this to work in any way. I really need to deploy my app and can’t do that without hiding the key in .env/next.config.js…can anyone help on the matter? deployment error pic Thanks!

81
A

Badge winners

  • Certified Airtable Admin
    nitinjainhas earned the badge Certified Airtable Admin
  • Certified Airtable Admin
    CaitlenBerghas earned the badge Certified Airtable Admin
  • Certified AI App Builder
    stagandforgehas earned the badge Certified AI App Builder
  • Certified Airtable Builder
    stagandforgehas earned the badge Certified Airtable Builder
  • Certified Airtable Builder
    Abiodunhas earned the badge Certified Airtable Builder
Show all badges
Terms & Conditions