Skip to main content

Development & APIs

Need development and API help? Ask your questions here!

  • 3,656 Topics
  • 11,709 Replies
3656 Topics
V
Vince_AlvarezNew Participant
posted in Development & APIs
Looking for simple "Create Record" script examples

Airtable has been a godsend to our organization, but none of us are very familiar with scripting. We have a need for a what I imagine is a simple script, but the examples I’m finding in the community and outside are much more complicated. We have a few employees who only add simple orders in between their tasks. Normally we would do this with a form, but the multi table process is frustrating. Basically we have 3 tables Customers, Orders, and Order Line Items. I want to add a button to our Customer table that runs a script that creates a linked record to that customer in the Orders table with today’s date and then launches our Order Line Items Form with the “Order” field prefilled with the record just created. That way from a read only share of our base they can hit the button and (in the background) an order is created and the form to add items is automatically launched. The examples I am finding around seem much more complicated and I’m having trouble parsing them. Thanks for you hel

83
kuovonne
S
Sean_Anderson1New Participant
posted in Development & APIs
createTableAsync example with MULTIPLE_RECORD_LINKS?

I am trying to create a table with linked records using a one-to-many relationship. How would I create a Contacts table with a link to ContactPhones where a single Contact record is linked to multiple ContactPhones records? Below is one of the things I have tried based on the base.createTableAsync and the FieldType documentation. import { FieldType } from "@airtable/blocks/models"; import { useBase } from "@airtable/blocks/ui"; export async function createContactAirTables() { const base = useBase(); if (!base.getTableByNameIfExists('ContactPhones_')){ await base.createTableAsync("ContactPhones_", [ {name: 'Id', type: FieldType.SINGLE_LINE_TEXT}, {name: 'PhoneNumber', type: FieldType.SINGLE_LINE_TEXT} ]); } if (!base.getTableByNameIfExists('Contacts_')){ await base.createTableAsync("Contacts_", [ {name: 'Id', type: FieldType.SINGLE_LINE_TEXT}, {name: 'BusinessName', type: FieldType.SINGLE_LINE_TEXT}, {name: 'Contac

83
S
L
Luc_LAMORENew Participant
asked in Development & APIs
Extract URL from Long text cell

Hello, I’m new to Airtable, so forvige me if this has already been asked or if it is not in the right category. In my database, I have cells that contain both text and one or more hyperlinks I want to extract the URL from those cells and put them in a new column and I have no idea how to do so. I would love to get some help on this please, thanks !

112
D
J
Joao_ProencaParticipating Frequently
posted in Development & APIs
Filtering Rollup fields through the API

Hi, I’ve been trying to filter a Rollup field through the API, using the filterByFormula option. It returns a string of numbers, since it uses the ARRAYCOMPACT(values) as the aggregation function. (ex: Product age : [“10,11,12,13,14,15,16,17”] ) I can’t find how to filter through these number, Find or Search doesn’t return any values ( ex: (SEARCH({Product Age}, “13”) > 0) , and also not with a simple “=” ({Product Age} = 13) . I want to be able to filter by that field, but I’m currently unable to find out what’s the correct format for the filterByFormula option. Can anybody help me? Best, João

2413
T
K
kirkbrossParticipating Frequently
posted in Development & APIs
Batch copy a field to another field in same table (10,000 records)

I’m trying to simply copy one text field to another text field in a table with 10,000 records, in batches of 50 with the Scripting App. What am I doing wrong in this block: let table = base.getTable('TableName'); let query = await table.selectRecordsAsync(); let records = query.records; const BATCH_SIZE = 50; updateLotsOfRecords(records ); async function updateLotsOfRecords(records) { let i = 0; while (i < records.length) { const recordBatch = records.slice(i, i + BATCH_SIZE); for (let record of recordBatch ) { let soureValue = record.getCellValue('SourceField'); await table.updateRecordAsync(record, { 'DestinationField': soureValue }); } i += BATCH_SIZE; } }

54
D
C
Case_LarsenNew Participant
posted in Development & APIs
Fix for INVALID_VALUE_FOR_COLUMN for single line text column

This behavior started a couple weeks ago. Using Airtable’s airtable JS API v0.5.8, I used to be able to call update() successfully on table where the value for column to be updated was a javascript number. Now it returns the error INVALID_VALUE_FOR_COLUMN. When I convert the number to a string before passing it into the update() call, it works. Just a workaround FYI for others. It seems like is some stronger API checking going on on the Airtable server API side.

17912
K
J
Jeremy_TaylorKnown Participant
posted in Development & APIs
If / else / else if Statement in Scripting App

I have 2 tables that I am working with, one called Projects and the other called Tracking (which are essentially tasks). I created a button in the Projects table that will run the script below when pressed. I have 3 separate template views in the Tracking table: 1) Residential Diagnostic 2) Development Planning and 3) Internal. Whenever I run the script, it enters the tasks associated with the Internal view regardless of the Work Type I select. Can anyone tell me where I am going wrong? // pick tables & views from your base here let checklistTable = base.getTable(“Tracking”); let projectsTable = base.getTable(“Projects”); let allProjects = projectsTable.getView(“All Projects, all fields”); // select an event to create a checklist for let selectedEventRecord = await input.recordAsync( “Choose a project to create checklist for”, allProjects, ); let workType = selectedEventRecord.getCellValue(‘Work Type Text’) if (workType == “Residential Diagnostic”) { let templateView = checklis

622
JonathanBowen
J
Jonathan_FrankParticipating Frequently
posted in Development & APIs
Script with fetch is failing

I’m trying to use scripting to call APITemplate.io to create a PDF file from some data. The fetch is failing. It works from Postman so I know the call is valid. I’ve taken the exact code from the Airtable script and run it locally in node.js - with the addition of npm install node-fetch and some top-level async function syntax so I can await, and that works fine too. So there’s something about calling the code from within an Airtable script that makes it return with a 303 error. Unfortunately I can’t find any logging at apitemplate.io to help me. Anyone have any ideas as to what I can look at? let url = "https://api.apitemplate.io/v1/create?template_id=<id>"; let headers = { "X-API-KEY": "<apikey>", "Content-Type": "application/json" }; let body = {content: "data"}; let response = await fetch(url, { method: "POST", headers: headers, body: JSON.stringify(body) }); let result = await response.json(); console.log(`download result from : ${result}`);

345
D
S
Sean_Anderson1New Participant
asked in Development & APIs
Error on createTableAsync

I’m trying to create a table using this code: I keep getting this error: Bundle Error: Cannot find module '@airtable/blocks/dist/types/src/types/field' from 'C:\dev\my_app\build\development\transpiled\user\frontend' As you can see…the type is found and no typescript errors are indicated on the line where it is used. Wondering if this is a bug or some issue that needs a work-around. I know this functionality is beta right now.

50
S
R
rebal15Known Participant
posted in Development & APIs
PATCH request not working

I’ve got a cURL PATCH request in order to update a record, however I seem to be getting this error: { "error": { "type": "INVALID_REQUEST_MISSING_FIELDS", "message": "Could not find field \\"fields\\" in the request body" } } This is my current cURL request, I am using PHP: <?php // get cURL resource $ch = curl_init(); // set url curl_setopt($ch, CURLOPT_URL, 'https://api.airtable.com/v0/appmAdTUWbbY2vitV/Members/recl0qsFKY2dkR1NR'); // set method curl_setopt($ch, CURLOPT_CUSTOMREQUEST, 'PATCH'); // return the transfer as a string curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1); // set headers curl_setopt($ch, CURLOPT_HTTPHEADER, [ 'Content-Type: application/json; charset=utf-8', 'Cookie: brw=brwjOwXWWJ95PfnJr', ]); // json body $json_array = [ 'records' => [ [ 'id' => 'recl0qsFKY2dkR1NR', 'fields' => [ 'Rank' => 'Captain' ] ] ] ]; $body = json_encode($json_array); // set body curl_setopt($ch, CURLOPT_POST, 1); c

348
O
M
Martin_CarvalhoNew Participant
asked in Development & APIs
How to pull records from multiple tables and display them in a custom app?

Is it possible to fetch all records from the entire base without needing to pick a single table? I’m creating a To-Do list app that’s pretty much like the example provided by Airtable. We have multiple tables organized by “Offices” like for example “Development”, “Design”, “Marketing” and so on. Each record is a Task. Our goal is to simply display all Records in the App that are not marked as Completed so our manager can easily go through those tasks in one place. The useRecords method requires a Table to be passed as an argument so I thought of maybe looping through all tables and then fetching those records but then I figured that this would make the app not reactive… So… Is this possible? If not, do you have any suggestions of how I could accomplish this? We sure don’t want our manager to have to select which table he’ll be working on since that’s irrelevant to him… Thanks for your help!

550
M
B
Brenton_PartridNew Participant
posted in Development & APIs
Programmatically scroll to/reveal a record within a grid view?

Airtable Blocks SDK is awesome, but ideally we’d like to direct the user to a specific record as seen within a grid view, in the context of all of its peers. For instance, this would supercharge a search app; all of a sudden, if I have a list of hundreds of records, without breaking my “comparing records” flow and forcing me to look only at a single expanded record, I can use an app that will scroll me to that record, if present, in whatever view is active (or one could activate it via cursor.setActiveView). For comparison, Clubhouse.io has this feature in its kanban as a “Reveal” button when looking at global search results, and Pivotal has the “target” Reveal icon within project history and other panels: Seeing project history Is there any way to do this in Airtable?

40
B
S
Sachithra_PathiNew Participant
posted in Development & APIs
Updating a linked column gives an error in airtable

Please help on this issue. stackoverflow.com Updating a linked column gives an error in airtable java, spring-boot, jpa, airtable asked by Sachithra Pathiraja on 11:09AM - 12 May 21 UTC

10
S
H
Halley_JohnsonNew Participant
posted in Development & APIs
Fetch Google search results for keywords

A simple script to fetch search results from Google based on keywords in your base: let table = base.getTable('Searches'); let resultsField = table.getField('Results'); let record = await input.recordAsync('Record', table); let searchQuery = await input.textAsync('Search query'); if (searchQuery) { table.updateRecordAsync(record, {[resultsField.id]: 'Updating...'}); output.markdown(`Searching for ${searchQuery}...`); let results = await searchAsync(searchQuery.split(',').map(term => term.trim()).join('\n')); await table.updateRecordAsync(record, {[resultsField.id]: results}); output.markdown(results); } async function searchAsync(searchTerm) { let response = await fetch( `https://api.apify.com/v2/actor-tasks/<TASK ID>/run-sync-get-dataset-items?token=<TOKEN>`, { method: "POST", headers: {"content-type": "application/json"}, body: JSON.stringify({queries: searchTerm}), }, ); let re

197
T
R
Rishabh_TiwariNew Participant
posted in Development & APIs
What's the status regarding MetaData API, It's been 2 months now

I submitted the form months back and still waiting for the API, I want to create one automated tool. Any sort of deadline or page where I can track the status?

11
E
Barry_Seidensta
Barry_SeidenstaNew Participant
posted in Development & APIs
Where do I start - Connecting with Confex

Hi, I want to be able to gather information from a conference management tool called Confex (www.confex.com). Where do I even begin to understand how to integrate with an IFTT tool? What questions do I need to get answered?

53
Justin_Barrett
L
leowoodsNew Participant
posted in Development & APIs
Button to tick off a checkbox, return popup with record if linked record has not been completed yet

Hi all, I’m not sure if this is possible and if so, how, but I have a to-do list. I have a single line text field called {Title} in Table [Todo Table]. Each record in this table is a task. I also have a checkbox field, called {Done}. I then have a linked record field called {Blocked}. I add linked records in {Blocked} as subtasks. What I would like to achieve is: When I click on the button, the script checks whether {Blocked} is empty (does not contain any linked record) for that record If it’s empty, I need to tick off the checkbox (I have a Filter in place to auto-hide these completed records) If there is a linked record, an error needs to be returned. Ideally, with the content found in field {Title} of the linked record or otherwise just a generic error that there are linked records. I’m not sure if Airtable has any popup that can be generated or any other visual queue? If there is no such thing, the script could just not take any action. This should also give me an indication that

20
L
Peter_Nelson2
Peter_Nelson2Participating Frequently
posted in Development & APIs
Exporting SupportBee help desk tickets to Airtable

I’m wondering if anyone out there uses SupportBee for a help desk system and if so, have you ever considered or developed an Airtable base to backup all your support tickets to? I know you can export (fetch) tickets using the SupportBee API; the API instructions are here: https://supportbee.com/api#fetching_tickets. There’s a Python script for exporting SupportBee tickets to a database: https://github.com/SupportBee/supportbee-export that’s open source, but I’m not a Python developer and can’t easily put that to work. I thought maybe if someone has done something similar already you might share how to script this. Otherwise, there may be an opportunity for a skilled Airtable scripting programmer to build out this functionality and offer it up to SupportBee customers.

20
Peter_Nelson2
G
Giorgio_BazzigaParticipating Frequently
posted in Development & APIs
Update Linked Fields with Automatinos

Hello, I am trying to update linked fields but I am getting an error. I know updating linked fields is challenging in Airtable so I went for the scripting route. Find my code below: //grab info from TF inputs let TFinputs = base.getTable("Fishel Inputs 2021"); let TFview = TFinputs.getView('Update Leaf Lease'); // grab record from previous input let TFRec = input.config(); let queryTFinput = await TFview.selectRecordsAsync(); // get all records in TF inputs let updated_record = queryTFinput.getRecord(TFRec.TFRec); let TFPoleNum = updated_record.getCellValueAsString("Pole # Fix"); let TFPanelBar = updated_record.getCellValueAsString("Panel Barcode"); let TFLightBar = updated_record.getCellValueAsString("Light Barcode"); let TFPoleBar = updated_record.getCellValueAsString("Pole Barcode"); let TFDateIn = updated_record.getCellValueAsString("Day of Entry"); console.log(updated_record) //grab record to update let SLLease = base.getTable("Street Leaf Lease TEST"); let SLLview

30
G
N
Nick_De_JesusNew Participant
posted in Development & APIs
Convert PDFs to Markdown or HTML

I have an airtable database of over 1,000 resumes. I’d like to extract a small set of information from each resume and get it in markdown or HTML. I’ve found javascript libraries that can do this alone, but I’m looking for a way to handle that on Airtable. Ideally, I would love to be able to have this automated for the resumes already in the database and resumes that get added. Would be nice to even create a new attachment on the record with the desired results. Any insight would be helpful, thank you!

62
N
F
f_mileNew Participant
posted in Development & APIs
Import data from API

Hello, Can we import data from API into airtable? If yes how to do so please?

1602
Andy_Cloke
L
LW-SavvyIndieKnown Participant
posted in Development & APIs
Removing Third Party Tracking Cookie on Embeds

Blacklight detected an AirTable third-party cookie on my site? I would rather not “serve these up” to my end-users. Is there currently a way to disable these using embed code, and if not could you please develop it. Browsers are phasing out third-party cookies anyway, and it’s not a good look for AirTable long-term. edit: reposting original post which was incorrectly marked as spam & closed: Removing Third Party AirTable Tracking Cookie on Embeds Development and integrations Blacklight detected an AirTable third-party cookie on my site? I would rather not “serve these up” to my end-users. Is there currently a way to disable these using embed code, and if not could you please develop it. Browsers are phasing out third-party cookies anyway, and it’s not a good look for AirTable long-term. edit: this post was marked as spam for some reason. Not sure if just I tried to post a reply containing the url

40
L
B
BtbmlInspiring
posted in Development & APIs
input.recordAsync Not working?

One of our scripts started erroring out last friday. I wasn’t informed until this morning. Getting the error: P: Validate this value before parsing at main on line 5 Thought this was really odd so I added a new scripting block, added the record picker example and changed nothing, same error. Has something changed recently with the scripting block as a whole?

92
B
R
Rob_WicksNew Participant
posted in Development & APIs
Script to tick all boxes in a given field

Hi All, I am wanting to add a button to a view so that when it is pressed, all the check boxes in the view are ticked. In an ideal world, pressing this button would also send all the records to be printed (I have designed the printable page in page designer) however this is less important for the time being. any assistance would be appreciated. Rob

12
R
Peter_Borg
Peter_BorgKnown Participant
posted in Development & APIs
Appsheet fundamentals integrating with Airtable

If anyone is trying to buid Appsheet apps on top of AIrtable, here’s a few posts you might find useful. And if interested you could provide your own experience. I have found it much more complicated than I expected, and have found very few forum references to help (isn’t anyone else out there trying to do this?) Basic first step, setting up security filters to restrict data access by user profile – I raised this question in AIrtable forum and found this answer in Appsheet forum (my question was already closed before I got a chance to post the answer). How to handle links and table keys if you want to allow Airtable data to be edited and added natively as well as via the appsheet app. I came up with a complicated solution but am wondering if anyone has found an easier way.

440
Peter_Borg

Badge winners

  • Welcome
    YvonneHhas earned the badge Welcome
  • First Topic
    Dwalz3has earned the badge First Topic
  • Welcome
    Dwalz3has earned the badge Welcome
  • Certified Airtable Admin
    nitinjainhas earned the badge Certified Airtable Admin
  • Certified Airtable Admin
    CaitlenBerghas earned the badge Certified Airtable Admin
Show all badges
Terms & Conditions