Hey Guys,
I am looking to create an Appointment Booking system which will allow you to Book, View, Edit and Delete appointments relating to a specific contact. I would like it to display the customer's contact details, show bookable dates and times (15 min intervals), have an overview of which appointments you have booked, create pop-up reminders for the DB user, allow you to send "Confirmation" and "Reminder" emails to the customer and allows you to record details about the appointment on the form.
The way I would like the form to look:
Main Form:
Customer ID
First Name
Last Name
Home Phone
Mobile Phone
Street
City
State/Province
Zip/Postal Code
Country/Region
Email Address
Opt-Out? (Y/N)
Notes
(This form should have a button which will allow you to "Book Appointment".)
I am then looking to have 2 subforms:
Future Appointments: (Shows Upcoming Appointments for this contact)
Appointment Date
Appointment Time
Notes (About this particular Call)
Registration Link Sent (Y/N)
Registration Follow Up (Y/N)
Registration Complete (Y/N)
Inactive (Y/N)
Opt-Out (Y/N) (this should link to the Opt-Out on the customer details form if possible)
Past Appointments: (Shows past appointments for this contact)
Appointment Date
Appointment Time
Notes (About this particular Call)
Registration Link Sent (Y/N)
Registration Follow Up (Y/N)
Registration Complete (Y/N)
Inactive (Y/N)
Opt-Out (Y/N) (this should link to the Opt-Out on the customer details form if possible)
I also need a schedule form which will show you an overview of what appointments you have on that particular day/week/month etc.
I would like a form specifically to create appointments. When you select the customer name that you are creating the appointment for, it should autofill their contact details.
I would like the database to create pop up reminders for the user 15 minutes before an appointment is due to start.
I would like it to be able to send Confirmation/reminder emails to the customer.
You should not be able to double book an appointment, therefor it should have a form showing you which dates/times are available for booking.
The database that I am looking to add this information to is on my OneDrive. It won't let me add a link at the moment but if you need it, let me know and ill find a way to post it.
The login information for the database is Username: admin Password: admin
I know there is a lot of information looking to be put in the system but I can't figure out how to do it.
Any assistance would be much appreciated.
I am looking to create an Appointment Booking system which will allow you to Book, View, Edit and Delete appointments relating to a specific contact. I would like it to display the customer's contact details, show bookable dates and times (15 min intervals), have an overview of which appointments you have booked, create pop-up reminders for the DB user, allow you to send "Confirmation" and "Reminder" emails to the customer and allows you to record details about the appointment on the form.
The way I would like the form to look:
Main Form:
Customer ID
First Name
Last Name
Home Phone
Mobile Phone
Street
City
State/Province
Zip/Postal Code
Country/Region
Email Address
Opt-Out? (Y/N)
Notes
(This form should have a button which will allow you to "Book Appointment".)
I am then looking to have 2 subforms:
Future Appointments: (Shows Upcoming Appointments for this contact)
Appointment Date
Appointment Time
Notes (About this particular Call)
Registration Link Sent (Y/N)
Registration Follow Up (Y/N)
Registration Complete (Y/N)
Inactive (Y/N)
Opt-Out (Y/N) (this should link to the Opt-Out on the customer details form if possible)
Past Appointments: (Shows past appointments for this contact)
Appointment Date
Appointment Time
Notes (About this particular Call)
Registration Link Sent (Y/N)
Registration Follow Up (Y/N)
Registration Complete (Y/N)
Inactive (Y/N)
Opt-Out (Y/N) (this should link to the Opt-Out on the customer details form if possible)
I also need a schedule form which will show you an overview of what appointments you have on that particular day/week/month etc.
I would like a form specifically to create appointments. When you select the customer name that you are creating the appointment for, it should autofill their contact details.
I would like the database to create pop up reminders for the user 15 minutes before an appointment is due to start.
I would like it to be able to send Confirmation/reminder emails to the customer.
You should not be able to double book an appointment, therefor it should have a form showing you which dates/times are available for booking.
The database that I am looking to add this information to is on my OneDrive. It won't let me add a link at the moment but if you need it, let me know and ill find a way to post it.
The login information for the database is Username: admin Password: admin
I know there is a lot of information looking to be put in the system but I can't figure out how to do it.
Any assistance would be much appreciated.