Ακυρώθηκε

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, 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

Σχετικά με τον Εργοδότη:
( 8 αξιολογήσεις ) Sydney, Australia

ID Εργασίας: #12022209

18 freelancers κάνουν προσφορές με μέσο όρο $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
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
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
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
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
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
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
$61 USD σε 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