An open source appointment manager
Scheduling Specialist
If you have a business that requires customers to make an appointment in advance for services, letting them request the appointment via Easy!Appointments can free up your phone line.
Hair salons, medical offices, and other small businesses require customers to book an appointment. Traditionally, small businesses manage these appointments by offering a phone number. Customers call in, and an employee (or the business owner!) sets a date and time, usually writing everything down in an appointment book.
While this approach works, it suffers from a number of shortcomings. Customers can only phone in when the office is open. In addition, internal management becomes cumbersome if more than one person needs to know the next day's schedule: The receptionist then has to spend time telling each professional the weekly schedule instead of working on more important tasks.
To minimize (potentially significantly) these issues, you can leverage the power of technology and let computers do the hard work. Easy!Appointments [1], a free, open source web application, lets customers make appointments over the Internet even after business hours, while letting employees and business owners check their schedules from their smartphones without bothering the receptionist.
Installing Easy!Appointments
Easy!Appointments has a short list of prerequisites. It will run on any modern LAMP stack (see the "LAMP Servers in a Nutshell" box). Table 1 shows the current requirements for the latest stable version at the time of writing this article. I have also tested Easy!Appointments with OpenBSD's httpd and the MariaDB database with great success.
LAMP Servers in a Nutshell
Linux, Apache, MySQL, PHP (LAMP) describes machines serving web applications built upon these tools.
Setting up a LAMP server is very easy, but deploying one is outside the scope of this article. For testing purposes, you can set up a LAMP server in the cloud using a virtual private server (VPS) from Hetzner with a LAMP stack preconfigured (Figure 1). For more information, see Hetzner's documentation [2].
Table 1
Easy!Appointments 1.4.3 Prerequisites
Web server |
Apache 2.4 |
Database |
MySQL 5.7 |
PHP engine |
PHP 7.3 |
The instructions provided here are for setting up Easy!Appointments on a Debian LAMP server. If you are using a minimal Hetzner LAMP install, you will need to install some additional software:
apt-get update apt-get install unzip php7.4-mbstring systemctl restart apache2
Once you have a LAMP server configured, installing Easy!Appointments is a breeze. First, move to your web server root (e.g., /var/www/demo.operationalsecurity.es
) and download Easy!Appointments:
cd /var/www/demo.operationalsecurity.es wget https://github.com/alextselegidis/easyappointments/releases/download/1.4.3/easyappointments-1.4.3.zip
Next, decompress the downloaded archive (you will need the unzip
program installed on your system):
unzip easyappointments-1.4.3.zip
Then, grant the web server user ownership over the files:
chown -R www-data ./*
You will now create a database for the web application as shown in Listing 1. If you are using a minimal Hetzner LAMP install, you will find MySQL's root password (needed to issue all of the following commands) at /root/.hcloud_password
. Keep in mind that passing SQL instructions to MySQL via a pipe is not secure, and it is done here only for the sake of clarity.
Listing 1
Creating a Database
echo "CREATE DATABASE easyappointments;" | mysql -u root -p echo "CREATE USER easyappointments IDENTIFIED BY 'password';" | mysql -u root -p echo "GRANT ALL PRIVILEGES ON easyappointments.* to easyappointments;" | mysql -u root -p
Finally, use the sample configuration file in Listing 2 as a template and edit it to your liking with a text editor:
cp config-sample.php config.php vi config.php
Listing 2
Example config.php
01 <?php 02 class Config { 03 04 // ------------------------------------------------------ 05 // GENERAL SETTINGS 06 // ------------------------------------------------------ 07 08 const BASE_URL = 'https://demo.operationalsecurity.es'; 09 const LANGUAGE = 'english'; 10 const DEBUG_MODE = FALSE; 11 12 // ------------------------------------------------------ 13 // DATABASE SETTINGS 14 // ------------------------------------------------------ 15 16 const DB_HOST = '127.0.0.1'; 17 const DB_NAME = 'easyappointments'; 18 const DB_USERNAME = 'easyappointments'; 19 const DB_PASSWORD = 'some_password_here'; 20 21 // ------------------------------------------------------ 22 // GOOGLE CALENDAR SYNC 23 // ------------------------------------------------------ 24 25 const GOOGLE_SYNC_FEATURE = FALSE; // Enter TRUE or FALSE 26 const GOOGLE_PRODUCT_NAME = ''; 27 const GOOGLE_CLIENT_ID = ''; 28 const GOOGLE_CLIENT_SECRET = ''; 29 const GOOGLE_API_KEY = ''; 30 }
Once Easy!Appointments is loaded, you can visit your new site. An installation wizard will run automatically and help you finish the process (Figure 2).
Business Features
One of Easy!Appointments' most useful features is that it supports more than one service provider. For example, if you are setting up Easy!Appointments for the fictitious Horse Hoofcare business, which employs three farriers, you'll need to create an account for each employee. Customers then will be able to book an appointment with the farrier of their choice. To do this, go to the admin toolbar located at yoursite.com/index.php/user/login and log in.
First, you need to define the types of available appointments in the Services tab. Note that services can be grouped into categories if desired. Each service can have a price, a location, and an estimated completion time (Figure 3). An undocumented feature is that services can be defined as either Fixed or Flexible (see Table 2) [3]. In addition, you can allow multiple concurrent customers to sign up for a service, which is useful for courses and group activities that allow multiple people to sign up at the same time.
Table 2
Fixed and Flexible Appointments
Fixed |
Appointments stack according to their defined duration. (If you have a 30-minute appointment at 09:30, the next available appointment will be at 10:00.) |
Flexible |
Appointments stack to the next interval of 15 minutes. (If you have a 30-minute appointment at 09:30, the next available appointment will be at 10:00, and the next one at 10:15.) |
Once this is done, go to the Users tab and add as many providers as necessary (Figure 4). Keep in mind that you can assign different services to different providers. For example, you can assign Infection Treatment to a provider who is a veterinarian and Hoof Trimming to a farrier. If you have an employee who can provide both services, you can add both to that employee's list of services.
Finally, go to the Business Logic tab located under Settings to set your business hours as well as assign employee breaks (Figure 5).
An optional, though undocumented, step is to configure Easy!Appointments to use an email provider for delivering email notifications to both your customers and employees. Email access can be configured in application/config/email.php
as shown in Listing 3.
Listing 3
Example of email.php file
01 <?php defined('BASEPATH') or exit('No direct script access allowed'); 02 03 $config['useragent'] = 'Easy!Appointments'; 04 $config['protocol'] = 'smtp'; // or 'mail' 05 $config['mailtype'] = 'html'; // or 'text' 06 $config['smtp_auth'] = FALSE; // FALSE for anonymous relays 07 $config['smtp_host'] = 'smtp.example.org'; 08 $config['smtp_debug'] = FALSE; 09 $config['smtp_user'] = ''; 10 $config['smtp_pass'] = ''; 11 $config['smtp_crypto'] = 'tls'; 12 $config['smtp_port'] = '25';
Customer View
When potential customers visit your website, they will be offered a choice of services. Once the customer selects a service, a list of providers will be offered (Figure 6). After selecting a provider, the customer will be prompted to select an appointment time (Figure 7) and enter their contact information via a web form. Finally, an email notification is sent to both the customer and the employee whose services have been booked.
The customer can change or cancel the appointment at any time using a link included in the email notification.
Buy this article as PDF
(incl. VAT)
Buy Linux Magazine
Subscribe to our Linux Newsletters
Find Linux and Open Source Jobs
Subscribe to our ADMIN Newsletters
Support Our Work
Linux Magazine content is made possible with support from readers like you. Please consider contributing when you’ve found an article to be beneficial.
News
-
Thousands of Linux Servers Infected with Stealth Malware Since 2021
Perfctl is capable of remaining undetected, which makes it dangerous and hard to mitigate.
-
Halcyon Creates Anti-Ransomware Protection for Linux
As more Linux systems are targeted by ransomware, Halcyon is stepping up its protection.
-
Valve and Arch Linux Announce Collaboration
Valve and Arch have come together for two projects that will have a serious impact on the Linux distribution.
-
Hacker Successfully Runs Linux on a CPU from the Early ‘70s
From the office of "Look what I can do," Dmitry Grinberg was able to get Linux running on a processor that was created in 1971.
-
OSI and LPI Form Strategic Alliance
With a goal of strengthening Linux and open source communities, this new alliance aims to nurture the growth of more highly skilled professionals.
-
Fedora 41 Beta Available with Some Interesting Additions
If you're a Fedora fan, you'll be excited to hear the beta version of the latest release is now available for testing and includes plenty of updates.
-
AlmaLinux Unveils New Hardware Certification Process
The AlmaLinux Hardware Certification Program run by the Certification Special Interest Group (SIG) aims to ensure seamless compatibility between AlmaLinux and a wide range of hardware configurations.
-
Wind River Introduces eLxr Pro Linux Solution
eLxr Pro offers an end-to-end Linux solution backed by expert commercial support.
-
Juno Tab 3 Launches with Ubuntu 24.04
Anyone looking for a full-blown Linux tablet need look no further. Juno has released the Tab 3.
-
New KDE Slimbook Plasma Available for Preorder
Powered by an AMD Ryzen CPU, the latest KDE Slimbook laptop is powerful enough for local AI tasks.