Dynamic Entry Form

This project was awarded to gkalish for $100 USD.

Get free quotes for a project like this
Project Budget
$30 - $250 USD
Total Bids
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 @ [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.

Awarded to:
Skills Required

Looking to make some money?

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

Hire Freelancers who also bid on this project

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online