Kansellert

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

Ferdigheter: HTML5, Javascript, MySQL, PHP

Se mer: 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

Om arbeidsgiveren:
( 8 omtaler ) Sydney, Australia

Prosjekt-ID: #12022209

18 frilansere byr i snitt $207 for denne jobben

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 på 10 dager
(350 omtaler)
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 Mer

$226 USD på 8 dager
(421 omtaler)
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 Mer

$210 USD på 3 dager
(162 omtaler)
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 på 5 dager
(239 omtaler)
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 Mer

$222 USD på 7 dager
(234 omtaler)
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 Mer

$188 USD på 6 dager
(202 omtaler)
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 Mer

$220 USD på 7 dager
(152 omtaler)
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 Mer

$222 USD på 5 dager
(97 omtaler)
6.6
dungnguyen2607

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

$222 USD på 5 dager
(94 omtaler)
6.5
$357 USD på 7 dager
(76 omtaler)
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 Mer

$155 USD på 7 dager
(58 omtaler)
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 Mer

$180 USD på 3 dager
(54 omtaler)
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 Mer

$155 USD på 3 dager
(17 omtaler)
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 Mer

$200 USD på 4 dager
(18 omtaler)
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 Mer

$611 USD på 3 dager
(11 omtaler)
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. Mer

$222 USD på 3 dager
(12 omtaler)
3.9
$61 USD på 1 dag
(1 omtale)
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 Mer

$277 USD på 3 dager
(1 omtale)
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 Mer

$155 USD på 3 dager
(1 omtale)
0.4
$122 USD på 3 dager
(0 omtaler)
0.0