How to plan your fruit and veg garden with my new free tools

Last year I decided that planning my allotment on a spreadsheet wasn’t for me.  I’m a visual person and I found messing around with a spreadsheet was a real chore, I wanted to enjoy my planning.  I decided to use Airtable as the basis for a solution, I chose it because it had many of the same features that a spreadsheet did, but rather than just being boring text, it was beautiful, or at least it could be beautiful when loaded with photos of the wonderful fruit and veg that we grow.

My databases have evolved over time and become more of a joy with every yearly update that I work on.  This release adds functionality for managing seed packets and integrates these into the rest of the database.  It also adds a first attempt at bed planning, which will no doubt improve next year.

The database is not an app, I don’t sell it, I don’t really support it, I just gift it to the community to do with as they will.   It’s ready to use as it is, but to really get the best of it you should customise it to suit your specific needs, take a copy of it and make it your own!

This may be way too complicated for your needs, if so I suggest that you look at this video https://steves.seasidelife.com/2020/01/18/all-year-round-vegetable-sowing-planting-guide/ for something simpler!

This first video, shows you how I use it, why I use it and some of the basic features.

This second video shows you how to get started, how to create an account, take a copy of my databases and then customise them.  It shows you how to have a play with my data and then how to add your own.  Don’t be afraid to break things, you can take another copy and try again.

This third video goes deep into the seed packet management functionality, which I’m most excited about, it’s already paying dividends for me!  It’s not only saving me money and reducing waste, but it’s also so much fun to play with.

This next video provides a bit more information about the features that we added to the database in summer to keep track of all of our preserves, the recipes we used etc.

Finally we have the two older videos, which might still be useful, because they go deeper into some of the older features,  but you need to remember that these show a very different version of the database and not everything shown will exist now.  This is the very first video:

This is the second release, a bit more refined, but still a long way to go!

Ok, so that’s the videos over with.  If you want to get a copy of the tools that I demonstrate in this video please click on this link and create an account:
https://airtable.com/invite/r/WzGlQnBX

If you already have an account then click on this link and https://airtable.com/universe/creator/usr9tY4KaKvgGM1um/steves-seaside-allotment take a copy of the databases to use for yourself.  Remember you can customise it to suit your own needs.

Here’s a brief summary of why I chose to develop this database:

  1. I wanted an easy way to capture everything I was learning about gardening
  2. I wanted a way to manage all of the seed packets I have
  3. I wanted a way to plan what to plant in each bed and when
  4. I wanted a way to plan and track everything I was sowing
  5. I wanted a way to share that with youtubers
  6. Ideally I wanted to be able to share views onto the database for particular videos, for example “everything I sowed in January”, “everything I planted in April”, “all of the cabbages I’m growing this year” all from a single source
  7. I wanted something to have fun doing on rainy winter days!
  8. I wanted an app that would work well in the browser, on my PC and on my iPhone

Since my database is built on top of Airtable, you can learn a lot by watching their tutorials and reading their guides too: https://support.airtable.com/hc/en-us

Finally I’m aware that there are lots of other tools out there, ranging from spreadsheets to full blown graphical planning applications. I’ve tried a few of them, but they don’t meet my needs, some don’t deal with my climate very well, or they don’t work well for early and late season planting or they are just too complex or expensive.

You might however find they suit you better than mine, because:

  1. Mine doesn’t have professional support
  2. It isn’t very slick and polished
  3. It relies on you customising it to your needs
  4. Migrating data from one version to the next isn’t automated

If you are new to my allotment videos you might find a bit of context useful. We have three allotments in my family, mine (Steve), my wife’s (Debbie) and my middle daughter’s (Jennie). We also have a small kitchen garden at home. They are all managed in an integrated fashion, so don’t expect to see the usual mix of veg on each plot.

On Jennie’s plot, for example, we focus on potatoes, squash, alliums, and brassicas. This video provides an overview:

I do an update of the allotments, roughly one a week, you can find the tours here:

Our approach to allotment life is to: grow as much as we possibly can, to be self-sufficient in veg all year round and in fruit in season, to give away our huge surplus to friends and family, and to have as much fun as possible.

My wife and I spend about 4 hours a day, 4 days a week on the plots (on average) and we keep nudging that down as we eliminate non-productive work: like grass cutting, weeding and watering as much as practical. We are both newbie gardeners, only starting the allotments in 2016.

I’m a bit obsessive about the nutrient density of the veg that we grow and making the plots easy to work because it’s through this allotment lifestyle and food that I’ve overcome a debilitating auto-immune disease.

I’m always aware though that it might not last so I make sure that I don’t work too hard, eat as much organic fruit and veg I can and design the plots so that I can still work them if I flare up again.

Steve Richards

I'm retired from work as a business and IT strategist. now I'm travelling, hiking, cycling, swimming, reading, gardening, learning, writing this blog and generally enjoying good times with friends and family

9 Responses

  1. Mark Anson says:

    Hi Steve,
    I have been using you database to develop one for myself.
    Thank you so much, I follow your Youtube channel avidly.
    A game changer for me.
    I am trying to be self sufficient as you are but on a 750m2 house block.
    Hoping to eventually produce some of my own protein by growing quail.
    I have tried for many years with excel and google sheets to write some sort of Database but with no real success.
    Have fallen in love with airtable despite its lack of formatting and a few other missing features.
    I noticed that you are receiving some error messges in some of your fields.
    It may be that you are fine with that and apologies for being presumptuous if that is the case.
    In the spirit that you share your hard work by making your database freely available, If you would like to get rid of those error messages you can use the formuls below.
    I have only done three fields but the same formula structure will work on the others as well.
    If either Field is missing you will just get a blank field.
    If you wish to enter somethig to say the data is missing you can enter something in between the last to inverted commas of the formula..
    Hope these help

    Table: First harvest Dates – Field: Difference in Dates
    IF({First harvest 2020},IF({First harvest 2019},DATETIME_DIFF({First harvest 2019},{First harvest 2020},’days’)+365,””))

    Table: Sowing Log – Field: Days to Germinate
    IF({Germination Date},IF({Sowing date},DATETIME_DIFF({Germination Date},{Sowing date},’d’),””))

    Table: Sowing Log – Field: Days in plugs/pots
    IF({Planting Date},IF({Germination Date},DATETIME_DIFF({Planting Date},{Germination Date},’d’),””))

    Cheers and thanks for your channel, your database and your hard work to share it.

    Mark

    Ps the Airtable community is amazing in helping out…..

  2. Mark Anson says:

    Ps …you may need to re-enter the inverted commas and apostrophe as the formatting appeasr not to hold if you copy straight from my reply,

  3. Thanks Mark, pleased you are enjoying the database and channel. I really hoped that people would embrace and extend what I’ve done because I’m very much an 80/20 person, only doing the 20% of effort that delivers the 80% of benefit, hence not getting around to the error catching formulas (thanks for those!). All my life people have taken my original ideas and taken them forward, it’s in my DNA to start and let others finish (some call that lazy). Thanks for the great feedback, keeps me motivated! : All the best – Steve

  4. Hi Mark, I’ve fixed the errors using your formulas since you made ti so easy for me and republished my databases with the fixes

  1. January 27, 2020
  2. January 28, 2020
  3. February 1, 2020

    […] How to plan your fruit and veg garden with my new free tools January 26, 2020 […]

  4. March 23, 2020

    […] Here’s an extract from my database with the details of what we are growing to fight COVID 19. For more details of my database and how to get a copy please read this article […]

  5. March 31, 2020

    […] interested in the databases that I used to manage the allotments I also have a video and associated blog post about them.  The blog post has all of the details on how to get your own copy of the database […]

Leave a Reply

Your email address will not be published. Required fields are marked *

%d bloggers like this: