Solved

Add category information to the subject line

Posted on 2002-04-22
9
317 Views
Last Modified: 2013-12-18
I have a DB with an "all documents" view that I would like to add some category information to the subject line.  Rather than adding more columns I would like to make the subject line 2 lines high and add Category_1, and Category_2 on the second line of the normal subject.

Currently my subject line is a formula with the following column value.

@If(Form = "NonDelivery Report"; "DELIVERY FAILURE: " + FailureReason; Form = "Delivery Report"; "DELIVERED: " + Subject; Form = "Return Receipt"; "RECEIVED: " + Subject; Form = "ReturnNonReceipt"; "NOT RECEIVED: " + Subject; Subject)
0
Comment
Question by:jason_turner
  • 5
  • 4
9 Comments
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 6960412
Use @Newline like this

Category_1 + @Newline + Category_2 + @Newline + "RECEIVED:" + Subject

~Hemanth
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 6960418
To increase the row height, goto view properties and select lines per row to desired length (1-9).

0
 
LVL 1

Author Comment

by:jason_turner
ID: 6960662
I tried what you suggest but was not able to get the results I was looking for.  I found the following is desinger help

"In Notes, this function does not work in selection, hide-when, column, window title, form formulas, or inside of @Prompt."

After increasing the row height I tried varations of the following

Subject;
Category_1;
Category_2;

I also tried varations using the follow Designer tip

To add multiple lines to a single column row:
  1.     In the view properties box:
Change the Lines per row to the number of carriage returns you want to include in the row.
Select Shrink rows to content.
  2.     In the column properties box:
Choose New Line as the Multi-value separator.
Deselect the Show multiple values as separate entries checkbox.
  3.     In the code for the column formula, specify each string or number that you want to display on a new line as a separate value. Since you set the Multi-value separator to New Line, this inserts a carriage return between each value. For example, the following column formula vertically lists the content of the FirstName field above the content of the LastName field in the column row:
first:= FirstName;
last := LastName;
@Trim(first : last)


I hope not but one problem may be that Category_1 & Category_2 sometimes have multiple valuse.

The best I was able to achieve was the the first value of Category_1 and the first value of category_2 on the same line.  It would not show the other category values or the subject line.


0
NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 6960700
Ok here is how you do that.

Change the formula as,

LastLine := @If(Form = "NonDelivery Report"; "DELIVERY FAILURE: " + FailureReason; Form = "Delivery Report"; "DELIVERED: " + Subject; Form = "Return Receipt"; "RECEIVED: " + Subject; Form = "ReturnNonReceipt"; "NOT RECEIVED: " + Subject; Subject);

Category_1 : Category_2 : LastLine

And set multivalue seperator as NewLine. ans deselect show multi values as seperate entries.

Set the lines per row to max 9.

You should be all set.
0
 
LVL 1

Author Comment

by:jason_turner
ID: 6960862
Thanks for you help I ended up changing the order slightly.
I will except you answer.  Do you happen to know how to make the LastLine Bold and specific font size or is that another question?

LastLine := @If(Form = "NonDelivery Report"; "DELIVERY FAILURE: " + FailureReason; Form = "Delivery
Report"; "DELIVERED: " + Subject; Form = "Return Receipt"; "RECEIVED: " + Subject; Form = "ReturnNonReceipt";
"NOT RECEIVED: " + Subject; Subject);

LastLine : Categories_1 :  Categories_2

0
 
LVL 1

Author Comment

by:jason_turner
ID: 6961015
Thanks for you help I ended up changing the order slightly.
I will except you answer.  Do you happen to know how to make the LastLine Bold and specific font size or is that another question?

LastLine := @If(Form = "NonDelivery Report"; "DELIVERY FAILURE: " + FailureReason; Form = "Delivery
Report"; "DELIVERED: " + Subject; Form = "Return Receipt"; "RECEIVED: " + Subject; Form = "ReturnNonReceipt";
"NOT RECEIVED: " + Subject; Subject);

LastLine : Categories_1 :  Categories_2

0
 
LVL 24

Accepted Solution

by:
HemanthaKumar earned 200 total points
ID: 6961057
That is not possible on Notes end, but if you are showing the view in web, then it is possible.

Only way that you can make the las line distinct is to show them in uppercase.

@Uppercase(LastLine): Categories_1 :  Categories_2

0
 
LVL 1

Author Comment

by:jason_turner
ID: 6961177
Thanks for all the help you answered my orgianl question and then some.  
0
 
LVL 24

Expert Comment

by:HemanthaKumar
ID: 6961233
Anytime
0

Featured Post

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This is an old article, please see an updated version of this article, located here: http://www.experts-exchange.com/articles/23619/Notes-8-5x-Windows-7-Notes-info-and-tips.html
Notes Document Link used by IBM Notes is a link file which aids in the sharing of links to documents in email and webpages. The posts describe the importance and steps to create a Lotus Notes NDL file in brief.
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
Along with being a a promotional video for my three-day Annielytics Dashboard Seminor, this Micro Tutorial is an intro to Google Analytics API data.

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question