Completed

Create online searchable database from existing form

We are looking for a company or person to help us with a long term project.

We currently have a system where our security guards complete an online form that provides information using formsite.com. Once a week we export the data to a csv file and import it into a Filemaker file.  The filemaker file has two layouts that we then tabulate and use to produce weekly reports. The weekly reports are converted to pdf and distributed via email. 

Each week this is done manually.

1. Guard Enters Date

2. Once a week data exported as csv file

3. CSV file imports into Filemaker

4. Filemaker sorts data and creates desired layouts, then prints to pdf

5. Staff emails Pdf's to appropriate people

The guards enter the information at http://www.602Reports.com. I've attached 2 PDF files of the reports we currently produce each week.

One report is a summary. The other is a full listing of each record

****************************************************************

We want to create the following:

An online database that allows us to do everything we currently do, only not have to printout and email reports. We want the data to be available to the guards from the iPads:

We need to control who has access to the database and approve access for each [login to view URL] need to be able to set privileges for each person. We need to control who sees and enters the data. Some people may be able to see some data, that others can't.

The ability to have access to the data in multiple views and parameters as shown on the provided pdf's, from a smart phone, ipad or laptop.

We need an easy to use graphic interface for the guards with clear screens for data entry and search. As well as the ability to import and export data in any of the tables fields, from the back end.

We would like to move from emailing and printing weekly reports to a system that does it automatically when told to do so.

Our vision is - The guard enters the info on a phone or iPad, AND can have access to the data right away.  For example, the guard meets someone who says their name is John Smith, It would be nice for the guard to be able to enter the name and see if we have a picture for John Smith.

We also will need an interface from desktops as some people who will be viewing the data will not be in the field.

This will be an ongoing development project. We will start with just the fields and data listed on the current form at [login to view URL] (pluss the tracking).  Over time we will refine and improve the database and the information it contains.

All information must be hosted on a secure server with redundant backups. We want a weekly backup posted to our server. Whatever we build must be scaleable.

We prefer USA Based providers only because of the communication issues.

We will accept bids from others but:#1. Your English must be impeccable#2. You must be available via phone or text between the hours of 8am and 6pm California time.#3. We want to be able to see real-time working samples of previous DB project.

Again, this will be ongoing. Some months many hours, other months not many.  Flexibility with the ability to meet deadlines is important to us.  Feel free to reach out with questions.

Skills: FileMaker, PHP, Database Programming, MySQL, Software Architecture

See more: create online registration form database php, create online forms database, create online inventory database, create small searchable database, create online portal database, create online quiz database, create online quiz database design, create online document database website, create online serial database, create online quoting database, create online reservation database mysql, create online movie database, create installer sql database windows form, create online form database integration, create online product database, spreadsheet online searchable database, create dvd searchable database, html php create mysql relational database retrieve form, create online bookstore database, create online petition within existing website

About the Employer:
( 0 reviews ) Roseville, United States

Project ID: #24047177

Awarded to:

asifchaudhry2015

Hi there, I am a Senior Web Developer. I am really interested to work for you on this project ongoing basis and will be available for daily discussion between the hours of 8am and 6pm California time. I can also show y More

$25 USD / hour
(140 Reviews)
7.4

18 freelancers are bidding on average $22/hour for this job

leadconcept

Hi there, I have read everything carefully and interested to discuss further. I understand that you prefer US developer but I can assure you that communication won't be an issues, because we catch first half of US work More

$25 USD / hour
(102 Reviews)
9.1
coolguyinus2004

First thing forget about this project can be accessed via desktop it cant. 2nd thing you can access it via online domain with PHP/MYSQL supported with SSL enabled so it will be secured. I can block access to public and More

$25 USD / hour
(352 Reviews)
7.7
tangramua

Dear Sir,   Our team has a huge experience in PHP, Software Architecture, MySQL, FileMaker, Database Programming, as a result, we can successfully complete this project. Having the required skills, we will be glad to h More

$24 USD / hour
(54 Reviews)
7.0
developer2581

Hi, Me and my team have read the information you have provided and we will be more than happy to work with you and ensure the quality of work and results you expect to receive. You won't regret your decision of cho More

$20 USD / hour
(45 Reviews)
6.8
ARKSolution2015

Sir, I have gone through your project description and am looking to provide my service for creating online database for guards to look in the [login to view URL] leave a message on my chat so we can discuss the budget and dead More

$20 USD / hour
(180 Reviews)
6.8
bonech

Hello, I’m full stack professional Filemaker developer using the last technologies. You’re looking for a Filemaker developer for your project and this is exactly what I specialize in since decades. Talk about a perfe More

$25 USD / hour
(25 Reviews)
6.5
traveller90

7 years experience in Filemaker. Below are the area that I cover: - Webdirect - Runtime - API - ExecuteSQL - Java charts - HTML, CSS and Java in webviewer - System architecture - Reports - Plugins: Base Elements, MBS More

$20 USD / hour
(5 Reviews)
4.7
Dragan2019

Dear sir. I am a professional PHP developer with over 5 years of intensive experience in web development. You can find my substantial experience below: -Excellent knowledge of ( Laravel MVC frameworks, CodeIgniter, , More

$25 USD / hour
(4 Reviews)
4.1
Syed23365

hello sir i am a professional software engineer and i have years of experience developing database in mysql and in mongo db and I can complete the work before the time limit and minimum of your budget

$15 USD / hour
(7 Reviews)
3.7
Raf3Ddev

Hi,Dear. Here is Here is classy web expert with 6 years of much experiences. Your description is very clear and structured professionally, so that I'm already ready for you. I'm absolutely confident Please trust me and More

$20 USD / hour
(2 Reviews)
2.8
aleksandargrabe3

Dear client. I can build online searchable db on your hosting with mySQl. I am a full-time russian developer. I focus on relief in work. Please contact me if you are interested in me. Regards.

$20 USD / hour
(2 Reviews)
1.5
CanvasInfotech10

Hello, I hope you are doing well. I see that you are looking for a Web expert(PHP with all frameworks knowledge, WordPress, etc) and Full-Stack developer to work on your project for the long term. My team already wo More

$22 USD / hour
(1 Review)
1.6
vw1342868vw

Hi, Greetings, Expert in Web site development and desiging. New Site, Existing site, New work in Existing site, Complete development with authority. We are 100% capable to accomplish your task. in few hours we wil More

$15 USD / hour
(1 Review)
0.9
mmdparvej

Hey there! Hope all is well. I came across a very exciting project that you posted here in freelancer site and I believe fits me perfectly. I am interested in applying the project. After reading the job description a More

$20 USD / hour
(1 Review)
0.6
boomyjee

Hi. I am a senior PHP (Laravel, Symfony) developer with 10 years of total experience. I can act as software architect and tech lead also. The technologies I use every day include PHP, MySQL, HTML5, CSS3, JavaScript, jQ More

$25 USD / hour
(0 Reviews)
0.0
suryadeep1995

We are a group of 4 people, each one having a good amount of expertise in database, angular.js, Java and business intelligence. As per your requirement we will automate your process and will provide you with daily, we More

$20 USD / hour
(0 Reviews)
0.0
$22 USD / hour
(0 Reviews)
0.0