Autogenerated ID Number

[LostRookie]

Hello all,
I have a problem that I hope someone here can help me with. I have
created a Frontpage 2003 form for a company website which needs a unique ID
number automatically generated each time the form is submitted. It is a work
order, which needs a unique identifying number with each submission. How can
I do this with, or in, Frontpage 2003 or whatever? Thanks in advance.

 

[LostRookie]

P.S. The form, when submitted, gets emailed to a Groupwise Account. This is

 

[Joey]

I would create a Database with an autoID column. Then submit the form to a
second page with a DRW and an email script. Do you have Cdonts available on
your server?

If you dont understand what I am talking about I'll explain it better.

 

[clintonG]

I've devised and coded several unique ID projects for e-commerce customers
using various strategies.

Briefly, the unique ID is generated on the server, put into the page and if
used sent back to the server where it is stored in the database. Over the
years many strategies have been devised to generate the ellusive "unique ID"
with most of the trade-off being user readability. The most common and for
all practical purposes guaranteed unique ID requires the use of a GUID which
looks like this...

c41393f2-5eb1-4c9b-ace4-a8a31f94de79

// To learn more...
search term: define:GUID

Others use less unique values such as those that can be auto-incremented by
the database (weak, brittle, and procesor intensive) which are also often
used as a primary key in a table. When building "friendly" IDs for work
orders the best strategy -- arguably -- is an alphanumeric composite which
can be read by humans while retaining its semantics allowing the alpha
characters to represent business intelligence and the numerics the same
and/or incremental values used simply for counting and tracking and
reporting.


<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/

 

[LostRookie]

If you could elaborate more I'd appreciate it. What is DRW and Cdonts?

 

[LostRookie]

Thank you. I appreciate your suggestion.

I've devised and coded several unique ID projects for e-commerce customers
using various strategies.

Briefly, the unique ID is generated on the server, put into the page and if
used sent back to the server where it is stored in the database. Over the
years many strategies have been devised to generate the ellusive "unique ID"
with most of the trade-off being user readability. The most common and for
all practical purposes guaranteed unique ID requires the use of a GUID which
looks like this...

c41393f2-5eb1-4c9b-ace4-a8a31f94de79

// To learn more...
search term: define:GUID

Others use less unique values such as those that can be auto-incremented by
the database (weak, brittle, and procesor intensive) which are also often
used as a primary key in a table. When building "friendly" IDs for work
orders the best strategy -- arguably -- is an alphanumeric composite which
can be read by humans while retaining its semantics allowing the alpha
characters to represent business intelligence and the numerics the same
and/or incremental values used simply for counting and tracking and
reporting.


<%= Clinton Gallagher
METROmilwaukee (sm) "A Regional Information Service"
NET csgallagher AT metromilwaukee.com
URL http://metromilwaukee.com/
URL http://clintongallagher.metromilwaukee.com/

 

[Joey]

This is how I would do it:
1. Create the form.
2. Right click in the form and choose form properties.
3. select send to database and then click options.
4. Select either create database or connect to database.
5. enter the confirmation page name.
6. Click on the saved fields tab and match the form fields with your
database field.

If you wish to view the data on your confirmation page. Your ID will always
be unique.
1. Insert>Database>Results and choose the correct database and table.
You could create an elaborate online work order system with forms and the
DRW (Database Results Wizard)

This will be tricky but you could use this script with a slight modification
to automatically send the emails from your confirmation page:
http://home.att.net/~codeLibrary/FrontPage/cdonts.htm Thats assuming your
server has cdonts installed.