Looking for a system that looks like the image attached.
Going down the left side will be "Categories" Each category will have it's own JQuery table with a certain type of data in it.
When we click on the table row we will get a edit box, where we can update/delete a record. We of course need a button somewhere that allows us to add a record.
The Market area at the top is a search box for a special code that comes from a table like this [login to view URL]://[login to view URL] A ZIP code is entered and the system looks for the MSA code and displays all the records in the table that have been assigned an MSA code.
There needs to be an import list function, and an export list function for each category.
ALL imported data will be created so it matches the table layout for that category.
When lists are imported or a record is added the application needs to look at the ZIP code and assign it to a MSA (read about MSA's at the link above.
The image attached is actually an "ADMIN" type of template and we will provide that.
To keep each phase of the project small. We can do each "Category" as a separate project.
Each category will have a separate record layout, when adding, updating a record in a row there will be more columns of data than are seen on the row in table view.
The first category is Churches.
Fields are:
Record ID (visable in table view)
Market Area (not visable in table view)
Name
Address
City
State
Zip
Email
Size
Phone
We will supply a US ZIP code file as mentioned in the link above.
This first pase will be larger than the rest of the 10 phases because the ZIP code table and code needs to be created to assign those MSA (Market Areas) needs to be created for record import.
This is a long term project for the right and qualified programmer. Must be rated well on SL to obtain work.