0

ICA Online/Searchable Properties Database

Christopher Dills 10 years ago 0
I would like to create/develop an online database that is searchable via simple GUI with input text boxes that search corresponding columns of information for each item in the props inventory located in the basement of the Harvey Theatre building.

Desired Features:
-  Information populated, input, and edited online from any computer connected to the internet (Google Spreadsheet?)
-  The ability to have a picture of the item
-  Categories/Columns of information (i.e. color, time period, material, notes, condition, quantity, show name, size, location, shelf, row, aisle, item number/code)
-  A GUI that takes the above columns and has a simple to use user input text fields.  This actually could just be one search box where descriptive words can be entered and the search engine will find any and all instances of said word(s)
-  The ability to check in/out the items and how many of them were checked out and how many are remaining
-  Ability to mark who is checking them out, where they are going to, and when they are scheduled to be returned.
-  Ability to record contact information for the person/persons who are checking the items out with certain information (i.e. phone number) being required to continue with the process.

Time-Frame for Project:
I would like to develop this and hone a system of sorts during the first semester of the 2014-2015 school year and attempt to use it in conjunction with the new production request forms people are being asked to submit to Presentations to get items from storage in Harvey.