Aknot Posted April 8, 2004 Posted April 8, 2004 I need/want to create a form/spreadsheet that users can can add their name and date to a line. example: The "item line" would be called TEST SYSTEM 1. To the right of that would be 4 fields. One field for someone to put in their name and a small field next to it for a date. That would be in a column labeled First Review. They shouls be able to "save" it. So when someone goes to view the name and date is there. The next column in that line would be labled 2nd Review and have the same two fields. Then we go to test system 2, 3, 4 etc. each with the 4 fields. Thanks. Quote
kaseytraeger Posted April 8, 2004 Posted April 8, 2004 Aknot, I don't think I completely understand what you want to do... From what I read, it looks like you want a form with four fill-in fields in a row, similar to the following (just cut and paste into your favorite web page creator and then view it in a web browser). I've also tried to attach a screenshot of the form, but I don't know if it will come through correctly. I hope so. ><!doctype html public "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <title>Page Title Goes Here</title> <meta http-equiv="Content-Language" content="en-us" /> <!-- Use the following meta tag instead of declaring <?xml version="1.0" encoding="iso-8859-1" ?> at the beginning of the document. This is because not all browsers understand the <?xml ... ?> command. --> <meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1" /> <meta http-equiv="imagetoolbar" content="no" /> <meta http-equiv="pragma" content="no-cache" /> <meta http-equiv="expires" content="-1" /> <meta name="author" content="" /> <meta name="copyright" content="" /> <meta name="mytopic" content="" /> <meta name="distribution" content="global" /> <meta name="classification" content="" /> <meta name="robots" content="all" /> <meta name="keywords" content=""> <meta name="description" content="" /> <style> <!-- label{font:12px tahoma,verdana,sans-serif;} --> </style> </head> <body> <form> <strong>TEST SYSTEM 1:</strong> <label for="name1">Name 1:</label> <input type="text" id="name1" name="Name1" maxlength="30" size="8" /> <label for="date1">Date:</label> <input type="text" id="date1" name="Date1" maxlength="10" size="8" /> <strong>TEST SYSTEM 2:</strong> <label for="name2">Name 2:</label> <input type="text" id="name2" name="Name2" maxlength="30" size="8" /> <label for="date2">Date:</label> <input type="text" id="date2" name="Date2" maxlength="10" size="8" /> <br /> <input type="submit" value="Save Data" /> </form> </body> </html> However, I'm not sure what you want to do with the information once you've got people to enter it. Also, why two completely identical fields in the same row? I think that's where I'm caught up. I don't understand what the purpose of these fields is other than to allow someone to enter two names and two dates at the same time. What exactly do you want to have happen to the data once the user hits the "Save Data" button? Quote
kaseytraeger Posted April 14, 2004 Posted April 14, 2004 Aknot, Did you ever get this issue resolved? Quote
Aknot Posted April 14, 2004 Author Posted April 14, 2004 Thanks. Thats (the picture) it. Is there a way to make the first "test" system a user entry field snd mske it populate automatically from the first? But yes that is what Im looking for. Thanks again. Quote
kaseytraeger Posted April 14, 2004 Posted April 14, 2004 You want the content of TEST SYSTEM 2 to be taken directly from what the user types into TEST SYSTEM 1? If that's the case, yes, it can be done. I'll work on it for you, but I need to make sure that I have a full understanding of where the "automatically copied" information will be coming from. Quote
Aknot Posted April 16, 2004 Author Posted April 16, 2004 Thanks. Basically I guess it would be/could be like this. I open the page. There are Feilds for me to enter: System Name My Name Date I would enter that information and it would populate to a "spreadsheet" viewable via webpage in the format above leaving the next two fields (another "name and Date" feild) Blank. The next time someone enters the same system name it would populate the second name and date feilds to show "ownership" of that system has changed. I appreciate the help sorry for the slow response. Million things going on. Do you Have a favorite "Sports" team? Quote
kaseytraeger Posted April 16, 2004 Posted April 16, 2004 I open the page. There are Feilds for me to enter:System Name My Name Date I would enter that information and it would populate to a "spreadsheet" viewable via webpage in the format above leaving the next two fields (another "name and Date" feild) Blank. The next time someone enters the same system name it would populate the second name and date feilds to show "ownership" of that system has changed. This is definitely a task for PHP and MySQL database. The overall process will happen like this. (1) web page has three text fields (2) user enters data into each of the three fields and clicks "submit" (3) data from each of the three fields is transferred to a MySQL database when the "submit" button is clicked. (4) the page refreshes with an embedded PHP script calling the MySQL database for the data stored in each record of the database (5) the PHP script generates a table using the data in the database (6) the refreshed page now displays the table of MySQL data (even those from people who have entered data prior to my data enry) and resets the data entry fields to be empty Sound about right? I can provide sample code for this for you, but you'll have to create the MySQL database and make changes to the code to properly reflect the database-specific information such as db name, table name, an authorized user name and password, etc. As for sports teams ... can't say that I have a favorite. I don't follow too many sports these days. I think I got burned out on it (yes, for all you sports fans out there, some people do get burned out ) when I was a child. My parents hauled me around to so many sporting events that they stopped being fun around the time I turned 12 or 13. I still enjoy a good baseball game, though. These days, I'm more likely to watch my own local teams than those from other parts of the country. However, in my baseball hey-day, I was an avid fan of the Braves. Quote
kaseytraeger Posted April 16, 2004 Posted April 16, 2004 Oops, I see a mistake in my understanding already. You want the system name to stay constant after being entered by the first person. Subsequent people are only allowed to enter name and date, right? Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.