Build an Appointment Diary in Google Sheets

Completed Posted 6 years ago Paid on delivery
Completed Paid on delivery

We provide consultancy to customers for various durations with each consultant working to their own schedule. We have a team of agents taking bookings over the phone or directly in our premises, therefore we need this to be a cloud-based solution. We work with Google Suite and this suits us well.

We need a perpetual Google Sheet appointment diary to book appointments for clients with a default schedule but with the flexibility to adjust start and end times (Durations) to allow for the various types of consultations that may be booked. A typical default duration will be 30 minutes starting at 9 am with the last appointment ending at 5 pm allowing in this a flexible lunchtime for the consultant.

We may have bookings for 9 am and 10 am, but the next appointment may only require 20-minutes, which means the next available appointment should start at 10:50 am. If an appointment is also booked for 11:30 am, then the space between should be split into two 20-minute appointments. We may subsequently wish to convert the 10:50 am to a 40-minute consultation. Any appointments already booked in the future cannot be affected by booking/adjusting earlier appointments; the time between them should be calculated to achieve the best use of time.

We currently have three consultants with variable clinics, therefore these should be displayed clearly in a weekly format with days at the top and times down the side, however, we would like to be able to easily add another consultant if required, therefore these could be shown as separate tables if necessary.

We would like to be able to select from filters to display the diary for the correct view, this will include:

- which week to show or select a specific date to show only that day

- which month to show

- which consultant to display

- display available appointments

- find booked appointments

- find available appointments for a desired day and time

We would like to click an available slot and enter in a pop-up window the consultation type, an account ID, Title, Name and Phone Number, and have the Account ID and Name displayed in the cell together with colouring the appointment slot a specific colour based on the consultation type.

Booked appointments may need to be rescheduled or cancelled, therefore clicking on a booked appointment should give us a pop-up to view its details or perform an action to Cancel Appointment, Reschedule Appointment, Confirm Arrival or exit with no action. Actions should ideally be logged in a separate table to track how many were cancelled, reschedule or confirmed. Rescheduling an appointment should offer the user to choose a new date and time.

We will also need to be able to block appointments for consultants if they are unavailable (Holidays etc.)

Hopefully, this is enough information to explain our requirement.

Excel HTML PHP Software Architecture Website Design

Project ID: #15916040

About the project

12 proposals Remote project Active 6 years ago

Awarded to:

html5css3php5

Hi, I have well experienced with Google API. Relevant Skills and Experience PHP GOOGLE ANGULAR Proposed Milestones £222 GBP - Final

£222 GBP in 5 days
(156 Reviews)
7.0

12 freelancers are bidding on average £189 for this job

schoudhary1553

Greeting, I have understood your Build an Appointment Diary in Google Sheets task and can do it with your 100% satisfaction. Please ping me for more discussion. Relevant Skills and Experience I have more than 5 year More

£180 GBP in 3 days
(237 Reviews)
7.4
elqueabandona

Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. Check my reviews. Best regards Relevant Skills and Experi More

£200 GBP in 7 days
(182 Reviews)
6.7
myappsdevelopers

Hello Hiring Manager, Looking to Develop an App for your Business? We develop apps like (Uber/airbnb/upwork/kickstarter) With 100% Customisable option according to your Business!! Relevant Skills and Experience Develo More

£300 GBP in 3 days
(6 Reviews)
3.9
allwinvar277

Hello Relevant Skills and Experience Hello

£150 GBP in 3 days
(0 Reviews)
0.0
laurabompat

I can make the sheet for you. I have done similar projects before utilizing google sheets for sharing, appointment setting and updating statuses of leads. Relevant Skills and Experience Campaign management utilizing g More

£222 GBP in 3 days
(0 Reviews)
0.0