© We Know Data 2023
Mutual Aid: Helping volunteers support people who were self-isolating during the pandemic, for free by using Claris Connect and FileMaker Pro.
As the world struggled to cope with the recent Coronavirus pandemic, our Claris FileMaker developers wanted to help. There was a growing need to find a way to help people in self-isolation who couldn't leave their homes. Our team worked with Hollingdean Group in Brighton to create a free piece of software to manage volunteers and requests for help.
Desktop, Mobile, SMS, Tablet, Web Portal
What was the opportunity to help?
Mutual Aid organisations had been springing up all over the country to help those self-isolating. Thousands of people had volunteered to help, and these new mutual aid organisations suddenly needed to oversee many requests. At first organisers used colour-coded spreadsheets to manage requests and volunteers. This system quickly became complicated to maintain. We met with the Mutual Aid Group to see how a database could help them better manage the requests that they were receiving.
What was the solution?
Following a meeting with the group, we proposed building a system based around Claris FileMaker that would help ease the process.
- The system gave users of differing technical skills the ability to access help. They can make requests by Text, Email, or Web form.
- It provides personal security. People have reassurance that they know in advance who is helping them.
- People isolating received updates throughout the process. It helped administrators and volunteers:
- The system provides administrators with one place to manage all requests and volunteers.
1. Contact Management:
Along with standard contact details, it also allowed us to store information that could make productivity better, such as whether someone was high-risk, volunteers who have CRB checks, or access to a vehicle. For the more tech savvy users, we created a form in Typeform that captured required data and with the help of Claris Connect pushed it straight into their Filemaker System.
We proposed a user hierarchy for the system. Admin, Super User, and Data Entry. This meant that people could quickly access only the information that was relevant to them.
3. Managing priorities:
Urgent actions were flagged as being needed first, such as a family running out of nappies or an urgent prescription.
We had a process for managing services volunteers would provide, tasks that needed carrying out, and areas for notes and documents. Alerts were shown on a dashboard and they related to people and not just tasks. For example, if a resident is flagged as potentially vulnerable and their database records have not been modified, a task can be created for a volunteer to check on them.
5. Text messages:
We added the ability to send triggered text messages. For example, sending a text message to someone who is isolating to check whether they are satisfied that the task is complete and to ask if there is anything else they need.
For users with no internet access we worked with an incredible service by Twilio to allow text messages to be passed straight into the system.
One of the biggest challenges when creating a system for such a broad range of people is how they can access it. Many elderly users do not have access to a computer or may not be confident using technology. To facilitate this, we built a system to allow service users (the self-isolated residents) to send a text message to a designated phone number, stating their postcode and what they require. The dashboard was Web-Based meaning volunteers could access it on smartphones and laptops.