Database / Airtable / Excel Consultant Needed

I am the manager of a local cleaning company and we need help managing our customer and appointment database.

We would like to create a database (most likely in airtable, but open to your suggestions) for all of our employees, clients, and appointments.
We would like to have views so that we can see every appointment matched to its respective client and employees that were sent to fulfill the appointment.

Ideally the database would also automatically populated be from our scheduling software, Full Slate.

We have been manually creating daily schedules via excel which has become unsustainable. We have to create this daily schedule because our scheduling software Full Slate, although it does a good job of saving our online bookings, doesnt have a very good and flexible way of assigning different employees to different clients.

It may be hard to extract the cleaners in our excel files from each appointment because the sheets from every day are not uniform, and there are multiple cleaners in the same cells.

We would like to be able to do the following:
-select a date and see all the appointments with assigned employees
-select an employee and see their appointment history
-select a client and see their appointment history


We would also like to be able to generate a nicely formatted daily schedules from the database, preferably in Microsoft word. I have a template of what we would like it to look like. We need to do this because part of our daily workflow is to print out the schedule for each of our employees in the morning.


Thanks and please let me know if there are any additional details required!
About the recuiter
Member since May 20, 2018
Chandradeep G
from Tuamotu, French Polynesia

---

---

Looking for help? Checkout our video tutorial
How to search and apply for jobs

How to apply? Do you have more questions about the Job?
See frequently asked questions