A sequence number field.. 
Use this IdeaSpace to post ideas about Domino Designer.

: -23
: 3
: 26
: Domino Designer
: Designer, field
: Scott Cochrane1847 24 Dec 2007
: / Email
Hows about a new field for designer that is a sequence number (similar to an identity field on sql server/db2 etc).
So you could add a new field to a form and select datatype 'Sequence Number'.  It auto-generates a sequence number in this field for every document that is saved using this form.  Its be nice if saving via lotusscript also generated the sequence number without the need to do anything other than set the form field on the document.
Of course this gets complicated with replicas.  Maybe it should be possible to choose to not maintain the sequence number across replicas or if you want to do this it uses the adminstration server specified in the acl as the central place to lookup the sequence?
Or maybe this ought to be a separate design element but simply keyed to the form.  What d'all think?

1) Rajeev Menon3439 (24 Dec 2007)
Since notes is not a relational db, I don't think the sequence number concept will work well in notes.
2) Thomas Bahn4937 (24 Dec 2007)
I see no way, how this could be made possible with (disconnected) replicas at all.
3) Scott Cochrane1847 (28 Dec 2007)
I appreciate that is won't work seemlessly on a disconnected replica, but surely you have to design around things when replicas are local anyway. And there would be ways around it.

Given the number of demotes (is this a record so far?) I am thinking I'm in the only business where users want to see a sequential reference numbers on documents.
4) Carl Rizzo1674 (16 Feb 2010)
Hi Scott,

You are not the only one with this challange. I have struggled with this issue for many years and it would be worth any effort that resulted in a field or a strategy that worked. Maybe the key is in the sequential numbering system. If the user is using a local copy maybe the number is not assigned until you can go online and claim the next number. Unique is not good enough for our auditors. They want sequential too. Thanks
5) Scott Cochrane1847 (17 Feb 2010)
Good to hear Carl - glad its not just me.

But do I leave this open or not? What is the etiquette on here? Anyone ?


Welcome to IdeaJam

You can run IdeaJam™ in your company. It's easy to install, setup and customize. Your employees, partners and customers will immediately see results.

Use IdeaJam to:

  • Collect ideas from employees
  • Solicit feedback and suggestions from employees and customers
  • Run innovation contests and competitions
  • Validate concepts
  • Use the power of "crowd-sourcing" to rank ideas and allow the best ideas to rise to the top

IdeaJam™ works with:

  • IBM Connections
  • IBM Lotus Quickr
  • Blogs and Wikis
  • Websphere Portal
  • Microsoft Sharepoint
  • and other applications.

IdeaJam has an extensive set of widgets and API's that allow you to extend and integrate IdeaJam™ with other applications.

Learn more about IdeaJam >>

IdeaJam developed by

Elguji Software Logo