SQL field calculator
This project received 21 bids from talented freelancers with an average bid price of $223 USD.Get free quotes for a project like this
Project Budget$30 - $250 USD
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. 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.
- 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
Looking to make some money?
- Set your budget and the timeframe
- Outline your proposal
- Get paid for your work
Hire Freelancers who also bid on this project
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online