This database is the third improved iteration of "Seeds and Sowing" that I shared previously. The beauty of running a farming database on Airtable is that running the Airtable app on your smartphone will allow you to add and update records from the field, as you work, while running the app on your Mac or PC will allow you to do more extensive data entry from the comfort of your office.
During the most recent annual inspection of my farm for organic recertification, the inspector was blown away by the power of the database system. A standard part of such inspections is the dreaded audit of documents for "input/output" balance in which the inspector points to a recent sale of an organic product, and demands that the farmer show documents verifying every step in the organic production process including showing that sufficient seeds were sown and organic fertilizer applied to produce the amount of product sole.. The inspector pointed to a sale of 10 lbs of fennel. Using the data base, within 60 seconds, on my Android phone I was able to show that the fennel in question was planted in the greenhouse, on a specific date, using seeds purchased on a specific date, from a specific seed company, and the database provided an image of the seed package and of the purchase receipt. Following links from the sales record in the database I showed records indicating that the plants were transplanted into a particular bed on a specific date and harvested on a specific date, with a specific lot number and I showed records indicating the that the bed in question had been amended on a specific date with specific amounts of organic fertilizers, showing images of the receipts for the fertilizer purchases. Jumping from linked field to linked field I was further able to show sales date and purchaser for the product.
The latest improvements in the database include use of more linked records to eliminate the need to enter the same data in multiple fields, and the use of calculated fields to produce lot numbers automatically for each harvest event.
A detailed description of the database, along with instructions for use, can be found here -