PC Review


Reply
Thread Tools Rate Thread

Auto fill forms

 
 
woody22
Guest
Posts: n/a
 
      21st Jul 2004

Hi,

ive got an online system which allows people to enter info into
database about an absence request they have - at the same time thi
emails the person in charge of absences.

The form is setup now but to make it easier i want to alter the "Name
and "email" fields so they require no filling in ie - a staff member
name will be chosen from a drop down list (ive done this bit fine) an
then once this is done the relevant email for this person i
automatically placed in the email field. This bit i am struggling wit
- anyone any ideas how this can be done??

Thanks!

Woody :


-
woody2
-----------------------------------------------------------------------
Posted via http://www.forum4designers.co
-----------------------------------------------------------------------
View this thread: http://www.forum4designers.com/message98905.htm

 
Reply With Quote
 
 
 
 
Thomas A. Rowe
Guest
Posts: n/a
 
      21st Jul 2004
Not possible when using the FP Form Handler to have the form data sent to an email address the is
being supplied when the form is submitted.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, 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

"woody22" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> Hi,
>
> ive got an online system which allows people to enter info into a
> database about an absence request they have - at the same time this
> emails the person in charge of absences.
>
> The form is setup now but to make it easier i want to alter the "Name"
> and "email" fields so they require no filling in ie - a staff members
> name will be chosen from a drop down list (ive done this bit fine) and
> then once this is done the relevant email for this person is
> automatically placed in the email field. This bit i am struggling with
> - anyone any ideas how this can be done??
>
> Thanks!
>
> Woody
>
>
>
> --
> woody22
> ------------------------------------------------------------------------
> Posted via http://www.forum4designers.com
> ------------------------------------------------------------------------
> View this thread: http://www.forum4designers.com/message98905.html
>



 
Reply With Quote
 
Jens Peter Karlsen[FP-MVP]
Guest
Posts: n/a
 
      21st Jul 2004
You could use an onchange that called a function that dependent on the
currently selected value of the dropdown inserted the correct values in
the fields.
Something like:
function mail(){
if (document.forms[0].dropdownname.value=="Tom Jones")
document.forms[0].emailfieldname.value="(E-Mail Removed)";
else if ...
And so on.

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

-----Original Message-----
From: woody22 [private.php?do=newpm&u=]
Posted At: 21. juli 2004 15:43
Posted To: microsoft.public.frontpage.client
Conversation: Auto fill forms
Subject: Auto fill forms



Hi,

ive got an online system which allows people to enter info into a
database about an absence request they have - at the same time this
emails the person in charge of absences.

The form is setup now but to make it easier i want to alter the "Name"
and "email" fields so they require no filling in ie - a staff members
name will be chosen from a drop down list (ive done this bit fine) and
then once this is done the relevant email for this person is
automatically placed in the email field. This bit i am struggling with
- anyone any ideas how this can be done??

Thanks!

Woody



--
woody22
------------------------------------------------------------------------
Posted via http://www.forum4designers.com
------------------------------------------------------------------------
View this thread: http://www.forum4designers.com/message98905.html


 
Reply With Quote
 
woody22
Guest
Posts: n/a
 
      22nd Jul 2004

thanks for that ill have a go today - where would i put the code fo
this though??

Woody

Jens Peter Karlsen[FP-MVP] wrote:
> *You could use an onchange that called a function that dependent o
> the
> currently selected value of the dropdown inserted the correct value
> in
> the fields.
> Something like:
> function mail(){
> if (document.forms[0].dropdownname.value=="Tom Jones")
> document.forms[0].emailfieldname.value="(E-Mail Removed)";
> else if ...
> And so on.
>
> Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.
>
> -----Original Message-----
> From: woody22 [private.php?do=newpm&u=]
> Posted At: 21. juli 2004 15:43
> Posted To: microsoft.public.frontpage.client
> Conversation: Auto fill forms
> Subject: Auto fill forms
>
>
>
> Hi,
>
> ive got an online system which allows people to enter info into a
> database about an absence request they have - at the same time this
> emails the person in charge of absences.
>
> The form is setup now but to make it easier i want to alter th
> "Name"
> and "email" fields so they require no filling in ie - a staf
> members
> name will be chosen from a drop down list (ive done this bit fine
> and
> then once this is done the relevant email for this person is
> automatically placed in the email field. This bit i am strugglin
> with
> - anyone any ideas how this can be done??
>
> Thanks!
>
> Woody
>
>
>
> --
> woody22
> ------------------------------------------------------------------------
> Posted via http://www.forum4designers.com
> ------------------------------------------------------------------------
> View this thread: http://www.forum4designers.com/message98905.html



-
woody2
-----------------------------------------------------------------------
Posted via http://www.forum4designers.co
-----------------------------------------------------------------------
View this thread: http://www.forum4designers.com/message98905.htm

 
Reply With Quote
 
woody22
Guest
Posts: n/a
 
      22nd Jul 2004

woody22 wrote:
> *thanks for that ill have a go today - where would i put the code fo
> this though??
>
> Woody *


Ive come up with this:


Code
-------------------


function mail()
if firstname.value="Gary Rodgers"
then
emailfieldname.value="(E-Mail Removed)";
else if
firstname.value="Paul Worsnop"
then
emailfieldname.value="(E-Mail Removed)";
end if
end


%>


-------------------


but this makes the browsers come up with the following error message:


Code
-------------------


Microsoft VBScript compilation error '800a03f9'

Expected 'Then'

/AbsenceForm/Absence.asp, line 24

if firstname.value="Gary Rodgers"
---------------------------------^


-------------------


whats wrong with my code???

Wood


-
woody2
-----------------------------------------------------------------------
Posted via http://www.forum4designers.co
-----------------------------------------------------------------------
View this thread: http://www.forum4designers.com/message98905.htm

 
Reply With Quote
 
woody22
Guest
Posts: n/a
 
      27th Jul 2004

can anyone offer any advice?



woody22 wrote:
> [B]Ive come up with this:
>
> >

Code
-------------------
>
>
> function mail()
> if firstname.value="Gary Rodgers"
> then
> emailfieldname.value="(E-Mail Removed)";
> else if
> firstname.value="Paul Worsnop"
> then
> emailfieldname.value="(E-Mail Removed)";
> end if
> end
>
>
> %>
>
>

-------------------
>
>
> but this makes the browsers come up with the following erro
> message:
>
> >

Code
-------------------
>
>
> Microsoft VBScript compilation error '800a03f9'
>
> Expected 'Then'
>
> /AbsenceForm/Absence.asp, line 24
>
> if firstname.value="Gary Rodgers"
> ---------------------------------^
>
>

-------------------
>
>
> whats wrong with my code???
>
> Woody [/B



-
woody2
-----------------------------------------------------------------------
Posted via http://www.forum4designers.co
-----------------------------------------------------------------------
View this thread: http://www.forum4designers.com/message98905.htm

 
Reply With Quote
 
Thomas A. Rowe
Guest
Posts: n/a
 
      27th Jul 2004
function mail()
if firstname.value="Gary Rodgers" then
emailfieldname.value="(E-Mail Removed)";
elseif firstname.value="Paul Worsnop" then
emailfieldname.value="(E-Mail Removed)";
end if
end
%>

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WEBMASTER Resources(tm)
http://www.ycoln-resources.com
FrontPage Resources, 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

"woody22" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
>
> can anyone offer any advice?
>
>
>
> woody22 wrote:
> > Ive come up with this:
> >
> > >

> Code:
> --------------------
> >
> >
> > function mail()
> > if firstname.value="Gary Rodgers"
> > then
> > emailfieldname.value="(E-Mail Removed)";
> > else if
> > firstname.value="Paul Worsnop"
> > then
> > emailfieldname.value="(E-Mail Removed)";
> > end if
> > end
> >
> >
> > %>
> >
> >

> --------------------
> >
> >
> > but this makes the browsers come up with the following error
> > message:
> >
> > >

> Code:
> --------------------
> >
> >
> > Microsoft VBScript compilation error '800a03f9'
> >
> > Expected 'Then'
> >
> > /AbsenceForm/Absence.asp, line 24
> >
> > if firstname.value="Gary Rodgers"
> > ---------------------------------^
> >
> >

> --------------------
> >
> >
> > whats wrong with my code???
> >
> > Woody

>
>
>
> --
> woody22
> ------------------------------------------------------------------------
> Posted via http://www.forum4designers.com
> ------------------------------------------------------------------------
> View this thread: http://www.forum4designers.com/message98905.html
>



 
Reply With Quote
 
Jens Peter Karlsen [FP MVP]
Guest
Posts: n/a
 
      1st Aug 2004
= is an assignment operator. == compares.
So it must be:
function mail()
if firstname.value=="Gary Rodgers" then
emailfieldname.value="(E-Mail Removed)";
elseif firstname.value=="Paul Worsnop" then
emailfieldname.value="(E-Mail Removed)";

Regards Jens Peter Karlsen. Microsoft MVP - Frontpage.

On Tue, 27 Jul 2004 17:35:55 -0400, "Thomas A. Rowe" <(E-Mail Removed)>
wrote:

>function mail()
>if firstname.value="Gary Rodgers" then
>emailfieldname.value="(E-Mail Removed)";
>elseif firstname.value="Paul Worsnop" then
>emailfieldname.value="(E-Mail Removed)";
>end if
>end
>%>


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Auto fill in forms T Microsoft Excel Worksheet Functions 2 29th May 2009 11:28 PM
auto fill forms =?Utf-8?B?bXBraW5n?= Windows XP General 1 24th Aug 2006 04:44 PM
RE: Auto-fill forms in XP? =?Utf-8?B?TWF0dA==?= Windows XP Customization 0 27th May 2004 08:11 PM
Re: Auto-fill forms in XP? Haus Windows XP Customization 0 27th May 2004 08:09 PM
Auto Fill Forms =?Utf-8?B?SGlsaWs=?= Windows XP Basics 4 27th Apr 2004 07:56 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 06:02 PM.