Embedded Views

HCL Domino Domino Forum
1

Hello

Question I have (just getting back into doing Lotus Notes Apps since 1998) and I need and

wonder how to pass a value to the selection criteria of the Embedded View from the Form.

My form is for Employee 123 and the embedded view shows all the class s/he took, but I can’t

for the life of me figure out how to do this.

Hope this is an option or if there are any other options ???

Thanks so much for your consideration.

2

Subject: Embedded Views

Wayne,

you can’t alter the selection formula of a view from a form.

What you can do is to only show a single category of the view which you have embedded. In your form, you need to specify which category from the view you want to display.

Do it like this:

  1. Create a CATEGORIZED view. Column1 has all the usernames and is categorized, Column2 has the classes s/he took.

  2. Embed this view into a form.

  3. On the form, select “embedded view properties”.

  4. There is a “show single category” property. Use this property to enter the name of the person (exactly as it is written in Column1) which you want to display. You can do this with any formula - including @Username if you want to create a personalized view - however, keep in mind that the first categorized column of the view must match EXACTLY the result from this formula!)

  5. You may also use a field on the form for reference (this allows the user to switch between keywords). In this case, remember to turn on the “refresh on keyword change” property on this field.

Have fun,

Stephan

3

Subject: RE: Embedded Views

One bug with this at the moment though is that the embedded view will not print properly from a view. This is a regression bug that I have discovered and has been confirmed by Lotus. Hopefully will be fixed in 6.02

4

Subject: RE: Embedded Views

I am trying to use an EMBEDDED SINGLE CATEGORY VIEW to show all (FORM2) documents COMPOSED from FORM 1.

FORM 2 is a response document composed when a hotspot button is clicked from FORM 1 and uses the following formula (@Command([ComposeWithReference]; “” : “” ; “Form2”; 1)

I have a view set up as with my first column (DocumentID (Value, @DocumentUniqueID) defined as ASCENDING, CATEGORIZED

I’m embedding this view into FORM 1. The embedded view is a SINGLE CATEGORY view with the Show Single Category value @DocumentUniqueID

When I preview, I get the error “Category must be a single string”

Any help that anyone can offer in getting this to work properly would be appreciated.

I think that I need more specific instructions as to how to put this all together. I’m only finding bits and pieces.

Thanks so much.

Faye

5

Subject: RE: Embedded Views

Hi,Did you solved the problem?

6

Subject: RE: Embedded Views

My problem was that the field I had listed in the Show Single Category field was a numeric field and it should have been a text field.

7

Subject: RE: Embedded Views

Dear Stephan

Thank you for putting me on the right track.

Since I haven’t done Lotus Notes in almost 5 years I’m rusty and with all the new advancements…kool.

Thanks much

I may have to beg a favor 'bout formulas next LOL.