4 Replies Latest reply on May 8, 2017 6:24 PM by beverly

    Adding Spaces to calc for email

    lukeamer

      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?