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
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.
Browse Related Skills
Other things people do on Freelancer
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
Looking for work?
Work on projects like this and make money from home!Sign Up Now
- The New York Times
- Wall Street Journal
- Times Online