Skip to Main Content
HCL Domino Ideas Portal

Welcome to the #dominoforever Product Ideas Forum! 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 by HCL Product Management & Engineering 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 our Destination Domino Page

Status No Plans to Implement
Workspace Domino Designer
Created by Guest
Created on Jun 27, 2019

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.

  • Attach files
  • Guest
    Reply
    |
    Jun 28, 2019

    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.

  • Guest
    Reply
    |
    Jun 28, 2019

    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.

  • Guest
    Reply
    |
    Jun 27, 2019

    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