Solved

Add category information to the subject line

Posted on 2002-04-22
9
316 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
 
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
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Lotus notes email code 13 90
Unable to get Domino 9  Repeat AllDay Calendar Event via C&S API 2 215
Switching from Lotus Notes to Outlook 4 46
ESXCLI upgrade command 1 76
  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
This article covers general Notes 8.5 troubleshooting information including recreating the Notes\Data folder.
A company’s greatest vulnerability is their email. CEO fraud, ransomware and spear phishing attacks are the no1 threat to a company’s security. Cybercrime is responsible for the largest loss of money to companies today with losses projected to r…
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

948 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

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now