SQL field calculator

Cancelado

Descripción

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

Habilidades: HTML5, Javascript, MySQL, PHP

Ver más: insert xml field sql, ext retrieve field sql jsp, date duration calculator minutes sql, aspnet upload file image field sql, insert xml file field sql, setting automated backups sql 2005 standard, insert table xml field sql server, delete field sql statement, delete field sql script, set automatic backup sql 2005 standard, php create field sql table, create field sql, database add field sql, move field sql server, add description field sql, add field sql, delete field sql

ID de proyecto: #12022209

20 los freelancers están ofertando un promedio de $204 para este trabajo.

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 en 10 días
(350 comentarios)
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 Más

$226 USD en 8 días
(421 comentarios)
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 Más

$210 USD en 3 días
(162 comentarios)
7.7
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 Más

$222 USD en 7 días
(234 comentarios)
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 Más

$188 USD en 6 días
(202 comentarios)
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 Más

$220 USD en 7 días
(152 comentarios)
7.1
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 en 5 días
(239 comentarios)
7.5
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 Más

$222 USD en 5 días
(97 comentarios)
6.6
dungnguyen2607

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

$222 USD en 5 días
(94 comentarios)
6.5
$357 USD en 7 días
(76 comentarios)
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 Más

$155 USD en 7 días
(58 comentarios)
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 Más

$180 USD en 3 días
(54 comentarios)
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 Más

$155 USD en 3 días
(17 comentarios)
4.7
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 Más

$611 USD en 3 días
(11 comentarios)
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 Más

$200 USD en 4 días
(18 comentarios)
4.2
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. Más

$222 USD en 3 días
(12 comentarios)
3.9
$61 USD en 1 día
(1 comentario)
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 Más

$277 USD en 3 días
(1 comentario)
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 Más

$155 USD en 3 días
(1 comentario)
0.4
$122 USD en 3 días
(0 comentarios)
0.0