ColivingLiguria

Apply Now

Candidate Register System

4 min read

Abstract

The Candidate Register is our comprehensive applicant management system, built to collect, store, and analyze data from individuals interested in joining the ColivingLiguria community. This document explains how the system works, what data we collect, and how we maintain privacy compliance.

Candidate Register System

The decision to join a coliving community is significant. We want to understand not just who wants to join us, but why they’re interested, what they bring to the table, and how we can create the best possible match between candidate and community.

The Candidate Register was built to make this process transparent, data-driven, and respectful of everyone’s time.

System Components

Our system consists of three integrated components:

1. Application Form

Location: apply

The application form is a multi-step wizard that guides candidates through providing their information. It’s designed to be:

  • Intuitive: Clear progress indicators and logical flow
  • Respectful: Only asking for information we actually need
  • Multilingual: Supporting Italian, English, Spanish, French, German, and Arabic
  • Accessible: Works on all devices, light and dark modes

Data Collected:

  • Personal Identity: Name, age, gender, nationality, occupation, education level
  • Contact Information: Email, phone, Instagram, or other preferred methods
  • Availability: When they want to join, for how long, specific dates if applicable
  • Candidate Type: Volunteer, Digital Nomad, or Tourist
  • Visa Requirements: Whether they need assistance with Italian visa procedures
  • Lifestyle Information: Dietary preferences, pet ownership, health considerations
  • Skills & Interests: What they can contribute (volunteer work, professional skills)
  • Team Interests: Which WhatsApp groups they’d like to join
  • Engagement Metrics: How likely they are to join, their appreciation level, perceived impact

2. Database Storage

Technology: Cloudflare D1 (SQLite-compatible serverless database)

All submitted applications are stored securely in our D1 database with the following structure:

  • Main Table: candidates - Core applicant information
  • Skills Tables: Many-to-many relationships for volunteer skills and professional roles
  • Interest Tables: WhatsApp teams, internship interests, course preferences

Privacy & Security:

  • Data encrypted in transit and at rest
  • Access restricted to authorized administrators only
  • Compliance with Privacy Policy
  • GDPR-compliant data handling procedures

3. Analytics Dashboard

Location: admin

The admin dashboard provides demographic analysis and insights into our applicant pool. See Demographic Analysis for details.

How It Works

graph LR
    A[Candidate] -->|Fills form| B[/apply]
    B -->|Validates| C{Valid?}
    C -->|No| B
    C -->|Yes| D[Cloudflare Worker]
    D -->|Saves to| E[D1 Database]
    E -->|Powers| F[/admin Dashboard]
    F -->|Insights for| G[Admin Team]

Step-by-Step Flow:

  1. Candidate visits /apply

    • Chooses their preferred language
    • Begins the multi-step form

  2. Form Validation

    • Client-side validation ensures data quality
    • Required fields prevent incomplete submissions
    • Format checking for emails, phones, etc.

  3. Submission

    • Data sent securely to Cloudflare Worker API
    • Backend parses and validates again
    • Inserts into D1 database with transaction safety

  4. Confirmation

    • Success page shows next steps
    • Different messaging based on visa needs
    • Links to book a call with our team

  5. Analytics

    • Dashboard automatically updates
    • New demographic data integrated
    • Insights available in real-time

Technologies Used

Frontend:

  • Quartz v4 (React/TypeScript static site generator)
  • Custom SCSS with ColivingLiguria design palette
  • Vanilla JavaScript for form interactions

Backend:

  • Cloudflare Pages Functions (serverless)
  • TypeScript for type safety
  • RESTful API design

Database:

  • Cloudflare D1 (SQLite-based)
  • Normalized schema design
  • Automatic timestamps and indexing

Deployment:

  • Cloudflare Pages (global CDN)
  • Automatic builds from Git
  • Preview deployments for testing

Design Philosophy

We follow the principles outlined in our Aesthetics guide:

  • Official Palette: All colors from /Advertising/Aesthetics/Color Palette
  • Markdown Style: Following /Advertising/Aesthetics/Markdown Style Guide
  • Accessibility: High contrast, keyboard navigation, screen reader support
  • Performance: Fast loading, minimal JavaScript, efficient queries

Privacy Compliance

Every submission is handled according to our Privacy Policy. Key points:

  • Explicit consent required before submission
  • Data used only for community matching and statistics
  • Right to access, modify, or delete data upon request
  • No sharing with third parties without explicit permission

Links & Related Pages

Future Enhancements

Planned improvements include:

  • Advanced filtering and search in admin dashboard
  • Email notifications for new applications
  • CSV/Excel export functionality
  • Detailed individual candidate profiles
  • Integration with calendar booking system
  • Multi-language dashboard interface

Last Updated: 2025-11-29
Maintained By: ColivingLiguria Software Team

Graph View