String concatenation

Bryan

All,
Is there a way to put a carriage return in a string concatenation.

Example:
Company
Attribute: Address1
Attribute: City
Attribute: State
Attribute: Zipcode

Employee
Attribute: Address

Process to create new Employee
ENTER NEW Employee WITH Employee.Address=Company.Address1+' Carriage Return '+Company.City+', '+Company.State+' '+Company.Zipcode

I want to take what is now at the company level as:

123 Smith St
Springfield
MS
55555

and turn it into this at the Employee level

123 Smith St
Springfield, MS 55555

kklosson

There may be but I don't know it. I user <10,13> in some other languages. On the other hand, if you can split them, it's very easy to put the street address on one line and the city, st zip on the next. Just a thought.

Bryan

What do you mean by splitting the attributes? I am guessing that you mean splitting them out into two different attributes at the Employee level.

Thanks for the assistance

kklosson

I just mean in your presentation, wherever you are applying the information, you can present it with two strings instead of a multi-line text field.

tford

Bryan,

If you make a new attribute: SystemSettings.CR & populate it with a Carriage Return, you can then use that attribute in your rule.

kklosson

But Tom,

I think the issue is that we don't know how to insert a carriage return. What's the code?

Bryan

Any guidance on where to start with this?

tford

No code needed. Just go into the new SystemSettings attribute and made a carriage return. You won't see anything on the form, but you will see the result in your rules.

kklosson

Go figure.

Bryan

Sure enough it worked like a charm.

Bryan

I thought I had this working but now I am trying to input a carriage return into a different bsv as the SystemSettings.CR attribute. Once in the application I go to the CR attribute and hit carriage return which is takes fine though it appears that the save process clears out the carriage return prior to saving. When I go back into review that it was saved correctly there is nothing in the CR attribute.

tford

Have you tried to use the attribute in a rule?

Bryan

I am actually using it in a process that builds the body of and email. Nothing fancy I just need some breaks between sections of text.

Bryan

CREATE OutgoingEmail WITH OutgoingEmail.Message='Routing Description: <<Routing.Description>> <<SystemSettings.CR>> <<SystemSettings.CR>> Item Type: <<Routing.RoutedItemSCObjectIdentifier>> Item Subject: <<Routing.RoutedItemSCSubject>> <<SystemSettings.CR>> <<SystemSettings.CR>> Item Description: <<Routing.RoutedItemSCDescription>> <<SystemSettings.CR>> <<SystemSettings.CR>>'

tford

Bryan,

For email, you can use a Test type Document. In that document, you can do any formatting you desire without using CR attribute.

Bryan

I will look into that.

I just wonder though why this will not work. It would be easier just to format the thing inline as I have it.

Bryan

Alright, I ended up setting the OutgoingEmail.Message attribute to the HTML that I wanted with the layout already formatted. This method ended up being the most consistent in terms of output and rendering on the client side.

Example:
Routing Description: <<OutgoingEmail.RoutingDescription>>
 
Item Type: <<OutgoingEmail.RoutingItemType>>
 
Item Subject: <<OutgoingEmail.RoutingItemSubject>>
 
Item Description: <<OutgoingEmail.RoutingItemDescription>>

tford

Thanks for sharing that Bryan. I didn't know you could do it that way... makes sense that you can though.

Bryan

Yep, it ended up being a much easier method for what I was trying to accomplish than building and email document and then using it. With this method the email document can be generic and the formatting can all be done in the message.

Pretty sweet setup.