Cancelled

SQL field calculator

Please carefully review the attached mock-up of the UI.

Two main functions:

1. The user selects an existing field and is then able to recode that field into a new field.

Eg. 1=2, 2=3, >2=4, <-1=5, Else 6

2. The user selects one or more fields and creates a mathematical expression that computes a new field. Possible mathematical functions include add, subtract, divide, multiply, minimum, maximum, mean, frequency, mode, variance, standard deviation, range, absolute value & log10.

Eg. V1+V2/2

Eg. mean(V1,V2) + ABS(mode(V1,V2))/2

These recoding and calculations would be saved and scheduled to run regularly on the old source field to insert new data in the target field.

Features:

- Each rule should be run at scheduled intervals

- Each saved rule should be capable of being opened and edited

- A basic GUI to connect to multiple SQL databases

- Can add new tables & save newly generated fields to these new tables.

- The user can select which table to insert the new field into

- Lists recent fields used for quick selection

- Autocomplete & suggest variable names in search boxes

- Clicking a field name in the search box inserts the field name into the recode or calculation.

- A preview window to see the active table, with the ability to search in any field

Skills: HTML5, Javascript, MySQL, PHP

See more: insert xml field sql, delete field sql statement, delete field sql script, create field sql, database add field sql, move field sql server, add description field sql, add field sql, delete field sql

About the Employer:
( 8 reviews ) Sydney, Australia

Project ID: #12022209

18 freelancers are bidding on average $207 for this job

mituld

Hi I work towards providing reliable, relevant and robust IT solutions at most competitive prices to my customers. I ensure 100% customer satisfaction so lets start Thanks

$237 USD in 10 days
(350 Reviews)
8.1
gopalvora

Hi I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joo More

$226 USD in 8 days
(421 Reviews)
8.1
TenStar718

Hello, and thanks for the opportunity to bid on your project. https://www.freelancer.com/u/TenStar718.html I am an expert in many different area’s of web and mobile applications based on the following languages: W More

$210 USD in 3 days
(162 Reviews)
7.7
Risalat1

Ready to start work with you, would like to discuss it further, let me know if you are free to discuss it thanks

$288 USD in 5 days
(239 Reviews)
7.5
scriptphp87

Hello, I'm a professional programmer for web programming with php language to build the system website, Besides, I'm also expert in MySQL , HTML,HTML5,CSS, JS I'm always top in Vietnam freelancer https://www.freela More

$222 USD in 7 days
(234 Reviews)
7.9
mascotindia123

Hey Friend, We are having 8 + years experience of web site development and Software development. And we have team of 8 experienced developer and 4 graphic designer. Expert in Custom programming in Graphic desi More

$188 USD in 6 days
(202 Reviews)
7.1
sunsoftpro

First, I am sunsoftpro, I from VietNam. Nice to meet you! I have read your description and been interested in your project. I'm ready to discuss and do hard working so that complete great job. Please discuss requi More

$220 USD in 7 days
(152 Reviews)
7.1
faisdesign

Hello, I have read all the requirements of this project and my team can provide high quality professional results at a low cost. Our team consists of 4 programmers/designers with over 6 years experience and a v More

$222 USD in 5 days
(97 Reviews)
6.6
dungnguyen2607

Hello. I'm ready to start your project now. Thank you very much .

$222 USD in 5 days
(94 Reviews)
6.5
$357 USD in 7 days
(76 Reviews)
6.1
Websitemaestro

Hi, Thanks for the opportunity. As per your requirement, i would like to tell you that I have a very strong experience of more than 5 years in this field of design and development. Please spare a moment to dis More

$155 USD in 7 days
(58 Reviews)
5.7
suniljoshi151

Hi, I can start work on your project immediately once you confirm me and i am also open for further discussion if you want. I have 7+ years in web designing & development with good experience in following sk More

$180 USD in 3 days
(54 Reviews)
5.9
rainstreamweb

Hello, This is not copy/paste message. I read your requirements. I am interested for this job. I have expertise in Wordpress, Laravel, Magento, AngularJS, Ruby on Rails, Core PHP etc. technologies and can work on More

$155 USD in 3 days
(17 Reviews)
4.7
dishantkhoyani

Hello Sir/Mam, i have developed one site for my USA client for book searching based on custom calculation search and also developed the online ordering system for brightbars (pipes) of different diameter so i can do More

$200 USD in 4 days
(18 Reviews)
4.2
alliedsoftwares

BEFORE YU AWARD ME PROJECTS, PLEASE DICUSS IN DETAILS !! Dear Sir, You recently advertised your job posting on this website, we have worked on more than 200 computer softwares, websites / web portals with requir More

$611 USD in 3 days
(11 Reviews)
4.7
deepakmishra1988

Hi, I can do the following : Please carefully review the attached mock-up of the UI. Two main functions: 1. The user selects an existing field and is then able to recode that field into a new field. Eg. More

$222 USD in 3 days
(12 Reviews)
3.9
$61 USD in 1 day
(1 Review)
1.6
denissantos88

Dear employer, i have long time experience working with desktop, mobile and web platforms. I can develop your mathematical expression tool, and i have some questions: Do you want that to be a web tool? Do you have a More

$277 USD in 3 days
(1 Review)
0.7
naimuddin200015

Hello I am a professional programmer on PHP+MySQL+WordPress. Over the last 5 years, I have experience in web development programing. I have excellent experience in the following area - Designing, building and mainta More

$155 USD in 3 days
(1 Review)
0.4
$122 USD in 3 days
(0 Reviews)
0.0