Solved

Add category information to the subject line

Posted on 2002-04-22
9
314 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
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 
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

Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

Join & Write a Comment

I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Lack of Storage capacity is a common problem that exists in every field of life. Here we are taking the case of Lotus Notes Emails, as we all know that we are totally depend on e-communication i.e. Emails. This article is fully dedicated to resolvin…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

743 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

12 Experts available now in Live!

Get 1:1 Help Now