Hello! I am with an event company that handles details for Greek events on university campuses. We manage the contracts/bookings for venues, buses and music. The process I inherited includes entering all details for a booking manually on multiple Excel spreadsheets – which we know can be scary and subject to major errors. There are venue tabs, bus tabs and music tabs. I'd like to have a program to enter info and generate details as needed for these events.
Once I get booking information in hand for a new event, a web-based program would be used to enter the details one time – all in one place. This would need to be username and password protected. Here is what I would like included as entry fields:
This would include:
Date of Event
Time of Event
Venue Contact Name
Venue Contact Phone
Venue Contact Email
Band #1 Name
Band #1 Contact Name
Band #1 Contact Phone
Band #1 Contact Email
Band #2 Name
Band #2 Contact Name
Band #2 Contact Phone
Band #2 Contact Email
Date Contract Issued
Contract Status (Signed or Pending – two different colors to differentiate easily)
Payment Date (From Organization)
Payment Date (to Vendor)
I would like to set up all of my contacts/venues/bands in one place and then choose the ones that would be associated with each event (auto-populate).
Next, I’d like to have a way to click a box and send an automatic email/text to the social chair with all details and contact information for the venue manager, bus pick up/drop off, and band contact info for set up. This would be automatically sent two times: 1) when the booking is made and 2) one week prior to the event.
I’d also like for this program to remind social chairs when contracts and payments are due.
Automated emails/texts would be sent when the due dates are approaching to let the social chair know they’re due without my having to individually send emails and texts to chase everyone down. All messages would be listed so I can confirm when they were automatically sent out.
a. The “contract due” reminders would be based on the date contract issued (sent every two days one week after the issue date until contract is submitted).
b. The “payment due” reminders would be based on the date of the event (sent every two days until payment is submitted).
I’d like for this information to be able to be exported into Excel for other needs we have at the office.
The right programmer will be able to give a solid timeframe for completion of project and also show frequent updates on the status of the program development. For completion of this project, this will be up and running on a development webserver I can access to test its functionality as described. I will also need a zip file of the entire source code after completion.
VERY IMPORTANT: To separate you from the spammers, please write I AM REAL as the first line of your reply. I will delete all replies that do not start with this phrase, since most bidders never read the requirements. Thank you for being one who does.
7 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_18% %project_currencyDetails_sign_sub_19%/tunti tähän työhön
Hi there, I see the job requirement and very interested in this job. I have an experience in this job over 3 years. More details on chat. Have a nice day. Thanks Dear.