Airtable Database Basics for CHS

Simple Airtable   Sept 2024 click on highlighted:
https://airtable.com/appZT73u0VhiS67ZX/shrbyGf6l55u1dCf1/tblCm726I7x0KVQ4n/viweiMHGJGMBG7lsd
|
Then click on "filter " (upper left)  and set it up so "Description contains gavel"

------------------------------------------------
________________________________

-------------------------------------------------
Airtable Database Basics   for Colrain Historical Society.
There are over 2500 items in the CHS database, using "Airtable" , an online database program. As set up now, it is not very "user friendly", but you can access it at home.  BELOW is what you should see:


============ QUICK SEARCH =====================
Search using the magnifier in upper right.  This is a very limited search feature though, exact words only.  IIn the example, "chicken" finds 3 records. The first record found will be highlighted.  The down arrow leads to the next.  (the "4 cells" means that "chicken is in one of the records twice).



======FILTERS are best way to Search=============
You can use filters as alternative to "quick search". You can choose which columns to filter by, and have many options on how to filter. For example, to find all Photos in Box 15, you would filter "Object" by "photo" and "Location" by "Box 15".

Note that Filters are only available when using a computer and are unavailable on mobile devices.

================================================================================

Airtable is set up with "VIEWS".   "GRID-ALL" is the main view which has all the records. But 2500 + items is a bit daunting.... So, we have set up custom VIEWS for our convenience. The panel on the left side has Groups of Views like SUBJECTS  &  LOCALES.

 Let's try SUBJECTS VIEWS -  about ten of these now.

If you select  "inn" in the SUBJECT  views  you will see 51 Records on the Inn.  (The number count is at the bottom of the View.)


 To EXPAND a record, hover over the leftmost column of a record and click when you see Expand"

See EXPANDED record below: (A Colrain Inn family member had an airplane business out west.).  To see more, you can scroll further down.

 Click on an image to see it larger.  If you can't read it, you will need to "download" the image to your computer ("download" in lower right corner).


More Later =======================================

In February 2024 it is being "hosted" by Dave Allen on his "Old Maps"  business' Airtable account.  The monthly fees are almost nothing as long as the files are on Dave's account so they are not paid by CHS.  At some point, CHS will need to take this over, and may want to move the data to more sophisticated software.....



Comments

  1. AnonymousFebruary 20, 2024 at 9:06 AM

    Such a wonderful addition, will be enjoyed by so many more people..

    ReplyDelete

Post a Comment

Popular posts from this blog

New Items as of April 16

Image
43  "New" items cataloged since early April at the Colrain Historical Society. Most of these are items which were not cataloged prior to now, including several things found in the Pitt bedroom.  Click here for the databas e # 200-217  many old deeds The "43" included about 400 old deeds (cataloged as "17" items) , dating from the late 1700s to about 1930.  These are original land deeds which came from the Registry of Deeds, then to Town of Colrain, then to CHS. They were removed from two oversized boxes, sorted into 17 small batches by decade, and stored in small storage boxes. Most of the deeds are mid-to late 1800s. There are a handful of very early deeds, one of them by Jesse Lyon(s), the noted Colrain furniture builder.  In 1801 Jesse sold 1/4 of an acre to a Judah Pierce and recorded the deed with his signature and a waxed seal of paper.  (Item 202-1). There is also one 1776 deed for 100 acres to Abraham Pennell, also with a waxed seal #2531  Levi Lin
Read more

"New" at CHS - Amos Bardwell Collection

Image
 After recent discussion about some furniture belonging to Amos Bardwell, Sarah decided to scan the 29 documents... Amos Bardwell Collection  CHS # 656 An interesting archive of original deeds, poems, copies of 18th century state petitions and ephemera. The 29 documents we have show activities of Amos, his father Elias, and others. Elias, Daniel Workman & Samuel Browning were on a committee that purchased land in 1815 “for the purpose of burying the dead”, a lot “South of the Brick Schoolhouse”.   In 1811, as a 19-year-old, Amos Bardwell (1792-1875) penned a book “The Scholars Arithmetic”  (xx page booklet) . (Based on internet research, I believe he may have copied some (or all) of the text from a publication of the same name published in Keene, NH in 1807.)   Amos was appointed a Justice of the Peace for Franklin County in 1843, 1850 and 1857.   -----   He was granted permission in 1860 from Lorenzo Langstroth to build his own movable bee hives based on Langstroth’s paten
Read more