• Recent
    • Tags
    • Popular
    • Register
    • Login

    Please Note This forum exists for community support for the Mango product family and the Radix IoT Platform. Although Radix IoT employees participate in this forum from time to time, there is no guarantee of a response to anything posted here, nor can Radix IoT, LLC guarantee the accuracy of any information expressed or conveyed. Specific project questions from customers with active support contracts are asked to send requests to support@radixiot.com.

    Radix IoT Website Mango 3 Documentation Website Mango 4 Documentation Website Mango 5 Documentation Website

    Adding point value to scheduled event email

    Mango Automation general Discussion
    3
    5
    1.6k
    Loading More Posts
    • Oldest to Newest
    • Newest to Oldest
    • Most Votes
    Reply
    • Reply as topic
    Log in to reply
    This topic has been deleted. Only users with topic management privileges can see it.
    • A
      Ataz
      last edited by

      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

      1 Reply Last reply Reply Quote 0
      • CraigWebC
        CraigWeb
        last edited by 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.

        1 Reply Last reply Reply Quote 0
        • phildunlapP
          phildunlap
          last edited by

          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

          1 Reply Last reply Reply Quote 0
          • A
            Ataz
            last edited by

            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
            0_1556748230541_749ed242-f0f6-4975-a641-b5923ac8180c-image.png
            I'll have a crack at using the information you have provided.
            Thanks again.
            Andy

            1 Reply Last reply Reply Quote 0
            • phildunlapP
              phildunlap
              last edited by

              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).

              1 Reply Last reply Reply Quote 0
              • First post
                Last post