Smart Data Collection


The project is to develop a php/html/jquery data collection script that will be used to populate and update a Microsoft SQL Server Express database. The form will have one dynamic dropdown field (which populates automatically from the database) and about 4 static drop down fields. There are also some fields on the form that would need to be automatically filled when an item is selected from the dropdownlist while the rest of the fields will be entered by the user based on data collected from the field; In a situation where the required item does not exist in the dropdownlist, the script should provide blank fields for the user to enter all the information manually.

The created form will be pushed onto a smart trimble GPS that uses a software called field Inspector. The users will use the smart GPS to collect the field data and then upload the information to the database via a web access when they are not in the office or via the usb connection when they are in the office.

So far I have created the database and the various tables required for storing the data. I have also installed and configured the smart GPS to communicate with the SQL server database. I have also created an html form with the dropdown fields (Screenshots attached with the script error at the bottom) but I have not been able to get my dynamic dropdown listing to populate from the SQL server database and so not yet able to get the fields that needs to be automatically filled when an item is selected from the dropdown list to do so. This is how far i have gotten with this project.

I will appreciate to hear from anyone who is very proficient with PHP,JQuery and SQL Server database. (Please note that SQL Server is different from MySQL). I am also attaching my script here to serve as a basis if needed.

Skills: jQuery / Prototype, PHP, Software Architecture, SQL

See more: proficient with microsoft office, proficient with microsoft, i am proficient in microsoft office, web smart, proficient in microsoft office, how to get gps, Database collection, data collection:, data collection software, data collection needed, access script error, smart project database, smart database, php form dropdown list, listing onto, rest sql server, collection exist, jquery dynamic fields, jquery sql form, php html data, html form data, script enter data web form, blank fields, html form dropdown, mysql connection error

Project ID: #3975130

5 freelancers are bidding on average $196 for this job


I am web developer. I work with PHP & ASP.Net, MySQL & MS SQL Server. For more info about my past work please check my online portfolio at

$180 USD in 4 days
(22 Reviews)

Please check your inbox.

$250 USD in 5 days
(16 Reviews)

Hello, I can help.

$100 USD in 2 days
(3 Reviews)

I'm working in IT applications, software development and software theme implementation from last 5 years. We can provide you best solution in shortest possible time. Please check your PMB for more information.

$200 USD in 3 days
(1 Review)

Hi, I interested to work on this project. I worked on large database social network site where deals with all dynamic data in front end in normal html and some 3rd party tools jquery etc...

$165 USD in 6 days
(0 Reviews)

Custom software development: w w w . The Administrator removed this message for containing contact details which breaches our Terms of Service . i o

$250 USD in 1 day
(0 Reviews)