: 4582 | 108668 | 12353

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

: -23
: 3
: 26
: Domino Designer
: Designer, field
: Scott Cochrane1949 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 Menon3688 (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 Bahn3674 (24 Dec 2007)
I see no way, how this could be made possible with (disconnected) replicas at all.
3) Scott Cochrane1949 (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 Rizzo1428 (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 Cochrane1949 (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 >>

Better control over horizontal outlines
Implement "Live Scrolling" in Mail Views
Develop and open source a high quality framework for new DBs
InViewEdit - option to show <Ctrl-click here to add new document> at top of view
AJAX Suggest to work off Full Text search
Email Chaser View
Integrate Quickr Connectors into the Lotus Notes install, just as is done for Sametime
Fix the bug of @BrowserInfo
Push out Notes.ini parameters with a Desktop policy
Have Ctrl-T open a new browser tab in the Notes Client
Connect to more than one Sametime server in Notes client
Clear All Breakpoints
Include Request_Content in DocumentContext for Web Service Providers
Ability to detach and remove file attachments from multiple emails at once
Control integrated Sametime status settings
Extend options to set preferences for Rich Text
Add @DialogBox, @PickList and @Prompt for x-pages
HTML validation and accessibility for XPages
Add 'Move to My Contacts' button to the form
Stationary usable in reply and forward of emails
Copy text to the clipboard from the Properties dialog - especially the Replica ID
Publish API to work with calendar items, tasks and contacts

IdeaJam developed by

Elguji Software Logo