Member registry
An online member registry for a medical scientific society. It replaced an old Access database with about 1,500 members, subscriptions and scientific sections, without losing a single record.
The screens show the real app with made-up data. Move your mouse for 3D.
The need
A registry on one computer.
The members, their subscriptions and their enrolments in the scientific sections lived in a Microsoft Access database, on one computer in the secretariat. Finding out who was paid up, or which members belonged to a section, meant manual work in Excel.
The solution
The same registry, online and secure.
We built a web app with the fields and the logic the secretariat already used. We moved over every member, subscription and section, checking that every link between them stayed correct.
Members Subscriptions Sections Elections Excel export
At a glance
Who is paid up, in one click.
- Three yearsThe subscriptions of the last three years appear next to each member.
- Ready-made filtersAge, category, specialty, section, arrears and inactive members, in any combination.
- ExcelWhatever you filter downloads to Excel, with the columns you choose.
What it does
The whole secretariat, in one app.
The modules
- A member card with every detail, several emails and phone numbers, and free fields for notes.
- Member categories (full, probationary, corresponding and honorary) and specialties.
- Scientific sections, with a main section and an enrolment reference number.
- Subscriptions by year, with the date and the payment method.
- Automatic membership of the young members’ group when specialty and age match, with the option to exclude a member.
- Custom fields the secretariat adds itself, without a developer.
- An activity log, and a recycle bin for every deletion.
- Notifications for whatever was done automatically.
Security
Access only from approved networks.
The app opens only from the addresses the administrator sets. Two user levels, daily backups and a backup download with one button.
The migration
- ~1,500 members from the Microsoft Access database
- Many years of subscriptions for each member
- New section numbering with no wrong matches
- Hosting on the client’s own server

