Counter expression needed in lookup

[Jonesxx]

Hello

I am trying to enter a counter expression as a lookup in GoldMine V 6.7. I have an invoice number field in GoldMine and I would like this field to be auto-populated when the entry in the lookup is clicked on.

I would like to start on number 00001, then 00002, then 00003............000010, 000011 etc, I am currently using the expression ~COUNTER("ID",0001)which displays the number 1 in the invoice number field, however the 0000 section of the number is excluded.

Can somebody please advise.

Cheers!

 

[MIChad76]

You can do this with the PADL function.

PADL("Test", 8, "x")

Returns xxxxTEST so you'd want something like

padl(ltrim(str(counter("A", 1,1))), 8, "0")



---
Chad Smith
michad76@gmail.com

Check out the GoldMine Blog at

http://www.thegmblog.com

MCP - Microsoft SQL Server
Crystal Reports Certified Professional
GoldMine Certified Professional
Microsoft CRM Certified Professional

 

[Jonesxx]

Thank you for the expression it worked, also thanks for the link to the gmblog, very useful.

Jones

 

[goner]

yeah, but mine is better!

http://www.castellcomputers.com

Just kidding!! The more the merrier!



Doug Castell
Castell Computers

http://www.castellcomputers.com

 

[richardy]

No mines better!!

http://www.prior-analytics.com

Regards,

Richard.
PRIOR Analytics UK

http://forums.prior-analytics.com

Sage CRM, GoldMine & HEAT Solutions Partner in the UK

 

[goner]

but it's not a blog! You copy cats!


Doug Castell
Castell Computers

http://www.castellcomputers.com

 

[lisaharris]

You guys crack me up!

Boys and their blogs......