Solved

Add category information to the subject line

Posted on 2002-04-22
9
326 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Problem "Can you help me recover my changes?  I double-clicked the attachment, made changes, and then hit Save before closing it.  But when I try to re-open it, my changes are missing!"    Solution This solution opens the Outlook Secure Temp Fold…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Sometimes it takes a new vantage point, apart from our everyday security practices, to truly see our Active Directory (AD) vulnerabilities. We get used to implementing the same techniques and checking the same areas for a breach. This pattern can re…

630 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