mySQL Field Editor

Closed

Description

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