AnsweredAssumed Answered

Adding Spaces to calc for email

Question asked by lukeamer on May 8, 2017
Latest reply on May 8, 2017 by beverly

I have a log report that is a found set calculation sending to Outlook as plain text.

My script is returning correct data, but I would like to add spaces between some of the calculated results on each line.

The calculated field is written like this:

 

Case ( Note_Type="Trap Status"; GetAsTime(Date_Created_Timestamp) &" "&

Case(not(IsEmpty(TrapLocation));TrapLocation) & Case(not(IsEmpty(TrapStatus));" " & TrapStatus) &

Case(not(IsEmpty(Note Text)); " \" " &Note Text);

 

Note_Type="Aircraft Report";Date&Case(not(IsEmpty(AircraftUsed));" "& AircraftUsed);

Case(not(IsEmpty(Date_Created_Timestamp));

GetAsTime(Date_Created_Timestamp);" " &

Case(not(IsEmpty(Contact_Category));" "&Contact_Category )&

Case(not(IsEmpty(notes_CONTACTS::lastFirst));" "& notes_CONTACTS::lastFirst)); " "&

Case(not(IsEmpty(Note Text));" " &Note Text))

 

My "Send Mail" Script contains the following for the Message which point back to the fields above.

 

"TRAP LOG:¶"&$TrapLog&

"¶¶AIRCRAFT SUMMARY:¶"&$aircraftSummary

 

My output though looks like this in the email body

 

Trap Status

09:14:22 AM Simon Spence A13S missing. Replace.

Aircraft Report

11:04:12 PM Brent Far Magneto Destroyed.  Ordered new.

 

I would like it to look like this

Trap Status

09:14:22 AM       Simon Spence A13S missing. Replace.

Aircraft Report

11:04:12 PM       Brent Far Magneto Destroyed.  Ordered new.

 

Is this possible?

Outcomes