Skip to main content
Solved

Email Templates - is it possible to display NOTES inside the message of an email template?

  • November 21, 2023
  • 2 replies
  • 134 views

Forum|alt.badge.img

we have a business event setup to email individuals when they have expense receipts pending their approval. We utilize the ‘NOTES’ section inside specific expense receipts to annotate to users what is missing (cost code, copy of receipt, etc).

When the business event triggers it sends an email template that contains information about the receipt and links them to it. 

Is there a way I can have whatever information is entered into the NOTES section of that expense receipt to appear in that Email Template message body?

From my GI screen, Expense Receipt Approval, I can view the notes on each individual receipt.

Example of what I want to show up in the Email Template message -

 

Example of the email template and where we’d like this to reside -

 

Best answer by darylbowman

You can expose NOTES to a GI, and since you’re using a GI as the basis for your email, I see no reason why you couldn’t.

 

  1. Join the PX.Data.Note table to the entity on *entity*.NoteID  Equals  Note.NoteID
  2. Expose the NoteText column to the GI
  3. Use the field in your email
View original
Did this topic help you find an answer to your question?

2 replies

darylbowman
Captain II
Forum|alt.badge.img+13
  • 1732 replies
  • Answer
  • November 21, 2023

You can expose NOTES to a GI, and since you’re using a GI as the basis for your email, I see no reason why you couldn’t.

 

  1. Join the PX.Data.Note table to the entity on *entity*.NoteID  Equals  Note.NoteID
  2. Expose the NoteText column to the GI
  3. Use the field in your email

Forum|alt.badge.img
  • Author
  • Jr Varsity II
  • 36 replies
  • November 21, 2023

Thank you @darylbowman I just wasn’t sure what table those Notes resided in as the Element Properties don’t quite reflect that. But that worked great.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings