These are static tables I find myself using frequently when building bases for clients, so I keep a copy of them on their own in my account so I can easily copy-paste them into bases when needed. I’m creating this wiki to share them in case other people might want to use them, or contribute their own reusable pre-mades.
To make use of these, open the base through the links below, then use the “Copy base” button (top right corner) to add a copy of it to your own workspace. Then, you can copy (⌘/ctrl + a → ⌘/ctrl + c) and paste the table desired into other bases as needed.
US & CA States/Districts/Territories
Includes Country, Capital City, and Postal Abbreviation.
Airtable Keyboard Shortcuts
The same list you can access from the “Help” menu, but will be hit by global searches from the Search Block if included in a base, which is a bit more exposed and allows serendipitous discovery of shortcuts by users.
AlphaNumeric ID Generator
Produces the ID’s AA001 - ZZ999 in sequence, for a total of 675,324 unique ID’s. Thanks to @W_Vann_Hall for building this one.
Timezone single-select
Instructions here on how to create a single-select field containing supported timezone indicators for use with SET_TIMEZONE(). (Note: It appears Airtable has modified the TZ list since that reply was originally written: You’ll also want to delete the empty records from the resulting base before converting the single-line text field to single-select, and you’ll need to append a comma to the new[?] 'GMT' entry.)
U.S. Holiday Generator for WORKDAY() Functions
Select the years you want to generate holidays for, and optionally check/uncheck those ambiguous holidays, to generate a list of dates for each year, and a list for ALL years selected, which can easily be copied and pasted into WORKDAY() functions. Thanks to @W_Vann_Hall for building this excellent tool.
U.K. Holiday Generator for WORKDAY() Functions
Select the years for which you want holidays and the U.K. holiday type — England, Wales, Scotland, Northern Ireland, Republic of Ireland — and the base will generate an ISO-formatted list of holiday dates to paste into WORKDAY() or WORKDAY_DIFF(). Includes code to calculate the date of Easter for any year 1900 through 2033.
URL [and General Text] Cleaning and Validation Routines
Link to a number of handy canned formulas for doing such things as stripping punctuation from text fields, cleaning and standardizing URLs, removing query strings, and the like. Thanks to @willinspire for providing these!
World/US State Database
Another great @willinspire creation, a base that, to quote,
[contains] every country name, ISO alpha2 code, ISO alpha3 code, national flag, currency name, currency ticker, national language, time zone, international dialing code, national capital, GPS grid location, and alternative and native language spelling of every country in the world.
It also includes every US state, state flag, state seal, state map, image of the states largest urban areas, image of every state’s rural area, capital city of every state, and a list of the largest largest cities in the US. … among other things.
DataDB is a public collection of Open Source Intelligence (OSINT) data that is designed to fortify and expedite research activities for a wide range of interested parties.
@Sebastian_Sieber You’re not doing anything wrong. Only the bases that @Jeremy_Oglesby made himself can be copied. If you read the comment with the “World/US State Database” base, Jeremy pointed out that it’s made by @willinspire . You will have to ask him about copying it.
