Semi-Automated Booking System

• Project ID:

  1444874

• Project Type:

  Fixed

• Budget:

  £20-£250 GBP
  (Approx. $41-$523 NZD)

Project Description:

We are looking to have a semi-automated booking system (or as automated as possible) for confirming groups to specific time slots available at multiple venues throughout the country. It maybe can't be completely automated as there are a few processes and checks that are manual, but automatic e-mail reminders and autoresponders would be great.

We currently do everything from an excel spreadsheet and manually sort and filter to find out who has responded / paid / confirmed / replied etc. and would definitly benefit from a bespoke system that all the information could be easily arranged in to get reports and set reminders etc.

To give you a better picture, the process is
1. An enquiry comes to us
2. We contact the venue to confirm if the date / time is available. If it is available, you they it as a provisional booking until further notice.
3. We contact the enquirer with confirmation that the date and time is available or to ask for a different date and time as there is no availability, and get them to confirm the event with a deposit paid online. Reminders go out until the enquirer confirms with a deposit / says they dont want it / the venue needs the time slot back.
4. If the enquirer confirms with a deposit. We send the venue and the enquirer an e-mail confirming all the details
5. A week prior to the masterclass an e-mail is sent out to see if any more people are being added to the group.
6. After the event, a follow up e-mail survey is sent out

We have a flow chart of the processes that we would like to be as automated as possible. There are usually 2 options at each stage. See attached word file (and feel free to ignore the red and blue boxes and decide for yourself what can be automated or not.

Skills required:

CMS, Database Administration, Microsoft Access, SQL

Additional Files:

flowchart+for+booking+spreadsheet1.docx