0

Timer for delete record

there is a table where a lot of records are collected during the day. After 10 days, they are no longer relevant, and i need to delete them if there is no comment and claim from the buyer. Can I create a formula for automatic deletion?

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
    • Fred
    • Fred
    • 2 mths ago
    • Reported - view

    There isn’t a “timer” in Ninox. You can:

    1. Create a formula then have it run when you open the DB, or table, or tab
    2. Put the formula in a button, that you have to click every day
    Like 1
  • As Fred states ....

    You can automate in a kind of way by tracking the current date less x

    I used this code in the GLOBAL script area to delete old jobs and its associate child forms over approx 6 years old (ie ignoring leap years etc

     

    but as this one run when you log on also have an admin table form and have this in a button too ! for admin type tasks

    let myDate := today() - 2190;
    let myDel := dialog("Delete Multiple jobs from History File", "DELETE ALL JOBS OVER 6 YEARS OLD FROM CURRENT JOB FILE?

    Warning:- Once these jobs have been Deleted - They are gone forever!", ["Yes", "No"]);
    if myDel = "Yes" then
        let mySure := dialog("Sure?", "Are you Sure?", ["Yes", "No"]);
        if mySure = "Yes" then
            delete (select PurchaseOrders where 'Order Date' < myDate);
            delete (select DeliveryNotes where 'Delivery Date' < myDate);
            delete (select JobDockets where 'Order Date' < myDate);
            alert("Records have been deleted from the system")
        else
            alert("Okay - Nothing has been deleted")
        end
    else
        alert("Okay - Nothing has been deleted")
    end

    Like 1
    • Mel Charles Thanks for help

      Like
Like Follow
  • Status Answered
  • 2 mths agoLast active
  • 3Replies
  • 43Views
  • 3 Following