-----Original Message-----
Trying to create a survey that a user can re-edit own
entry and resubmit. I know how to create FP forms and
databases, etc.
Any tips or templates on constructing resubmittable
forms and passwording to hook user up to his/her own
data would be greatly appreciated.
You would need to program this in ASP, ASP.NET, or some
other environment that runs on the Web server.
First, of course, the survey page must require some sort
of login. Otherwise, when the same visitor returns to
change their entry, you won't know it's the same visitor.
Also, you would have no way to stop one visitor from
changing another visitor's submission.
You could also identify the visitor by means of a cookie.
In this scenario, whenever you accept a survey
submission, you would assign an identity value such as
random number or GUID. Then, you would store this
identity value along with the survey results and also
send it back to the visitor as a cookie. When the visitor
returns to your site, the browser will send the cookie
value back to you, and you can use it to retrieve the
prior survey results.
In either case, you would store the survey response *and*
the identity value in the same database record. When the
visitor displays the survey form, code on the server
would search for an existing record with the same
identity. If it found one, it would initialize the form
with the previous responses.
Altogether, this would require about 100-200 lines of
program code in addition to your HTML. (A self-
registration and login system, if you need one, would be
extra.)
If all this sounds too difficult, you can look around for
a prewritten survey system.
Alternatively, Microsoft SharePoint Team Services has a
survey tool that allows visitors to change previous
submissions. However, this is likely to be practical only
on an intranet where SharePoint Team Services or
SharePoint Portal Server are already in use.
Jim Buyens
Microsoft FrontPage MVP
http://www.interlacken.com
Author of:
*----------------------------------------------------
|\---------------------------------------------------
|| Microsoft Office FrontPage 2003 Inside Out
|| Microsoft FrontPage Version 2002 Inside Out
|| Web Database Development Step by Step .NET Edition
|| Troubleshooting Microsoft FrontPage 2002
|| Faster Smarter Beginning Programming
|| (All from Microsoft Press)
|/---------------------------------------------------
*----------------------------------------------------
