frmartell3
(Frank Martell)
March 30, 2023, 11:23pm
1
I am working on a transfer order email bpm to notify the when a TO has been created. I am able to get the data that I need, just trying to add some text to indicate what that data actually is. I can’t seem to add the text into the body with the data. Any suggestions would be helpful, this is the current body of the email. I’m trying to add the text before each selection.
Transfer Order
Transfer Order Line<MyFieldQuery (1)/>
Transfer From<MyFieldQuery (2)/>
Transfer To<MyFieldQuery (3)/>
Requested Date/Time<MyFieldQuery (4)/>
Need By Date/Time<MyFieldQuery (5)/>
Part Number<MyFieldQuery (6)/>
ckrusen
(Calvin Krusen)
March 30, 2023, 11:29pm
2
You’re using the email widget? Should be able to type right in.
Like the image in the following
If you have the Adv Print Routing, you can make a Report Style with Break Routing, for the invoice, and call that report from your DD
If you want (or need to do it all in the BPM), you can set the variable using the “Set Argument/Variable” widget with the following code:
Db.Customer.Where( r =>r.Company == callContextClient.CurrentCompany && r.CustNum == ttInvcHeadRow.CustNum).Select( r =>r.EMailAddress).DefaultIfEmpty("").FirstOrDefault()
Need more details than that?
Create a variable in …
klincecum
(Kevin Lincecum)
March 30, 2023, 11:35pm
3
And if the text is dynamic, add it in as query fields so you can reference it like the others.
frmartell3
(Frank Martell)
March 30, 2023, 11:36pm
4
not using APR, standard BPM Email. Typed in the text and nothing comes over.
ckrusen
(Calvin Krusen)
March 30, 2023, 11:37pm
5
So you don’t get an email, or you do get one but only field (part inside < > ) is in the body
Edit
I doubt it maters, but try putting a space between your static text and the field.
frmartell3
(Frank Martell)
March 30, 2023, 11:39pm
6
getting the email, but only the data not the text before each one.
000030 2 12 11 3/31/2023 12:00:00 AM 3/31/2023 12:00:00 AM E-0018-S082
ckrusen
(Calvin Krusen)
March 30, 2023, 11:41pm
7
I’d try removing all the fields and just entering static text to see if that comes through. Then add one field and try it.
Also odd that the line breaks aren’t maintained either.
klincecum
(Kevin Lincecum)
March 30, 2023, 11:42pm
8
HTML or Plain Text?
Edit: Nevermind, Widget doesn’t have that option.
ckrusen
(Calvin Krusen)
March 30, 2023, 11:46pm
9
The BPM widget is only text. Unless you use the following trick
Wow!! … Including the HTML framing (probably the wrong word) in the body of an email widget makes it HTML!!
How come I am just learning this now!!!
The “framing” required is
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
(This is an automated message. Please do not reply)
</body>
</html>
and you can define styles in the <head> section too!!!