The thumbnail is decorative. A blue card with Logical Developments logo in the top left corner on a white background. The Logical Developments logo is a diamond with the letters L and D inside of it. The letters are offset from each other vertically while also overlapping horizontally. The each sit inside of their own rectangle. The thumbnail has the title printed on it - "Emmaus Community Database: Building a tool fit for a community" written in white and then yellow.

The Emmaus Online Community Database

Paul Mulroney - 14 July 2022

Community groups and volunteer organisations the world over generate and need to maintain mountains of data in easy and efficient ways. Several years ago we were approached by a group called Emmaus to create a solution that does just that.

Emmaus is a global movement of Christians overseen by the Upper Room. Over one million people have attended an Emmaus Ministries experience. Each of the programs within the Emmaus Ministry will take people on a spiritual journey including prayer, fellowship, communion and engaging talks on God's Grace. Empowering leaders to be the hands and feet of Christ. Emmaus Ministries encourages Christians to actively serve and share God's love in their local communities, partnering with local churches to develop Christian Discipleship.

An Emmaus retreat weekend is information intensive. There are registration forms, team lists, participant lists, volunteer support lists, a prayer vigil list and so on. The local Emmaus community database person gathers this information and collates it together to produce a spreadsheet that often looks like this:

An excel spreadsheet zoomed out to show 40+ columns and 100+ rows of related information, colour coded.

People use the tools available to them to solve the problem, and to their credit, there is an impressive amount of information recorded.  However, there are limitations to using Excel:

  • It is searchable in a way, but there is no way to correlate information. E.g. how many times did member X serve on team? Who hasn’t served on team? Who is suitable and wasn’t called?  Who was called but responded with no?
  • Excel is flexible, but it is too easy to delete data accidentally.
  • There is no error checking – it is possible to enter nonsense data and there is no way to verify it.
  • It is stored as a file on a person’s computer.  If I send a copy to another member, there are now two versions: which one is the current version?
  • Team list, pilgrim list, prayer vigil are all related pieces of information, but with no central way to share.

The biggest problem of all, is this:

Bart Simpson writes the phrase 'excel is not a database' repeatedly on the= school chalkboard.

Around 2015 Logical Developments began development of a web-based system using Omnis Studio for the application logic.  The Emmaus online community database is in use by Emmaus communities around Australia.  Built to facilitate restricted, multi-user access, it provides a membership database which allows the community to centralise and secure their data.  Roles can be created, so that users only see the information that they’re permitted to see. It allows them to store information on the annual retreats and regular gatherings so they can monitor the health of the community.  Among other features, it has newsletter functions built in to allow the community to easily manage contact lists.

What this means for communities is that the data is more accurate; there is no duplication of information, or operating with outdated information anymore – data is always up-to-date.  The information is secured centrally, and access can be better controlled. It also means that volunteers are more likely to get involved because the processes are easier overall.

A screen that displays all the information for a given memeber of the community. The user is able to record, First and Last name, Gender, Date of Birth. They can also indicate if the person does not want to be contacted, is inactive in the community or has passed away (and the year they passed away). Other details that can be collected are address, phone number & preferred contact number, email address, preferred name, occupation and emergancy contact. Across the top of the form are tabs indicating other categories of information related to the person - walks, gatherings, teams, notes, newsletters and administration. In the side bar are the sections of the Community Database - Administration, Registrar, Health, Team Selection and Board. The banner of the page displays the name and logo of the community, the currently logged in user and a log out button.

If your organisation operates from a number of locations, and data needs to be centralised but also accessed remotely, then it makes sense to consider a web-based system like this. Creating software from the ground up to solve unique problems is what we do best at Logical Developments. Take a look at our other work, and if you have a problem in need of solving, we’d love to hear from you.

We’re also preparing to start a newsletter. If you’d like to hear from us directly, jump over to our contact page and join!