Simple database application with 1 form, and 1 report

Broad Overview:

We are a real estate and property management firm, and we have a few hundred keys in our office. Each key is assigned a number. People like other real estate agents or contractors come to borrow the keys, and we currently use a paper sign out sheet to keep track of which keys in and out. We want to replace this system with something digital. It will run on an android tablet, which will be mounted on our reception desk [see picture].


Check Out/In Form: each time a key is taken out or returned, the person will fill out a form [see mockup]

Admin view: we want a summary that lists every key currently out of the office, along with the name and phone number of the person who has it. [see mockup]

Highlighting: Keys checked out over 24 hours ago should be highlighted in yellow, and over 48 hours in red.

Updating: the admin view needs to automatically update every time the page is reloaded.

Archive: we need some method to save the data for a long period of time, without clogging up or slowing down the system.


Needs to run easily on an android tablet. I am thinking a Google docs form, or some other web-based solution but I am open to any suggestions. I have already tried to do this myself with google spreadsheets, and it will require some pivot tables and Google Apps Script that are a bit too complicated for me. But it is probably quick and easy for someone with that knowledge...

Please provide:

- Suggestions about what technology to use

- Estimate of time to complete

- Cost estimate


To Clarify:
- Let's do this "quick and dirty" by using an existing technology, not custom development
- I don't want to pay for hosting, or setup my own server. It is better to use someone else's server for free

Based on these two factors, I think a form linked to a google spreadhseet is best, but I am open to others suggestions that meet the criteria above.

- This should be easy, just apply some script magic to the spreadsheet of form responses (right?)

Skills: Data Processing, Excel

See more: simple database application, simple data application, what is database technology, what is an apps script, what is an android tablet, update android tablet, time track application, system update android, sign in desk, reception administration, picture apps for android, paper for android, open office for android, office for android tablet, google docs android, google apps web page, google apps spreadsheets, google android tablet, database technologies, borrow me, apps script google, apps for android tablet, android system update, administration reception, what is google docs

About the Employer:
( 6 reviews ) United States

Project ID: #4382159

13 freelancers are bidding on average $237 for this job


i can do it

$80 USD in 14 days
(3 Reviews)

I am ready and expert in Website Development in PHP and MySQL.

$230 USD in 8 days
(1 Review)

Hello There!Please check PM.Thanks.

$250 USD in 5 days
(2 Reviews)

We are team of skilled web and Smartphone application developers. We at MXICODERS PRIVATE LIMITED have 10+years of experience in managing projects We would like you to start chat right now for further discussion War More

$140 USD in 3 days
(1 Review)

Hello! I have a lot experience about HTML5, so I think it is the best way to get a full compatible system with Android or PC, with a good speed and reliability as well. I can do that in 2 days Best regards, Johnny

$80 USD in 2 days
(1 Review)

I am interested in your project. Please check PMB

$550 USD in 10 days
(0 Reviews)

Hi, I believe I can create the form and the spreadsheet as you requested.

$140 USD in 3 days
(0 Reviews)

Dear Sir Hi, Greetings of the day and thanks for sharing these details and allowing me to bid on this assignment. we already have similar work experience and have worked on similar projects in the past and can More

$235 USD in 12 days
(0 Reviews)

I have read, understood and I'm ready to complete your [url removed, login to view] check PM for more information.

$100 USD in 3 days
(0 Reviews)

IT Engineer with 13 years of experience (2000 - 2013), I have enough skills to complete this project. I prefer to do it with php and javascript so that it will be independent of the platform. I can do it in less that a More

$450 USD in 7 days
(0 Reviews)

*Updated*: Using google forms only. Native English speaker with extensive technical experience. Degree in Comp Sci and have worked in the industry on lots of php/sql projects. I can get this done in a day or so max.

$90 USD in 1 day
(0 Reviews)

Please check pmb for details.

$300 USD in 10 days
(0 Reviews)

Hi, I have a "quick and dirty" solution to your problem. Please check message board for details. Cheers, Hari

$143 USD in 2 days
(0 Reviews)

Hi - I know exactly what you want. We use Google forms and Google spreadsheets to do this kind of thing all the time. I can set the whole thing up for you in less than an hour, and it will all be on Google Drive so you More

$150 USD in 0 days
(0 Reviews)

Sri Technocrat is marvelous in its quality. We have been maintaining the quality in every field whether it is services or training. We have proved our stability. We have been working with the same grace & quality. Our More

$350 USD in 18 days
(0 Reviews)

Dear Sir, I checked your mock ups and we are good to go with the project immediately. I will be crafting this using PHP/MySQL as a web application allowing it to run on anything (thus, you will need to host it on some More

$199 USD in 3 days
(0 Reviews)