Okay
  Public Ticket #3672112
Can you create automated alerts based on a calculation?
Closed

Comments

  • Mark McCormack started the conversation

    Hi guys,

    I'm wondering if there is a cron-like alert feature that runs at X intervals.

    So that management can be alerted via email to sales dropping by 10% or rising etc. or based on a pre-set query or report.

    I'm assuming and hoping that this has been asked and done before. Even in an addon.

    Love what I see so far btw ! :-)

    Mark

  •  1,819
    Miloš replied

    Hi Mark,

    Firstly, thank you for the kind words about the Plugin.

    I am sorry to disappoint you, but we do not have any built-in/'out of the box' way to send notifications such as Emails or similar via our Plugin.


    We also don't have a way to 'trigger' any kind of similar 'action' via a Conditional rule, such as 'if any cell from this Column drops below a certain value' then trigger an alert or something similar.

    You can suggest it to our developers, though - they will do their best to make a solution in the future.

    Please feel free to search on our suggestions page

     to see if someone may be already suggested this feature. If you can't see it, feel free to add your suggestion there,  and as more people vote, the feature will move higher on the priority list.

    You can certainly follow our changeLog page if you'd like ( it is also available in the plugin dashboard), where we state any changes/new features/bug fixes during updates;

    and our newsletter, so you're informed about new features, bug fixes, freebies, etc.

    -

    If you have coding skills and wish to try to make a custom solution now,

    you can check out our available hooks for Developers on this documentation and see if you can find any hook that might help.

    Please be advised that custom solutions with hooks are not included in our support.

    You can also research resources such as Stack Overflow to see if any other user perhaps found a workaround.

    ( We do like to give examples for certain solutions, but for this use-case, we, unfortunately, don't have anything yet)

    -

    The only 'as close as possible' example i have is, we had a custom example before, shared from our Developers.

    This was for a User who wanted to 'send an Email' with any edited Row;

    As soon as it is edited - the Email would get send.

    -

    For sending emails, you can use this:

    https://www.a2hosting.com/kb/installable-applications/optimization-and-configuration/wordpress2/sending-e-mail-in-wordpress#:~:text=To%20send%20an%20e%2Dmail,authentication%20settings%20you%20defined%20above

    And to take values after Apply is hit, there's this hook:

    wpdatatables_after_frontent_edit_row( $formdata, $rowId, $tableId ) This action is executed after editing action is applied.

    $formdata is the array of keys and values for editing.

    $rowId is the ID field of the row in MySQL table that was edited.

    $tableId is the table identifier from the MySQL plugin table (wp_wpdatatables).

    For example:

    function sendEmailAfterEdit( $formdata, $rowId, $tableId ){ // create logic for sending emails } add_action('wpdatatables_after_frontent_edit_row', 'sendEmailAfterEdit',10,3);

    will be triggered in both cases when you edit or adding a new row in the table from front-end. Please note that data is already saved in database.

    -

    Please note, our Support does not cover Custom solutions, we can just share some examples, i hope this helps as a 'starting point' if you have coding skills or your own developer to try a custom solution.


    Kind Regards, 

    Miloš Jovanović
    [email protected]

    Rate my support

    wpDataTables: FAQ | Facebook | Twitter | InstagramFront-end and back-end demo | Docs

    Amelia: FAQ | Facebook | Twitter | InstagramAmelia demo sites | Docs | Discord Community

    You can try wpDataTables add-ons before purchasing on these sandbox sites:

    Powerful Filters | Gravity Forms Integration for wpDataTables | Formidable Forms Integration for wpDataTables | Master-Detail Tables