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

技能: HTML5, Javascript, MySQL, PHP

查看更多: 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: #12022209

18名威客为此工作的平均竞标价是$207

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 在10天内
(350条评论)
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 更多

$226 USD 在8天内
(421条评论)
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 更多

$210 USD 在3天内
(162条评论)
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 更多

$222 USD 在7天内
(234条评论)
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 更多

$188 USD 在6天内
(202条评论)
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 更多

$220 USD 在7天内
(152条评论)
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 在5天内
(239条评论)
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 更多

$222 USD 在5天内
(97条评论)
6.6
dungnguyen2607

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

$222 USD 在5天内
(94条评论)
6.5
$357 USD 在7天内
(76条评论)
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 更多

$155 USD 在7天内
(58条评论)
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 更多

$180 USD 在3天内
(54条评论)
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 更多

$155 USD 在3天内
(17条评论)
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 更多

$611 USD 在3天内
(11条评论)
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 更多

$200 USD 在4天内
(18条评论)
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. 更多

$222 USD 在3天内
(12条评论)
3.9
$61USD 在1天里
(1条评论)
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 更多

$277 USD 在3天内
(1条评论)
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 更多

$155 USD 在3天内
(1条评论)
0.4
$122 USD 在3天内
(0条评论)
0.0