Airtable API examples & templates

Use these vals as a playground to view and fork Airtable API examples and templates on Val Town. Run any example below or find templates that can be used as a pre-built solution.

stnkvcs

getAirtableDataAPI

// Initialize Airtable configuration

HTTP

mattx

airtable_get_sample

An interactive, runnable TypeScript val by mattx

Script

steveb1313

GetPelotonWorkoutsAndSaveToAirTable

An interactive, runnable TypeScript val by steveb1313

Script

mattx

airtable_deno_sample

An interactive, runnable TypeScript val by mattx

Script

hello_mikkie

myTable

// Sample data from: https://blog.airtable.com/database-vs-spreadsheet/

HTTP

cingozilyas

sweetAzureFinch

An interactive, runnable TypeScript val by cingozilyas

Script

yawnxyz

buildclubProjectSearch

Use embeddings / Lunr search on Airtable. Embeddings need to have been generated / stored on Airtable, or this gets very slow / costly. Simple usage: https://yawnxyz-buildclubprojectsearch.web.val.run/search?query=cars Full GET request: https://yawnxyz-buildclubprojectsearch.web.val.run/search?query=your+search+query&similarity_threshold=0.8&max_results=5&base_id=your_base_id&table_name=your_table_name&content_column=your_content_column&embedding_column=your_embedding_column

HTTP

bansal

kickstart_feedback

@jsxImportSource https://esm.sh/react

HTTP

andreterron

receive_email

An interactive, runnable TypeScript val by andreterron

Script

awhitter

API_URL

Remix of: std/API_URL

Script

awhitter

competentOlivePeacock

Remix of: awhitter/contentTemplateApp

HTTP

devonzuegel

subscribe_to_a_substack

// I was able to get this script to work from my browser console, but

Script

awhitter

contentTemplateApp

HTTP

bensu

subscribe_to_a_substack

Remix of: devonzuegel/subscribe_to_a_substack

Script

yawnxyz

coverpatch

// import { covertest as test } from "../covertest/covertest.ts";

Script

nbbaier

sqliteExplorerApp

SQLite Explorer View and interact with your Val Town SQLite data. It's based off Steve's excellent SQLite Admin val, adding the ability to run SQLite queries directly in the interface. This new version has a revised UI and that's heavily inspired by LibSQL Studio by invisal . This is now more an SPA, with tables, queries and results showing up on the same page. Install Install the latest stable version (v86) by forking this val: Authentication Login to your SQLite Explorer with password authentication with your Val Town API Token as the password. Todos / Plans [ ] improve error handling [ ] improve table formatting [ ] sticky table headers [x] add codemirror [ ] add loading indication to the run button (initial version shipped) [ ] add ability to favorite queries [ ] add saving of last query run for a table (started) [ ] add visible output for non-query statements [ ] add schema viewing [ ] add refresh to table list sidebar after CREATE/DROP/ALTER statements [ ] add automatic execution of initial select query on double click [x] add views to the sidebar [ ] add triggers to sidebar [ ] add upload from SQL, CSV and JSON [ ] add ability to connect to a non-val town Turso database [x] fix wonky sidebar separator height problem (thanks to @stevekrouse) [x] make result tables scrollable [x] add export to CSV, and JSON (CSV and JSON helper functions written in this val . Thanks to @pomdtr for merging the initial version!) [x] add listener for cmd+enter to submit query

HTTP

2 3 4 5

…