Simple database application

In Progress

Description

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].

Components:

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.

Technologies:

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

Skills: BPO, Copy Typing, Data Entry, Web Scraping, Web Search

See more: what is database technology, what is an apps script, what is an android tablet, what is a data entry form in a database, web scraping solution, web scraping apps, web scraping application, web contractors, update android tablet, time track application, system update android, sign in desk, picture apps for android, paper for android, open office for android, office for android tablet, in n out application, google docs android, google apps web page, google apps spreadsheets, google android tablet, data scraping technology, data entry tablet, database technologies, borrow me

Project ID: #4383243

Awarded to:

Mobitel

I can do it

$2 USD / hour
(1 Review)
0.0

21 freelancers are bidding on average $7/hour for this job

RSwapnil

Ready to start

$10 USD / hour
(72 Reviews)
5.7
shihan033010

Hi please check my proposal.

$12 USD / hour
(6 Reviews)
3.5
mango953

Hi. I offer you a database for your office PC/ laptop or iProduct, not Android since I use FileMaker Pro as the db application. Its advantage is that you can upgrade it at anytime, it is easy to use by any user and it More

$8 USD / hour
(3 Reviews)
2.9
kalpesh2804

Hello, Please check PMB

$15 USD / hour
(3 Reviews)
1.8
synergydeveloper

Please provide me the opportunity

$7 USD / hour
(1 Review)
1.0
AdduceTrack

hii i am interested in this job

$5 USD / hour
(1 Review)
0.1
robertolacosta

Hi Aircel, I can do and complete your project in a month or two only. Afterwards, I can provide with step by step tutorial on how to operate, manage and modify the system. I can render 60 hours or more in a week for More

$5 USD / hour
(2 Reviews)
0.0
Erinkr1983

I would be glad to work on your project. I am a USA college graduate with an Associates degree in Accounting. My good language, selling and typing skills added to accuracy will provide an advantage to the project. Time More

$5 USD / hour
(0 Reviews)
0.0
bharatimd123

Hi, I am ready to work on this project. Thank you.

$5 USD / hour
(0 Reviews)
0.0
shhad555

I ready to your project

$5 USD / hour
(0 Reviews)
0.0
Shimauli

Respected Sir/Madam, I understand your requirements. I have worked on android application having database connectivity. I assure you a quality work. Thank You

$2 USD / hour
(0 Reviews)
0.0
sambafreelance

I m interested your contract

$5 USD / hour
(0 Reviews)
0.0
abhisheksoni

Hi, can do this project for you, Thanks Abhishek Soni

$2 USD / hour
(0 Reviews)
0.0
ewiewiora

I have a working demo already done.

$8 USD / hour
(0 Reviews)
0.0
pragadeesh678

approaching in different and new way

$5 USD / hour
(0 Reviews)
0.0
jbufu

I am ready for the project

$11 USD / hour
(0 Reviews)
0.0
muhammadbaloch

I am interested in doing this.

$5 USD / hour
(0 Reviews)
0.0
ahmedbabu

I need this job

$4 USD / hour
(0 Reviews)
0.0
abidaziz2004

Qualifications: 2003-2007 B.SC .in English Literature, Faculty of Art from Jarash University ICDL ( Word - Excel - Access - PowerPoint) Data Entry

$5 USD / hour
(0 Reviews)
0.0
yanlpy

i believe i can do it with the technique you mentioned about (e.g. google doc and excel spreed sheet)

$7 USD / hour
(0 Reviews)
0.0