Closed

mySQL Field Editor

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, PHP, SQL

See more: software write mq4, software write chip epson, useful software write book, software write web specs, create money field mysql, visual basic blob field mysql, free software write user guide, software write edid, free software write company profile, software write websites idea, ajax row editor php mysql, software write book images, search multiple field mysql, software write books, software write protection, mysql failed please contact sysadmin result mysql failed, free software write book, software write book, insert today date form field mysql php, update field mysql php, mysql quick books, mysql failed please contact sysadmin, php edit field mysql, tinsert field mysql php, overwrite field mysql php

Project ID: #12029680

7 freelancers are bidding on average $244 for this job

rajeshsonisl

Hello! With 98% to 99% completion rate, 900+ successfully completed projects, and a 4.99 reputation (maximum possible, 5.0) (can be verified on my profile page https://www.freelancer.com/u/rajeshsonisl.html !!)... y More

$684 USD in 5 days
(752 Reviews)
8.2
ranganathp

FREELANCER RECOMMENDED ------------------------------------------------------ Can help... I am an Expert... Lets Start! Please start a Discussion with me and we can get started from there... Please check the past p More

$100 USD in 10 days
(74 Reviews)
6.7
usatechsoft

HI My Notion : "No Satisfaction, No Payment" We have expertise in Web Design & Development. Please check our client reviews on Elance to determine the quality of our work.: Lets discuss in detail and start now? More

$155 USD in 3 days
(63 Reviews)
6.4
dghq123

Hi there.. I have read your project details completely and willing to do it for you... Check my recent reviews for our quality work on on time delivery :) Please inbox and we can discuss about project

$250 USD in 5 days
(38 Reviews)
6.1
$200 USD in 3 days
(6 Reviews)
5.5
Sonicoders

I have 6 years experience as web developer I can provide you the solution we can discuss more details over chat.

$166 USD in 3 days
(37 Reviews)
4.3
$150 USD in 5 days
(0 Reviews)
0.0
$177 USD in 2 days
(0 Reviews)
0.0
mohanBWS

We are 1000+ employees in our company. So we can do any kind of project based on all languages and all stream. We have 3 years+ experience employees for all stream especially C Programming, C++,C#, , Html,Html5,Wordpr More

$166 USD in 5 days
(0 Reviews)
0.0
$162 USD in 2 days
(0 Reviews)
0.0