Instructions for use.
General Considerations. The Airtable platform is free to use so long as the number of database records is modest, and this may be sufficient for your operation. To avoid bumping up against limits of the free subscription, I personally pay $120/year for more commodious database limits. Airtable does not limit the number of databases you can create within your account, so create a new database for each farming year. Do this by duplicating the database structure and contents from the previous year. In the copy, delete all the records in the Field Log, Greenhouse, Harvest and Sales tables. If desired, also delete records in the other tables that will not be necessary for the new year. For example, if a particular seed packet has been used up, delete the receipt for that packet from the Receipts table, and delete reference to that seed packet purchase from the Seeds table.
Reference Tables. The database tables can loosely be divided into working tables and reference tables. Reference tables generally populate drop-down lists that you will use to fill in the working tables. I suggest you begin customizing the database by working on the reference tables.
- Locations. Begin by completing the Locations table. On my farm, every field and hoophouse is designated by a number, and every bed in the field or hoophouse is designated by a letter. For example, bed H in field 1 is named 1H. Orchard areas also have numbers. Don’t worry about the “Field Log” field. That will get filled in automatically when you reference the location from the Field Log table.
- Receipts. Assemble all the receipts you have on hand for seed and fertilizer purchases. In the Receipts table scroll to the bottom and click the “+” icon to add a new line to the table. In the “Name” field, type a brief description of what the receipt is for. If you are accessing the database from a web browser, use your smartphone to snap a photo of your paper receipt and save it to a location that you can access from the web browser. For example, save copies of the photo to Google Drive or Onedrive. Click in the “Photo” field of the new Receipts record and upload one of your receipt images. The procedure is even simpler if you are accessing the database from the Airtable smartphone app. Click the “Photo” field, then click the camera icon. This will access your smartphone’s camera. Snap a picture of the receipt, which will then be saved directly into the Airtable record. For e-mailed receipts, use the print-to-pdf function of your smartphone or computer, and then upload the pdf into the “Photo” field of the Receipts table. Don’t worry about the other fields. “Seeds” and “Inputs” fields will get filled in automatically when you later reference the receipt images from Seeds and Inputs tables.
- Supplier. In the Supplier table, fill in the name and relevant contact information for the companies from which you purchase seeds, fertilizers, etc.
- Inputs. In the Inputs table, type the description of the input (eg., bone meal, lime), then indicate the supplier using the drop-down list. If you type in a couple letters of the suppliers name, the drop-down list will include only those suppliers that contain those letters. Fill in the purchase date and the amount of the input purchased in the appropriate fields. If the input is OMRI-listed, check the box in the “OMRI” field.Fill in the “Receipts” field of the table from the drop-down list of receipt images you saved previously. You may also wish to include a photo of the fertilizer label, or whatever in the “Photo” field. Do this essentially as described above for receipt images. Don’t worry about the “Field Log” field. This will get filled in automatically when the input is referenced from the Field Log table.
- Seeds. Fill this in essentially as described above for Inputs. The “Photo” field is for recording an image of the seed packet, which you can do essentially as described above for receipt images. If your farm is certified organic, be sure to click the box in the “Organic?” field to indicate whether the seeds are certified organic, and if they are not, record in the “Notes” field the manner in which you searched to determine that an organic version of the seed variety is not available.
- Customers. In the Customers table fill in the names of the customers that buy your products. Don’t worry if you forget a few. You can always add new customers from within the Sales table. Don’t worry about the “Sales” field of the Customers table. This field gets filled in automatically from the Sales table when you make a sale.
- GH Log table. If you use a greenhouse to produce vegetable starts for transplant, this information is recorded in the GH Log table. Whenever you seed a flat in the greenhouse, record the event in this table. Give every flat in your greenhouse a numeric ID. For example, name the 4th flat you seed in the year 2020 as “20-5”. in the “ID” field, indicate this serial number, along with a brief description of what was seeded. Record the seeding date in the “Date” field. Fill in the “Seeds” field from the drop-down list, which gets populated from the Seeds table. Typing a few letters of the seed name in this field will display in the drop-down list only seeds containing those letters. Fill in the “Flat size” field appropriately, for example, with “120 cell”. Don’t worry about the “TP Date, Bed” field. This gets filled in automatically when you record the transplant event in the Field Log table.
- Field Log. This is the most important table in the database. Whenever you fertilize a bed, seed a bed, or transplant into a bed, the information gets recorded here. Keep your smartphone with you in the field so you can record this information on the spot, using the Airtable smartphone app. In the “Name” field, type a brief description of the event being recorded, as well as the location code. For example, if leeks were transplanted into field 1 Bed K, type 1K Leeks. In the “Date” field record the date of the event. In the “Location” field, add the location of the bed from the drop-down list, which is populated from the Location table. In the “Notes” field, record what was done. For example, “fertilized with 3 lbs of bone meal and seeded with salad mix”. If an input was added to the bed (for example, bone meal) record the nature of the input in the “Input” field, from the drop-down list which is populated from the Inputs table. If you have planted seeds, or transplanted starts from the greenhouse, record this information in the “Seeds” field or the “GH Log” field, from the drop-down lists.
- Harvest table. Whenever you harvest anything, record the event here. In the “Products” field enter a brief descriptor of the vegetable harvested. In the “Field reference” field, choose the entry from the Field Log table that describes planting the vegetable in question. Record the harvest date and the amount harvested in the corresponding fields. If you employ lot numbers to track products, enter this in the “Lot #” field. The “Sales” field will become populated automatically when you sell the item in question.
- Sales table. In the “Harvest ref” field, choose the item sold from the drop-down list of items harvested, then record the date of the sale and the quantity sold in the corresponding fields. Choose the customer who bought the item from the drop-down list in the “Customer” field. If the customer is a new one, click the “+” icon in the “Customer” field, then click “new record”, opening up a window to enter the customer, along with customer contact info, in the Customer table.
That’s it! Every single farm operation is now seamlessly linked. For example, choosing “Leeks” in the “Harvest ref” field of the Sales table opens up a window that indicates the lot # of the item sold and the contains links to records indicating the field location and date of harvest and if relevant, the greenhouse flat from which the item was transplanted, the amount harvested and the customer or customers that purchased the item harvested. Further, links within this new window will take you to records indicating the seed purchase corresponding to the item sold and the fertilizers applied to the bed from which the item sold was harvested. Choosing a particular customer in the Customer table will open a window revealing a list of every item that customer purchased. Choosing a record in the Seeds table will display every instance where those seeds were planted in the greenhouse or in the field.