Welcome to the #dominoforever Product Ideas Lab! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated jointly by the HCL Digital Solutions Product Management & HCL Development teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.

For more information and upcoming events around #dominoforever, please visit: the HCL Software website


Relational fields

I would like to have special field in the database what is working like a pointer to another document located in current or other database, the contents shown should be the field from remote document. Physically the link should be done by storing UNID of the remote document in this document, in designer on the from should be assigned the source database replica-id and field name. The Domino should automatically map document fields and show in the destination document the content from source document. The source database should be visible to everyone and be used as a lookup table. Changing the link should be possible thru lotus script.

  • Avatar32.5fb70cce7410889e661286fd7f1897de Guest
  • Jun 27 2019
  • Attach files
  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    27 Jun 17:49

    I see where you are going, and I’ll vote for it.

    However you can already achieve this yourself by storing a unid of the related document (but has to be in the same database), and use @getdocfield, to show fields from the related document on a form.

    caveats: Only links to the same database, and cannot be used in a view or for searching.

    Comment by Theo Heselmans

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    28 Jun 04:51

    I think what he's getting at here is having the field on the form but when saving the form it would save the value of that field in the original document instead of the current document. You can display fields from another document fine but saving is where the issue is. Correct me if I'm wrong here.

  • Avatar40.8f183f721a2c86cd98fddbbe6dc46ec9
    Guest commented
    28 Jun 10:50

    You can code this now including changes to the field in the original document even in another application (if that is what is being suggested) but you would also need to be sure you have a lock on the target when executing this.  Maybe a new field Type "Share Field" that allows the selecion of database / form / field and this meta information is stored but the field takes on the original field properties (text / numeric etc).  Additional options to display only / update on save / update on change and possibly a failure option eg allow save if source not avaiable.  Domino can then check for these types of field and deal with them as appropriate on loading / closing / saving.