0

set reminder or send an email from Ninox if the date is due

I was wondering if there is a way to set up a reminder or send a custom email from Ninox database when the date is 21 days before the due day?

4 replies

null
    • cyan_silver
    • 3 yrs ago
    • Reported - view

    I also want to know what solution is there,Thanls.

    • Andrew Miller Photography
    • Andrew_Miller
    • 3 yrs ago
    • Reported - view

    Me to please!  Be good to set a reminder for sending invoices

    • Ninox partner
    • RoSoft_Steven.1
    • 3 yrs ago
    • Reported - view

    You could use the trigger after open from the options menu of the database (tab next to the Data model)

    Could use something like this:

    let z := (select Invoices where Date + 21 > today());
    let i := join(z.Invoicenumber, "
    ");
    let result := dialog("These Invoices are overdue. Do you want to mail?", i, ["Yes", "No", "Cancel"]);
    if result = "Yes" then
    alert("You pressed Yes and an email will be send")
    else
    if result = "No" then
    alert("You pressed No and nothing will happen")
    else
    if result = "Cancel" then void end
    end
    end

    This code must be altered to your situation but you get an idea of it.

    Steven

    • Choices_Software_Dean
    • 3 yrs ago
    • Reported - view

Content aside

  • 3 yrs agoLast active
  • 4Replies
  • 1224Views