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 Needs Review
Workspace Domino Designer
Categories @Formulas
Created by Guest
Created on Mar 21, 2024

Add ability to have @Commands in Show Single Category for embedded views

It would be nice to have the ability to use @commands such as @If(@Contains(@UserName;@DbLookup("" : ""; "Notes Glenville/Applied Robotics Inc." : "NAMES"; "Groups"; MyReports; "Members"));MyReports;"");

This would get if the user is in a group, to show only documents in the view that pertain to the group the user is in.

MyReports is a field that has the group name in it for what reports go to what group.

  • Attach files
  • Guest
    Mar 27, 2024

    A few things come to my mind when I look at your formula:

    @Contains expects the list you want to search to be the first argument, and the term or terms you want to search for in the list to be the second argument. Your formula looks as if you had it the other way around.

    Second, @DbLookup may return unexpected results when a list (more than one value) is supplied for the key parameter. I don't know if this can occur in your case though. It certainly is not an issue if field 'MyReports' can only contain a single value.

    Apart from that, it is possible to use @Formulas with Show Single Category. My experience is also that those formulas do work if they refer to one or more fields on the parent document (the document whose form contains the embedded view). It is true that @Commands do not work with Show Single Category, but your formula does not contain an @Command anyway.

  • Guest
    Mar 22, 2024

    Let me rephrase this. The @Commands work, it is the variable or field name that doesn't. If I hard code the MyReports the a group name such as "IS" then it works but because this is a field on the document, it does not.