Please help a new goldmine user thrown into the admin role.

[MuttzNuttz]

I need to automatically populate a field called Uour_ref: with a 5 digit number sequentailly increasing by 1 each time a "New" contact or "New" company & contact is added to goldmine by the users.
EG:
new contact added> our ref 00500
new contact added> our ref 00501
New company & contact added> our ref 00502

We are using Goldmine 6.5 SQL Version. what would be the best practice on this & How is it best to accomplish?

Automatic proceedure, trigger lookup.ini ?

what settings would be required on the field to allow this and not allo users to change the auto generated number ?


Many thanks for any help on this in advance

Brian

 

[Spirit]

I personally like to use an Access link table or use SQL directly to accomplish things like this.

I hate goldmine but somehow got lumbered administrating it about a year ago and every time I use a look up ini or any goldmine utility I break it.... oops!

Anyhow, good luck.

Iain

 

[MuttzNuttz]

I have been looking around & figured out how to stop any alterations to the field by setting Public read access and master write access so you can disregard that area thanks.

I am no programmer so any help on the other section would still be appreciated.

If I don`t learn to do it here, Who else is going to?

 

[goner]

you want to look up the counter function in the Frontrange knowledgebase. support.frontrange.com


Doug Castell
Computer Control Corp
(310)396-6811

http://www.ccc24k.com

 

[MuttzNuttz]

I have resolved this using lookup.ini as follows

[AUTOUPDATE]
NewRecord=Uour_ref

[Uour_ref]
Otherwise = &padl(ltrim(str(counter([AcctNo],1,000))), 5, [0])
Overwrite=1

Thanks to all responders.

If I don`t learn to do it here in this Lifetime, Where else would I go and what would I do?