This is how we help hundreds of people during COVID-19

Have a look at the base here.

We are a growing movement of volunteers who have been mobilized due to the current crisis to help the most vulnerable among us - the elderly, the refugees, the domestic abuse survivors, sex workers, single mothers, and others who are not getting their basic needs met.

Who’s it relevant for?

Mutual aid organizations and non-profits - tweak this base to suit your needs.

Our process:

We built an operations management system using Airtable.
It works as a support ticketing system.
Get the general idea by looking at this very high-level flowchart which also appears in the dashboards.

We provide support in 4 ways:

  • :phone: Matching people in need with phone volunteers that talk to them every week and check if they need anything
  • :woman_cook: Matching with cooks to provide hot meals
  • :shopping_cart: Sending food baskets
  • :bulb: Helping with general requests - from clothing to fixing stuff at home

Base features:

  • Volunteers and people in need management
  • Requests tracking
  • Dynamic data visualization
  • Opening WhatsApp conversations with volunteers directly from Airtable
  • Finding optimal geographical matches using the maps block
  • Summarizing extras for food baskets using the pivot table block
  • Rides (food baskets deliveries) calendar
  • Private links for phone volunteers to follow requests they opened to their people in need using forms

In the actual base, we also utilize the scripting block for re-opening hot food requests for people who need a permanent match with a cook but were matched with one-time cooks.

We use Google Forms for our volunteers intake forms and connect them to Airtable using Integromat.
The reasons for this are:

  1. Data validation is available on Google Forms and Integromat.
  2. Options to choose default values. E.g. all responses from the cooks intake form create a volunteer of a “cook” type.

Emojis?

I found that emojis help people navigate quickly between tables and views.

Please let me know what you think :slight_smile:

2 Likes