How to auto enter a form field?

O

Omar K

Hi, I am new to FP 2002 and I have no prior HTML programming
experience.

I have a submission form with fields such as Supplier and Employee.
When the user is ready to input the Supplier or Employee data, s/he can
click on a separate search page for the list of Suppliers or the list
of Employees available. When they find the correct item, they will
click on it, and it will be entered into the submission form field
automatically. (then the search page can close automatically)

The previous data entered cannot be lost/refreshed.

I am thinking that the POST or GET option has to be used, but I am
clueless.

Any help is appreciated
Omar K
 
T

Thomas A. Rowe

You need to have then select the Supplier and Employee prior to entering the form and filling in
data or you need to pre-populate individual drop down menus with the Suppliers and Employees while
on the form.

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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
O

Omar K

so having the user pre-select the supplier and employee values avoid
the use of drop down boxes? how is this if the search pages for
supplier and employee are on separate pages?

I am following a structure I saw on a car rental site (avis.com) where
the user must enter a date, but can click on a calendar to select the
date and it will then be entered automatically into the original form.
Is it possible to do this in FP2002 with minimal HTML programming? and
how?

Thanks
 
T

Thomas A. Rowe

You would select the value, say for Supplier, and it would then be pass to the next page, where it
is stored in a session, then you would select Employee, then it and the Supplier is pass to the
form, where the rest of the info is enter, and then pass to the database or email as a hidden form
field.

What you saw on Avis, with the date, is most likely a JavaScript calendar function which when a date
is selected, it is inserted into a form file. JavaScript is run client side in the browser and if
the user happens to have JavaScript disabled, then the use has to manually type in the date.

I think the easiest approach is to use drop down menu on the actual form, that way the user never
leaves the form which can be done directly in FP.

The passing of variable/session requires knowledge of JavaScript or Server-Side Scripting written in
ASP, PHP, etc.
--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
O

Omar K

thanks ...

can you suggest a website or example that can show me the basics /
format of the ASP programming for passing of variables. I have three
other functions that may need that.

1) The outgoing / incoming qty of stock (another form) must be
subtracted/added to the overall qty of that stock which is saved in a
different database. i want the out/in stock qty to be stored in a
different table as well for future reference.

2) the date of stock transaction (one form field) must be saved to two
different tables - how can i do this?

3) i want to alert the user when the overall qty is less than the
'minimum qty' (min level of stock before re-order) both are stored in
their own column and the same table.

are these things possible with the FP interface? maybe with advanced
options? or must i use the retrieval of data coding? I was looking at a
document 'How to complete mathematical calculations on a form before
you send data to a database in FP2002' - would this be of any help?

much thanks
o.k.
 
T

Thomas A. Rowe

Yes, FP can be used, and you may be able to use the FP database component, however you will find it
easier to learn to code ASP/VBScript directly, as that will allow you to easily incorporate examples
that you do find on the internet.

There is no one site that will help, you would need to visit many resources to find various
examples.

http://www.asp101.com, samples
This is the site that I found most helpful with examples when I first started with ASP/VBScript.

The following provides you with a reference to VBScript
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/script56/html/vtorivbscript.asp


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

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Top