how to keep state of checkboxes and textfields

[SteKel2002]

Hi,

I'm struggling with a checkbox and textfield problem, for which i can't find
any solutions. Maybe the goal is a bit exceptional, but i'll try to explain
to this group anyway.

I have created a simple webpage for only 3 users. The page contains a form
with several checkboxes and textfields, which have to be checked, unchecked
or filled in by the users. The things one user changed should be visible for
the next user and so on. Eventually the page should display an actual status
of all the individual users changes, with checked boxes, unchecked boxes and
filled or empty textfields.

For example: checkbox A, B and C are all unchecked and textfield D is empty.
User X checks box A and puts "message for Jack" in the textfield. The next
day user Y finds box A checked, boxes B and C unchecked and the message in
the textfield. Now this user can do it's changes on the page, which will be
presented in that state when the next user visits it.

And there is the problem! As soon as the page reloads, all the changes
disappear because the fields are reset to their original, empty values. I've
looked for scripts, programming possibilities for FrontPage 2003 and so on,
but found nothing relevant.

Who can help, preferably in simple A-through-Z-steps?
Thanks a lot!

Gerard

 

[Thomas A. Rowe]

To accomplish this, you will need to store the data in a database. If your
site is hosted on Windows IIS, then you can use ASP and Access via the FP
database component.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[MD WebsUnlimited.com]

Hi,

You'll have to persist the state of checkboxes and the text field.

I would recommend that you use a comma delimited file to accomplish this
based upon the description and the need for only a single record.

However if you don't know how to to the above then you could use FP Data
Interface Wizard to write the values to a Access database.

The latter is overkill for a simple problem.

 

[SteKel2002]

I already linked the form to a .mdb database, but i can also link to a
simple .csv file or something like that. The problem now is, that i don't
now how and where to use these database entry's to fill the checkboxes and
textfields. It stores all the data in it, not just the latest values, but in
fact i don't use this data for any other purposes. So my question now is:
how should these programming lines look like if they read and write the data
for filling the checkboxes and textfields the way they were altered by the
last user? Or where and in what way do i realise this?

For checkbox: <input type="checkbox" name="K1D" value="ON"
style="font-weight: 700"></font></td>
For textfield: <input type="text" name="T37" size="35"></td>

Thanks in advance!
Gerard

 

[Thomas A. Rowe]

If using FP2002/3 you need to create a edit/update form, this will let you
display the current record from the database for the next user to edit and
then save the update.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[SteKel2002]

Sounds logical, but how do i create an edit/update form? I only know how to
create a normal form using the FP2003 menu-functions.

 

[Thomas A. Rowe]

You will have to check the help function, as I only do hand coding of ASP

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[SteKel2002]

I'll try, thanks. Will the "edit/update form" terms do the trick in a
search, or should i look for other specific terms?

 

[Thomas A. Rowe]

Maybe (I don't have access to my system with FP2003 at the moment)

or try Database.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[SteKel2002]

I did all that, but the information supplied doesn't suit my needs, because
normally those fields need to be cleared for a next user. My situation is
very specific the opposite, i want do do something that normally isn't done.
Therefor it is the first topic i can't find any information on ever :-(

 

[Thomas A. Rowe]

Sorry, I overlooked that part of your original post. So let see if I got
want you want do correct.

You want 3 user to enter data via the form, store this data, and then
display the enter data on a page showing all entries that have been made by
these 3 individuals.

If the above is correct, then you will need your data entry form you have
created, then you just need to create the display page by insert data result
region in a page with your selected fields.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[SteKel2002]

That is what i've done in the first place, but then the problem is, that the
users can't see what has been checked/unchecked on the form. So let's say
checkbox A is checked on the display page by user A, then user B may not
check it again in the form; he will however, because he can't see someone
else has checked it already.
What i want to do now is just keep the checkmarks in the form, until
unchecked again.

 

[Thomas A. Rowe]

Then you will only be able to have a single record in the database that will
be used by all 3 users, with first record entered via the data entry form or
directly in the database, thereafter the record must be modified over and
over.

What is this overall function or purpose of this application, because
something is missing here...

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

 

[SteKel2002]

OK, the function: there are 3 people (including myself) who have a number of
Internet connections available, which should be shared. Now we can agree
never to use more than 1 connection each, but that is a waste when no one
uses the other connections at that time. So when one of us opens a
connection, that person has to check one or more checkboxes on the webpage,
indicating which connections are in use at that time. When a second person
opens the page, he sees wich connections are in use. Now he can open another
one. When no connections are in use, they're all available for the fastest
speed ;-)

Now here's the setup of the form (CB = checkbox, TF = textfield):

User 1 User 2 User 3
Download indication Remarks
Connection A [CB] [CB] [CB]
[TF] [TF]
Connection B [CB] [CB] [CB]
[TF] [TF]
And some more connections.

Suppose User 1 uses connection A, then he should check that box. When user 2
opens the page, he should see the checked box under user 1 for connection A
and he has to check connection B under his name, and he may not check
connection A because that one is in use. The users are thus only allowed to
check/uncheck boxes under their own name.

Eventually all checks, clear checks and text entrys should remain in the
boxes and fields until removed, instead of being disappeared when the page
reloads.

I hope it's clear!

Thanks again,
Gerard

 

[Thomas A. Rowe]

Ok, much better description of what you are trying to accomplish. I have to
think about this for awhile, also other may have some thoughts.

Have you considered a hardware/software solution for automatically sharing
these connection without have to be concerned which ones are free at any
given time, since it would require each you to first indicate that you are
using a connection and then come back and indicate that you are no longer
using the connection.

As an example, Windows 2000/XP gives you the ability to do this under
internet connection sharing with multiple modems, etc.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

OK, the function: there are 3 people (including myself) who have a number of
Internet connections available, which should be shared. Now we can agree
never to use more than 1 connection each, but that is a waste when no one
uses the other connections at that time. So when one of us opens a
connection, that person has to check one or more checkboxes on the webpage,
indicating which connections are in use at that time. When a second person
opens the page, he sees wich connections are in use. Now he can open another
one. When no connections are in use, they're all available for the fastest
speed ;-)

Now here's the setup of the form (CB = checkbox, TF = textfield):

User 1 User 2 User 3
Download indication Remarks
Connection A [CB] [CB] [CB]
[TF] [TF]
Connection B [CB] [CB] [CB]
[TF] [TF]
And some more connections.

Suppose User 1 uses connection A, then he should check that box. When user 2
opens the page, he should see the checked box under user 1 for connection A
and he has to check connection B under his name, and he may not check
connection A because that one is in use. The users are thus only allowed to
check/uncheck boxes under their own name.

Eventually all checks, clear checks and text entrys should remain in the
boxes and fields until removed, instead of being disappeared when the page
reloads.

I hope it's clear!

Thanks again,
Gerard

Then you will only be able to have a single record in the database that will
be used by all 3 users, with first record entered via the data entry

form

or
directly in the database, thereafter the record must be modified over and
over.

What is this overall function or purpose of this application, because
something is missing here...

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

that
the ever
:-( trick
in next
user can
also now
is, fill
the
problem,
for The
page

to

be reloads,
all

 

[SteKel2002]

Sharing the account is being taken care of the way you suggest, using a
router. The connections in this matter are the connections allowed to a news
server at 2 providers. One provider allowes 3 connections at the same time,
the other one 4. So there are 7 connections all together. For instance, when
i check the page and i see all the connections of 1 provider being used by
the other users, i'll use some connections with the other provider.
For your convenience, i've created a webpage with a screenshot and some
further explanation at http://www.xs4all.nl/~kokplm/problem.htm

Ok, much better description of what you are trying to accomplish. I have to
think about this for awhile, also other may have some thoughts.

Have you considered a hardware/software solution for automatically sharing
these connection without have to be concerned which ones are free at any
given time, since it would require each you to first indicate that you are
using a connection and then come back and indicate that you are no longer
using the connection.

As an example, Windows 2000/XP gives you the ability to do this under
internet connection sharing with multiple modems, etc.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

OK, the function: there are 3 people (including myself) who have a

number

of
Internet connections available, which should be shared. Now we can agree
never to use more than 1 connection each, but that is a waste when no one
uses the other connections at that time. So when one of us opens a
connection, that person has to check one or more checkboxes on the webpage,
indicating which connections are in use at that time. When a second person
opens the page, he sees wich connections are in use. Now he can open another
one. When no connections are in use, they're all available for the fastest
speed ;-)

Now here's the setup of the form (CB = checkbox, TF = textfield):

User 1 User 2 User 3
Download indication Remarks
Connection A [CB] [CB] [CB]
[TF] [TF]
Connection B [CB] [CB] [CB]
[TF] [TF]
And some more connections.

Suppose User 1 uses connection A, then he should check that box. When

user

2
opens the page, he should see the checked box under user 1 for

connection

A
and he has to check connection B under his name, and he may not check
connection A because that one is in use. The users are thus only allowed to
check/uncheck boxes under their own name.

Eventually all checks, clear checks and text entrys should remain in the
boxes and fields until removed, instead of being disappeared when the page
reloads.

I hope it's clear!

Thanks again,
Gerard


that
will form let's
say I
got been
made support
see:

So

my exceptional,
but to on
the

 

[SteKel2002]

This is the closest thing i found:
http://groups.google.nl/groups?hl=n...e=UTF-8&oe=UTF-8&selm=398d880f%40cnews&rnum=3

But i have no idea how to approach the possible solutions, not even when i
do a search on the used terms :-(

Ok, much better description of what you are trying to accomplish. I have to
think about this for awhile, also other may have some thoughts.

Have you considered a hardware/software solution for automatically sharing
these connection without have to be concerned which ones are free at any
given time, since it would require each you to first indicate that you are
using a connection and then come back and indicate that you are no longer
using the connection.

As an example, Windows 2000/XP gives you the ability to do this under
internet connection sharing with multiple modems, etc.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

OK, the function: there are 3 people (including myself) who have a

number

of
Internet connections available, which should be shared. Now we can agree
never to use more than 1 connection each, but that is a waste when no one
uses the other connections at that time. So when one of us opens a
connection, that person has to check one or more checkboxes on the webpage,
indicating which connections are in use at that time. When a second person
opens the page, he sees wich connections are in use. Now he can open another
one. When no connections are in use, they're all available for the fastest
speed ;-)

Now here's the setup of the form (CB = checkbox, TF = textfield):

User 1 User 2 User 3
Download indication Remarks
Connection A [CB] [CB] [CB]
[TF] [TF]
Connection B [CB] [CB] [CB]
[TF] [TF]
And some more connections.

Suppose User 1 uses connection A, then he should check that box. When

user

2
opens the page, he should see the checked box under user 1 for

connection

A
and he has to check connection B under his name, and he may not check
connection A because that one is in use. The users are thus only allowed to
check/uncheck boxes under their own name.

Eventually all checks, clear checks and text entrys should remain in the
boxes and fields until removed, instead of being disappeared when the page
reloads.

I hope it's clear!

Thanks again,
Gerard


that
will form let's
say I
got been
made support
see:

So

my exceptional,
but to on
the

 

[Thomas A. Rowe]

See:
http://www.ecom-data.com/Examples/Status/status.asp

Drop me an email and I will send you the files in a zip.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================

Sharing the account is being taken care of the way you suggest, using a
router. The connections in this matter are the connections allowed to a news
server at 2 providers. One provider allowes 3 connections at the same time,
the other one 4. So there are 7 connections all together. For instance, when
i check the page and i see all the connections of 1 provider being used by
the other users, i'll use some connections with the other provider.
For your convenience, i've created a webpage with a screenshot and some
further explanation at http://www.xs4all.nl/~kokplm/problem.htm

Ok, much better description of what you are trying to accomplish. I have to
think about this for awhile, also other may have some thoughts.

Have you considered a hardware/software solution for automatically sharing
these connection without have to be concerned which ones are free at any
given time, since it would require each you to first indicate that you are
using a connection and then come back and indicate that you are no longer
using the connection.

As an example, Windows 2000/XP gives you the ability to do this under
internet connection sharing with multiple modems, etc.

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

OK, the function: there are 3 people (including myself) who have a

number

of
Internet connections available, which should be shared. Now we can agree
never to use more than 1 connection each, but that is a waste when no one
uses the other connections at that time. So when one of us opens a
connection, that person has to check one or more checkboxes on the webpage,
indicating which connections are in use at that time. When a second person
opens the page, he sees wich connections are in use. Now he can open another
one. When no connections are in use, they're all available for the fastest
speed ;-)

Now here's the setup of the form (CB = checkbox, TF = textfield):

User 1 User 2 User 3
Download indication Remarks
Connection A [CB] [CB] [CB]
[TF] [TF]
Connection B [CB] [CB] [CB]
[TF] [TF]
And some more connections.

Suppose User 1 uses connection A, then he should check that box. When

user

2
opens the page, he should see the checked box under user 1 for

connection

A
and he has to check connection B under his name, and he may not check
connection A because that one is in use. The users are thus only

allowed
to

check/uncheck boxes under their own name.

Eventually all checks, clear checks and text entrys should remain in the
boxes and fields until removed, instead of being disappeared when the page
reloads.

I hope it's clear!

Thanks again,
Gerard


"Thomas A. Rowe" <[email protected]> schreef in bericht
Then you will only be able to have a single record in the database that
will
be used by all 3 users, with first record entered via the data entry form
or
directly in the database, thereafter the record must be modified

over
and

over.

What is this overall function or purpose of this application, because
something is missing here...

--

==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)

FrontPage Resources, Forums, WebCircle,
MS KB Quick Links, etc.
==============================================
To assist you in getting the best answers for FrontPage support see:
http://www.net-sites.com/sitebuilder/newsgroups.asp

That is what i've done in the first place, but then the problem

is,
that

the
users can't see what has been checked/unchecked on the form. So let's
say
checkbox A is checked on the display page by user A, then user B

may
not

check it again in the form; he will however, because he can't see
someone
else has checked it already.
What i want to do now is just keep the checkmarks in the form, until
unchecked again.


"Thomas A. Rowe" <[email protected]> schreef in bericht
Sorry, I overlooked that part of your original post. So let see

if

I

form?

I i
can problem
now So users.
The have
to unchecked
and in
the visits
it.