Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 347
  • Last Modified:

Add category information to the subject line

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
jason_turner
Asked:
jason_turner
  • 5
  • 4
1 Solution
 
HemanthaKumarCommented:
Use @Newline like this

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

~Hemanth
0
 
HemanthaKumarCommented:
To increase the row height, goto view properties and select lines per row to desired length (1-9).

0
 
jason_turnerAuthor Commented:
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
Independent Software Vendors: 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!

 
HemanthaKumarCommented:
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
 
jason_turnerAuthor Commented:
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
 
jason_turnerAuthor Commented:
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
 
HemanthaKumarCommented:
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
 
jason_turnerAuthor Commented:
Thanks for all the help you answered my orgianl question and then some.  
0
 
HemanthaKumarCommented:
Anytime
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 5
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now