We built a database in Fowey that is used throughout this website, and we would like to share it with any other groups who may find it useful.
It’s a self-service DIY setup, with a blank template of the base, and helpful videos and notes to get you started, hosted on the website of Slick Business, one of our local techy businesses.
Facebook post to share onwards:
How to build a fast, free, collaborative database to track and manage community isolation support in your local area.For full information and links to download a copy of the database visithttps://slickbusiness.co/community-isolation-support-database/
Posted by Slick Business on Wednesday, 18 March 2020
Hi, my name is Kay Peacey.
I am in Cornwall in the UK, and we have just spent in this community the last couple of days sort of scrambling, to get a
community support group in place, to support people who are isolated, or who are vulnerable, and who need help right now to deal with what’s happening.
So, I’m a bit of a tech geek, and I happen to know some really good freely available tech tools that you can use collaboratively. Its online and it’s free, and it helps manage and organise all sorts of things.
What we’ve done in this community, is we’ve built a database using a tool called AirTable, completely free, anyone can use it, to manage our community isolation support delivery.
So we’re going to use it to keep track of the people who need help, and the people who can help them, the resources that we’ve go in the community, equipment, keeping a record of what shops are open, what their opening hours are, who’s delivering, what are the meals this week, all sorts of things… who needs a prescription collecting,
and keep track of who needs stuff, who’s delivering to meet that need, has it been done. when did it need doing, and keeping track of all the phone numbers and emails, and stuff like that.
Because yes, Facebook groups are great, but they get really long and really confusing. So a database is a way of just controlling and managing that data. So, if you want to set up one of these databases that we’ve created, you can make a copy of it and use it in your own Community. What you’re going to need to be able to do that is at least one person who is moderately techy.
So, if you’ve got someone who is used to using spreadsheets or databases, great, grab them up see if you can persuade them to be your database boss, because you need someone to take control of it.
If you’ve got anyone who’s already familiar with AirTable, that’s them. As well as that you’re going to need some admin people to help keep on top of it, and share the data with other people in the community who need it.
So, for example, if someone’s given you their contact details they’re going to need to be passed on to the right person,
or tell people where that prescription needs picking up from, pass on the shopping list…. So you need some admin people as well.
And ideally you hook up with your community support networks. Like here, we have a Town Council and they’re going to get involved, the church group’s going to get involved and we’re ALL going to collaborate but we’re going to collaborate using this database, to help us make sure that the people who need help get that help in a good, timely way, as far as we can get it to them, and that we’re keeping track. And so, we’re making the best possible use of the resources that we have in this fantastic community.
So I hope it’s useful to you. Hooray for digital tech, because it’s an amazing tool, AirTable. It’s free to use, so I’m very I’m feeling very grateful right now that we have this at our disposal in our community, and globally, to help meet this sort of really urgent organisational need.
Visit slickbusiness.co/community-isolation-support-database/ for all resources.