[webproducers] Re: form with unique numbering system

[<hoyaduke@xxxxxxxxxxxxxx>]

Shirley,

Two ideas:

1) The proper way to do this would be through some sort of database on the 
backend that captures your webform data and assigns it a unique number.  If you 
familiar with connection DBs to websites this is easily done.  Both MS-SQL 
Server and MS-Access will do autonumbering for you on a primary-key.

2) My other idea is a work around and not something i would normally suggest 
but given your experience level it might be appropriate.  This will only work 
if you don't need to store which numbers get assigned to which clients but only 
need unique numbers to be generated.  You can look on the web for some 
javascript functionality designed for page or visitor counter and use that to 
create the numbers.  Note: This may not work all the time if your clients have 
javascript turned off though.

Good luck,
Duke




webproducers@xxxxxxxxxxxxx wrote:
> 

  Per Morry's recommendation, I'm requesting the listserv's advice.  Thanks to 
all of you for such a great group of people willing to help each other. I've 
been a silent member for some time --so this is my first post --  Thanks in 
advance !    
  Shirley
morry  wrote: Shirley,

I'm glad you are on the list and I'm glad you asked me this. This
is a perfect question for the list but I'll try to answer as best
as I can.

Because
of the importance of ensuring the numbers are accurate this has to
be thought out and planned for both usability (to try to avoid human
error---avoiding computer error is easier) and technical accuracy. Have
you thought of hiring a freelancer programmer? You should probably
consider someone with experience doing dynamic web stuff. I know some
people if you have the budget. Otherwise I would look into what other
people out there have done for similar type projects. You might want to
post your message to the whole WebProducers list it's really a good
questions and you get to pull from the experience of more than 200 people
from all over.

On Mon, 28 Jan 2002, Shirley Cruse wrote:

> I have been following posts from this group for
> several months. Yes, I've been silent, learning from
> your tips. Thanks ! I'm asking for advice, opinions,
> and appreciate any help you can give me. 
> I think this is a bad idea, but here is my
> predicament:
> My supervisor wants me to create a form,that it is 
> web-based,& to be completed by the user(client). The
> program will need to assign a unique number on the
> form and for the user to put on a label(any numbering
> scheme, sequential is ok)that the client uses to label
> & mark hazardous waste for disposal. The form would be
> filled out online and sent to our Haz Waste department
> so they will pick up the waste. It is imperative that
> the number on the pick up order and the tagged waste
> match. It is imperative that the number is not
> repeated or duplicated. If it is thrown away and not
> used, that is ok.
> 
> I know excel and word docs do this, (like
> invoicing)and I'm sure a database connected to the
> form would probably do it. I'm not sure where to
> start.
> 
> Which way should I go to check this out? I don't have
> much time. I usually just do static web pages, and
> have very limited experience.
> Shirley
> 
> =====

> email : shcrus00@xxxxxxxxx


Shirley & Rob Cruse
email : shcrus00@xxxxxxxxx
Work: scruse@xxxxxxxxxxxxx
email me at shirley@xxxxxxxxxxxxxxxx


---------------------------------
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!

__________________________________________________________________________
To unsubscribe send a blank message with unsubscribe in the subject to 
webproducers-request@xxxxxxxxxxxxx

To access our webform (instead of sending e-mail) for popular commands 
including subscribe, unsubscribe, digest, and vacation  visit  
www.WebProducers.org. You can also access the list archive at the website.

Questions and comments are welcome just e-mail me, morry@xxxxxxxxxxxxxxxx

__________________________________________________________________________
To unsubscribe send a blank message with unsubscribe in the subject to 
webproducers-request@xxxxxxxxxxxxx

To access our webform (instead of sending e-mail) for popular commands 
including subscribe, unsubscribe, digest, and vacation  visit  
www.WebProducers.org. You can also access the list archive at the website.

Questions and comments are welcome just e-mail me, morry@xxxxxxxxxxxxxxxx

Other related posts:

[webproducers] Re: form with unique numbering system

[webproducers] Re: form with unique numbering system