Online database that will consist of the following process:
1. The user will input an address with a zip code
2. The zip code the user inputs will query a database of multiple addresses and return the closest offices. (zip code locator script, for example)
3. The user can check off from the list of offices the offices that the user wants to create contact.
4. Once the user submits the checked list of offices, an email gets sent to each office selected with a unique link in the email for each office.
5. The office recipient would click on the unique link, which would take them to a page where they would agree to the terms of service and create a username and password.
6. Once a username and password has been created, and associated with their current contact information from the Office Database, and upon acceptance of the terms of service, the User input address & contact info would be revealed to the office recipient. ALso, the office recipient will have the ability to update any of their profile information.
So, there are two databases that need to be created:
1. The office database (which consists of the locations of each of the offices). I need to be able to bulk-upload a .xls spreadsheet here
2. Tracking/User database (which will hold the User information; the offices the user selects; and the date and time the user selected the particular office to contact them)
The administrator should be able to run reports that would demonstrate the following:
1. Detailed list of users broken down by state
2. Number of offices that a user has selected to contact
3. Number of Offices that have opened the unique link (and when)
## Deliverables
I have created a draft process overview that I would be happy to share. The intent of this particular web database is to be able to track which office actually receives the user's information (for billing purposes).
Also, I might need to install this database on multiple websites.