Adding point value to scheduled event email

[Ataz]

Hi,
I am trying to create a simple email in event handler triggered by a scheduled event that sends the current value of a data point.
The scenario is to report a weekly reading of a water meter to a local government department via email.
In the UI, I made a scheduled event then added an email to it in Event Handler, adding the required data point in the "Additional Context" section. The email; gets sent fine but there is never any data point value included in the email.
Any advice on how to get this working is much appreciated.
I'm not at all familiar with scripting if that is required.

Thanks
Andy

[CraigWeb]

HI Ataz

In my opinion, you would be better off doing an excel report as I believe you would need to do some scripting to add the additional context point into the email. I have done the exact same for a water utility company and it is great because you can be creative with the rollups. eg, send last value of each day, week or month if it a flow meter you can do the daily delta or weekly delta. The reports give you a lot more freedom. It is also then in a format that is a lot easier for the utility to copy and paste into their internal spreadsheets.

[phildunlap]

Hi Ataz, welcome to the forum! Sorry for the delayed reponse!

This thread likely contains the information you're seeking about using additional context points to get more values in alarm emails.
https://forum.infiniteautomation.com/topic/3989/send-multiple-point-value-in-alarm-text

This thread may also contain useful information: https://forum.infiniteautomation.com/topic/4126/request-for-info-email-templates-for-data-points-notifications

[Ataz]

Thanks for the replies.
All I really need is to send a regular email (via scheduled events) which contains a single value ( a water meter reading) to the local council officer.
A normal report will work just fine if I select a date range of "previous 1 minute" as the data point is only logged every 5 minutes. It would just be cleaner not to have to send the chart graphic with minimum, maximum, average etc etc values in the email as well (all I really want to send is the one number a site identifier). See below

I'll have a crack at using the information you have provided.
Thanks again.
Andy

[phildunlap]

You can modify the FTL that generates that report. Take a peak in Mango/web/modules/reports/web/ftl and place any versions you write into Mango/overrides/web/modules/reports/web/ftl/ (may take restarting Mango if that directory is new).