Dynamic Entry Form

Budget $30 - $250 USD
Bids 28
Average Bid $103

I need a dynamic entry form that will pull data from two SQL tables and modify the user's entry fields to 'clean' data.

TABLE 1: tableFirm
Fields: ( firmID, firmName, firmManager, firmPresident, firmSecretary, frimEarnings, firmEmployees, frimEmailaddress, firmWebsite...)

TABLE 2: tablePersons
Fields: ( personID, personFirstName, personLastNamee, personEmailaddress...)

DATA ENTRY SCREEN
The data entry screen will include text boxes for all the fields in table 1 and pull data from Table 2 as the user is entering data,
in addition to 'clean' versions of those fields.
The form will check to make sure the data entered is correct/valid

Example 1: - persons

when the user is entering the name of the firmManager (say "Robert Smith"), a list will pop up to select the correct Robert Smith
[ there could be a Robert Smith at two different companies, so the list would need to show the name and email addresss ]
the personID is what will be stored in the form, not the person's name

Exapmle 2: - earnings (dollar signs and commas stripped out)

when the user is entering the income, any non-numeric symbols should be stripped out ( so $7,000,000 is entered but 7000000 is stored)

Example 3: - firmEmailAddress or firmWebsite

when the user enters an email address that is not valid, a message pops up to alert him to correct (so John @ [url removed, login to view] or [url removed, login to view] would be invalid)

This needs to be done in classic .ASP but you can use plugins that I will be able to modify if needed.

I will give you access to a server that you can test it on. Once it is working, you will receive 50%. I will then move the files to a similar server and when that works, I will pay the remaining 50%

Once selected, I will give you the details on actual field names, etc.

I know this is a pretty simple project but if I find somebody that I work with well, there is more work.
If you have a sample webpage that does something like this that you can point me to so I can see
how well you did, that would be great.
Thank you very much.

Post a Project Like This

This project was awarded to

gkalish

G Tech Vision was very professional in their approach to work and how they presented themselves. They where able to meet their deadlines and worked with us on testing and bug fixes even while our customer was delaying our progress. G Tech Vision will be the first group we contact when we have additional work for them. Regards, BroughtonbyDesign
About the Freelancer
gkalish Profile Picture

* NET (VB & C#) * Classic ASP * PHP * LINQ * MVC * WEB API * VB.NET * Web hosting * Windows Service * Rest Service * Entity Framework * SQL SERVER * MYSQL * Access Database

Looking to make some money?

  • Set your budget and the time frame
  • Outline your proposal
  • Get paid for your work

Bids on this Project

  • faizanaskari Profile Picture

    faizanaskari

    Karachi,  Pakistan

    I ensure that our client will be 100% satisfied, through our quality work, good service and meeting deadlines. I hope we will have great relationship through Freelancer. Best Regards, Faizan Askari

    ASP, Javascript, Adobe Flash, and Website Design

  • coderPros Profile Picture

    coderPros

    Cluj,  Romania

    Personally, I'm a native-born American entrepreneur with over a decade of experience in developing technology based ventures. I'm not just merely a facilitator though, I can get right in there and sling code with the best of them. I've been consulting with a focus on Microsoft and Adobe based enterprise technologies since 1997. I've been a nomadic freelancer, since long before freelancing was cool. To say I'm a self starter would be putting it mildly. Presently, I'm living and growing my business in Europe and return to the United States once a quarter. We have developed web and software applications for some of the biggest organizations throughout the world. Over the years we've become known as turn around consultants, turning a projects that have gone awry into successful completed ones. Tired of poor communication and missed deadlines? Give us a call today! The following are a few of my personal favorite projects: * Produced a very modular web based "lead" and event management system for churches around the globe. * Wrote a web application for a vacation property management company that succeeded in netting over $1M for 4 years straight. * Developed a cutting edge web/software/mobile application for a medium sized transportation company that manages *every* aspect of inbound and outbound shipments from purchase order to delivery confirmation. * Developed a Java application for a health care organization that manages the distribution of medicine to end of life patients around the country. This Java app shaved precious DAYS off of the delivery process and resulted in saved lives. * We presently consult on retainer for one of the oldest and largest paid submission search engines on the planet. This particular company using truly bleeding edge Microsoft technologies. Some of our clients have included: The United States Department of Defense, South Carolina Department of Transportation, Verizon, eBay, IBM, BASF, bestoftheweb.com, State Farm Insurance, National Fidelity, UPS, and a plethora of other small and medium sized businesses. Our core technical competencies are: AJAX, ASP.Net, ASP, C#, ColdFusion, DotNetNuke, HTML 4/5, Javascript, jQuery, MySql, SQL Server, and VB.Net. In 2009 we also expanded into the Administrative Support, Data Processing, and Translation (human and machine) fields.

    ASP, Javascript, XML, and Cold Fusion

  • Revencu1970 Profile Picture

    Revencu1970

    Chisinau,  Moldova, Republic of

    I have been for 17 years in the computer field. I have been programming and developing for 15 years using Foxpro (SQL) and 6 years ASP Classic programming language. I am experienced in every phase of the development cycle. I have developed inventory, survey, financial, direct mailing, billing, client-server, user defined reporting systems, and some web development. I have written specifications for most of my projects and created user and technical manuals for each one. I have provided customer support and training for all projects and performed maintenance and normalization of databases for each project. I can also adjust myself in any programming platform.

    ASP, Javascript, Data Processing, and Data Entry

  • bryanmcvw Profile Picture

    bryanmcvw

    Arlington,  United States

    ## BIO Database analyst/developer for 2 years with a long term care insurance department. Developed databases and systematic processes for the Project Management team over Accounting. Created several databases to track internal projects, created company mailers by processing data, created import/export processes and automated tasks. Used VBA in all MS office applications including MS Access. I also work with small business to create attractive, user friendly, and affordable websites. Using HTML, CSS, PHP and MySQL. Getting it right, without cutting corners...even when others aren't looking. Database developer for medical practice for 11 years. SQL programmer and web developer for small business for 2 years. ## Area of Expertise HTML, CSS, VBA, PHP, MySQL, Microsoft Access, Visual Basic, Word and Excel Form Creation, Data Entry Streamlining, MS SQL, ASP.NET

    Perl, ASP, C Programming, and Javascript

  • feminsaneesh Profile Picture

    feminsaneesh

    Mumbai,  India

    I am a Software Engineer having good programming skill. I have 1 year experience in vb.net & ms-sql. Presently working as Software developer.

    AJAX, C# Programming, Microsoft SQL Server, and VB.NET

  • sanjeevchopra12 Profile Picture

    sanjeevchopra12

    Delhi,  India

    To carve out a niche by 3D's namely Dedication, Devotion and Determination, which would add value to the project and help in attainment of its goals & objectives and provide me a broader canvass to paint on. WCF, ASP.NET, C#.NET, JavaScript, JQuery, XML, HTML, Classic ASP, C, JAVA, FOXPRO, SQL SERVER 2008/2 Bug Fix Expert, Website Development, Software Installations & Scripts Updations

    PHP, ASP, Javascript, and XML

  • gkalish Profile Picture

    gkalish

    Madurai,  India

    * NET (VB & C#) * Classic ASP * PHP * LINQ * MVC * WEB API * VB.NET * Web hosting * Windows Service * Rest Service * Entity Framework * SQL SERVER * MYSQL * Access Database

    Javascript, Visual Basic, .NET, and Data Entry

  • SolntsevDenis Profile Picture

    SolntsevDenis

    Moscow,  Russian Federation

    Classic ASP, experience more than 14 years

    ASP, .NET, iPhone, and Android

  • AnhTriet Profile Picture

    AnhTriet

    Hue,  Vietnam

    Welcome to my page! I'm a web developer and web designer. To let you know more about me, I'll tell you about my skills. - Programming language: + C# + Java + C/C++ + Pascal - Mobile programming: + Android - Server side: + ASP.NET-MVC + Web Form + SignalR - Client side: + JavaScript + jQuery + AngularJS + Bootstrap - Web design: + Photoshop I hope we can work together. Thanks for visiting my page!

    ASP, Java, JSP, and Javascript

  • sinharavi Profile Picture

    sinharavi

    Bangalore,  India

    ## BIO RAVIRANJAN KUMAR SINHA (Sun Certified Java Programmer)  [Removed by Freelancer.com Admin for posting of Contact information] Objective To secure a challenging assignment in a dynamic environment that would require my aptitude and technical skills and give ample opportunity for my all around growth in the software industry. Work Experience Total 2.9 Years Of Experience in IT Industry. ? 2.9 Years of Experience working on VB.NET, ASP.NET, Oracle9i/10g, SQL Server 2005/2000 . Professional Summary 1.) Softrade Infoware Private Limited, Bangalore From July 2007 to till date. 2.) Laavanya Technology, Bangalore from January 2007 to June 2007. Technical Summary ? Very Good Knowledge of Programming in VB.NET, C# .NET. ? Very Good Knowledge of Programming in ASP.NET. ? Good knowledge of Web Services. ? Very Good Knowledge of writing Sequel Query in Oracle . ? Very Good Knowledge of writing stored procedure in Oracle. ? Very Good Knowledge of writing Sequel Query in Microsoft SQL Server 2005. ? Very Good Knowledge of Java Technology. ? Good Knowledge of VB6. ? Proven ability to work as a Team. ? Design, Development, and Coding. ? Debugging and troubleshooting the application. Technical Skill Languages : VB.NET, ASP.NET, Java, J2EE(JSP,Servlet) Database : Oracle9i/10g, SQL Server 200/2005 Web Development : ASP.NET, ADO .NET, J2EE(JSP,Servlet) Database Tools : TOAD, Oracle SQL Developer Reporting Tool : Crystal Report 11 OS : Windows 2000/XP Excellence SCJP Certified (Sun Certified Java Programmer) Academic Credentials BE (Computer Science & Engineering) in 2005 Bhagalpur College Of Engineering 69% TMB University Bhagalpur, Bihar 12th Sardar Patel Memorial College 52% Bihar Sharif, Nalanda, Bihar 10th HSDS Nalanda, Bihar 60% Project #1 Project Title FinOPS Language/Tools Used VB.NET 2008, SQL Server 2005, Dx Report, Infragistics 8.3 Team Size 4 Duration April 2009 to till Date Role Developer Project Objective This project is customized to meet SKS (A Finance Company) needs. The application is customized to provide solution for Finance management system. The purpose of FinOPS is basically to keep track of Clients, Loans taken by clients, repayment of loans, including Assignment, Stamping, Head Office Entry. FinOPS is developed to give updates of Loan taken by the clients, Repayments of Installment, Late payment , Head Office entry. In this project loan can also be sold to other banks. Also functionalities are calculating IRR(Internal Rate Of Return), Head Office entry, Stamping Transaction, Assignments and others. For the reporting purpose many reports are developed in different entities Loan Disbursement Summary, Loan Disbursement Detail, Product wise Loan Outstanding, Month wise Ageing Outstanding, Portfolio Rundown, Loan Written Details and others. Based On user rights many roles are defined. Responsibilities • Developing various functionality using VB.NET • Developed many stored procedure in SQL Server 2005. • Created Index and Partitions for making fast execution • Responsible for designing Report. Project #2 Project Title dbPays4 Client Deutsche Bank Language/Tools Used VB.NET 2005, Oracle 10g, Crystal Report, TOAD, Oracle SQL Developer Team Size 3 Duration July 2008 to April 2009. Role Developer Project Objective dbPays4 is used to monitor and maintain payment system for DEUTSCHE Bank. The major modules are Master Upload, Customer Instruction, Process, payments(WBR) ,Payments(ABR), Charges, Accountings, Cheque Atpar . In this project we are using DJ Convertor to convert different format of Cheques. Module which I have done is Master Upload, Payments, Customer Instruction, Accounting and charges. In this system two types of charges is there Customer charging and partner bank charging. Payments within Bank Reference means payment generation for a client given by single customer and Payments Across bank reference means payment generation for a client given by more than one customer. Responsibilities • Developing various functionality using VB.NET. • Developed various stored procedure to implement functionality of process program. • Responsible for Designing Report. Project #3 Project Title ChitSmart Language/Tools Used VB.NET 2008, SQL Server 2005, Dx Report, Infragistics 8.3 Team Size 4 Duration March 2008 to July 2008 Role Developer Project Objective This is a product based product of this company. This is based on chit fund system. In this foreman (Generally Owner) is responsible for the system. The main functionality of this project is giving money to many persons as borrow and they will payback in small installment Daily/Weekly/Fortnightly/ Monthly with very less interest. This is same like a person taking loan from bank but the difference is that in this system they can get money easily without providing any proof and they will pay in installment with very less interest. Because in this system the extra amount earned is dividing to each person. Responsibilities • Developing various functionality using VB.NET • Responsible for designing Report. • Developed many Stored procedure in SQL Server 2005. #Project 4 Project Title Cash Track Client Deutsche Bank Language Used ASP.NET 2003, SQL Server 2000 Team Size 3 Duration December 2007 to March 2008 Role Developer Project Objective Cash Track is used to Monitor and Maintains cash funding system for DEUTSCHE Bank. In this system there are three types of users Customer, DB user and Service provider. Process flow of this system is first customer send request to DESTSCHE Bank with request number then DB User upload customer file to the server, after that service provider user download current date request and he will open downloaded file and he will collect the cash at mention pickup location. Then service provider will do deposit entries. In this system we are using cut off time. If customer adding request after cut off time warning message will popup. This cut off time is defined at the system level by administrator in admin mode. Responsibilities • Implementing functionality using ASP.NET. • Responsible for Form Designing. Project #5 Project Title IMS NET Client Bharat Industrial Corporation(BIC) Language Used VB.NET 2005, SQL Server 2000,Crystal Report Team Size 3 Duration October 2007 to November 2007 Role Developer Project Description This Project Maintains the Ac ## Area of Expertise I have experience in VB.NET, C# .NET, Java , J2EE, JSP, Servlet, JSF, Oracle, Microsoft SQL Server, My SQL, Microsoft Access, Java Script, CSS, Web Services, XML, WCF, JQUery

    .NET, Electronics, Mobile Phone, and Research