Dynamic Entry Form

Avg Bid (USD)
Project Budget (USD)
$30 - $250

Project Description:
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...)

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 @ ABCfirm.com or www.mycompany 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.

Skills required:
ASP, Javascript, SQL
Hire dragonfin
Project posted by:
dragonfin United States
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.

$ 125
in 4 days
$ 150
in 5 days
$ 110
in 2 days
Hire gkalish
$ 100
in 1 days
$ 100
in 2 days
$ 150
in 2 days
Hire sinharavi
$ 200
in 8 days
$ 125
in 3 days
$ 200
in 10 days
$ 80
in 5 days