Online Checklist

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a webpage that consists of a checklist. Is it possible for a
user to use this online webpage and check off what has been done but then
save the webpage to later go back to check off more items done and have the
original items still checked off.
If so, how can I do this?
I hope this makes sense.

Thank you,
Me
 
Yes. You can store the information in a database. Create a login screen
(or something that identifies who each person is). Then after they log in
(or select their name from a drop down box etc) you would have code that
goes to the database, retrieves their records and populates the checklist.
Then when they click save it would update the database with their new
updates. Each person would have a record in the database.

You should look for articles on ASP and databases. Look at the Database
Wizard in FrontPage.
 
I hope this doesn't make me sound too stupid but since I'm still pretty new
at creating databases with Frontpage would you happen to have step by step
instructions that I could use or know where I may be able to get some?
 
Ok so I was able to create the login page which works perfect. Now I need to
create a form that consists of a checklist? Is that correct?
 
I'm sorry, I'm so confused. I just want to make sure I'm looking at the right
thing for what I want to do.
I have a webpage form that is a checklist i.e. there is a list of "To Do"
items and before each "To Do" item is a checkbox that can be checked to show
that this item has been done.
I would like the form to be saved by an individual who has checked 3 out of
10 of the "To Do" items. Then they are able to come back another time and
check off a few more items when needed but still have the original 3 items
still checked.
I have created the login page so that a username and password is needed.
Now do I take the database that was created for the username and password
and add fields for each of the "To Do" items?
How do I connect the form to the already created database?
As much help as possible would be so wonderful!!!!
 
I know you must hate me. So here's where I am and stuck. I figuered out how
to connect the form to the database and it works great in saving the info.
Now how do I make it so that when I sign back in the form is prefilled from
the previous visit of changes?
 
Your database would have 2 tables. For example:

1 table called Users (for the logion information) which would have UserID,
UserName, Password, FirstName, LastName

1 table called ToDo to hold the checklist items. This would have a ToDoID,
UserID, and then a field for each To Do item.

After the login you would retrieve the UserID from the Users table and pass
that to the form. Then when they submit the form you would insert the UserID
and all the values for the ToDo Fields.

To get their information back you would create a SQL Statement that
retrieves only the records for the user that logged in. Ex:

SELECT * FROM ToDo WHERE UserID = <user id value>

As for making sure they answer 3 questions before they submit the form you'd
either need to use Form Validation for custom JavaScript.
 
The table you're getting the information from needs to have the user's name
(or ID) in it for their records. Then you would do SELECT * FROM TableName
WHERE User = <user value from the login screen>
 
Hi

If you want the check boxes to be checked from the database you have to add
some code to the check box like this. Lets say one of you database fields
is called "thingtodo" and you are using the fp database , if not then you
put the name of you datase instead of (FP_FieldHTML(fp_rs,"thingtodo"), and
that the field will have an entry of yes when checked
Best wishes
Paul M

<input type="checkbox" name="thingtodo" value="yes" <%If instr
(FP_FieldHTML(fp_rs,"thingtodo"), "yes") Then%>checked<%End If%>>
 
In Code View or, if you're using the FrontPage Database Wizard you'd put it
there. Personally I stay away from the database wizard. If you look at the
samples at www.asp101.com/samples all you need to do to try those scripts is
open a page in FrontPage, switch to Code View and paste the code in there.
 
Still having problems!!

Ok here's where I'm at:
I have a section in my webpage that needs a username and password to access.
Within this section is a link to a form that is a To Do list. Before each
item in the list is a checkbox.
1
2
3
4
5
etc........
I have connected this form to the database that houses the username and
passwords.
When for example Items 1-3 are checked and the form is submitted this
information is transferred to the database BUT instead of it being part of
the same record as the matching username and password its entered into a NEW
record with no username or password attached.
How do I fix this?
I would like this form to be setup so that when this person signs back in
and accesses this form any previous checked items are shown checked and they
can continue down the list and check off items as they go.
 
How do I creat an SQL Statement?

David Berry said:
Your database would have 2 tables. For example:

1 table called Users (for the logion information) which would have UserID,
UserName, Password, FirstName, LastName

1 table called ToDo to hold the checklist items. This would have a ToDoID,
UserID, and then a field for each To Do item.

After the login you would retrieve the UserID from the Users table and pass
that to the form. Then when they submit the form you would insert the UserID
and all the values for the ToDo Fields.

To get their information back you would create a SQL Statement that
retrieves only the records for the user that logged in. Ex:

SELECT * FROM ToDo WHERE UserID = <user id value>

As for making sure they answer 3 questions before they submit the form you'd
either need to use Form Validation for custom JavaScript.
Click to expand...
 
Hi
You would probably be better finding a simple membership script and then
Modifying it.(adding fields) you can usually see what is going on within the
script then cut and past and change field names etc Have a look on google
and spend a little time searching for the script which resembles the one
you want
here is one I found, I have never tried it though
Good Look
Paul M

http://www.indiawebdevelopers.com/products/MemberArea.asp
 
Back
Top