Skip to main content
Question

Is it possible to display contents of a report attached to a message notification in the e-mail body in FSM?


AAHALK
Sidekick (Employee)
Forum|alt.badge.img+2
  • Sidekick (Employee)
  • 5 replies

Currently a notification message has been set-up to send a specific report that is triggered by a combination of Monitor Schedules and Business Rule. 

Is it possible to display the contents of the report in the e-mail body instead of only as an attachment. The request is to display contents of the report in the e-mail as well as to attach the report as a Excel file. The customer is using FSM 6 V 12.

Constraints:

  1.  The number of rows on the excel file generated as the report is not fixed
  2. Maximum rows on the excel file cannot be predicted
The report required to be displayed in the body of the message notifications

.

 

 

5 replies

Anjula Priyanath
Superhero (Employee)
Forum|alt.badge.img+15

Hi @AAHALK,

I don鈥檛 think you can display same as what you can see in the attachment. But, you would be able to use some dynamic values for message body.

As an example -

This is the sample message with dynamic value HERE

For this, you can create a notification message with dynamic value as below. Depending on your requirement, you can use actual table or view to extract these values.

 


AAHALK
Sidekick (Employee)
Forum|alt.badge.img+2
  • Author
  • Sidekick (Employee)
  • 5 replies
  • August 9, 2022

@Anjula Priyanath Thank you. However my requirement is a bit different.

 

I want to display in the notification message as a table with a fixed number of columns and unknown number of rows. Each cell will be filled with dynamic values. Like below

 

P1 P2 P3 P4
{{dynamic_value1}} {{dynamic_value2}} {{dynamic_value3}} {{dynamic_value4}}

 

Other issue is the number of rows too cannot be specified.


Anjula Priyanath
Superhero (Employee)
Forum|alt.badge.img+15

I don鈥檛 think it鈥檚 possible to do as we don鈥檛 have much control to config notification messages using tables, dynamic number of values for each variable, etc.

I believe this is the reason to use the report attached to the email in the current solution.


Saranga Amaraweera
Superhero
Forum|alt.badge.img+22

Hi @AAHALK ,

As @Anjula Priyanath  mentioned, the message body/text area is basically there to display static information. You can add a table with fixed number of columns via the HTML editor while setting fixed number of output parameters on it but unfortunately populating the data dynamically into it will be impossible as there is no such functionality to format the message text. As previously mentioned, the main idea behind attaching the report into the mail notification should be the same exact reason.


AAHALK
Sidekick (Employee)
Forum|alt.badge.img+2
  • Author
  • Sidekick (Employee)
  • 5 replies
  • August 10, 2022

Thank you for the responses @Anjula Priyanath and @Saranga Amaraweera 

 


Reply


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