FILEMAKER DATABASE for Mac, PC, iOS with Reporting Capabilities in 2 weeks.
Import of Data will be from a Fully Populated Excel Spreadsheet with under 500 records and 25 Data Fields
I am looking for someone experienced with the FileMaker Platform to convert an Excel Contact List Spreadsheet into an aesthetically pleasing Tabbed Contact Management Database that allows reporting of principally date math, sums, filters for categories that can be programmed (and saved) based on multi-field queries, as well as have container fields to add PDF & JPG content.
Integration of Mail Communications would be awesome but not necessarily an early requirement though this could be incorporated into the design architecture.
The Spreadsheet currently contains 25 Data Fields (columns) and less than 500 records related to University Faculty contact information and its' purpose will be to both track and encourage academic progression by having a Mapping Process of:
1) Current Faculty Academic Teaching Credentials
2) Goals for Progression (Undergraduate and Postgraduate Teaching)
3) Academic offerings available (both internal and external to the Institution)
The latter (Point 3) will be inputted by a Faculty Development Coordinator who will solicit the Opinions (Point 2) of Faculty (Point 1). Please note that some of these fields may need a calculated value based on weighting of different answer options from a Survey being conducted (outlined below).
If there is a way to input Survey Data from Online Survey Tools such as SurveyMonkey or by parsing a standardized response form or Optical Mark recognition, etc., I would be interested in all these solutions since some people may be taking an online survey, some may be Faxing a printed copy/sending Snail Mail, while others may only disclose information in a hallway chat and need data input directly by a Database Administrator.
A separate section of the Database should have a Running Journal NoteField with TimeDate Stamps automatically entered to capture free form notes independent of the above entries which are specifically tied to individuals.
If you are aware of how to hyperlink to EverNote PDFs (I think it is supposed to be pretty simple but have not yet done it) as well as as local files on both a Mac & PC, that would be ideal. If this is also possible for iOS, my goal is to have a lightweight version of the App on an iPad using FileMaker Go that can query either a cloud-based FileMaker Server (offered by 3rd parties) or our own FileMaker Server (which we do not have at present).
I am not overly savvy with Database programming but can modify fields and layouts once the hard work of internal coding, design architecture, and debugging are done by a real programmer.
I am open to both an hourly quote and a fixed project cost ... I do have a budget but am interested in your proposals so that I can understand what kind of scope you would propose before thinking that ANYTHING in the programming world is as simple as people would like to think!! I will delimit the project based on the quotations / value for money / programmer reputation / on-time completed projects history
I am hoping to have this database completed and fully operational in under 2 weeks so hopefully, you will only quote if you are able to meet this deadline.