2 Replies Latest reply on Oct 7, 2014 10:25 AM by JonathanOxborrow

    Script Trigger on Field change

    JonathanOxborrow

      Title

      Script Trigger on Field change

      Post

      I have job, labor, and fee tables in my database.  I currently have a script that will add a fee when a job's labor total reaches $100.  Sometimes there are errors in data entry and that total could drop below $100.  When that happens I need a way to delete the fee record that was created.  This might need to be done when a labor record is deleted or when the amount in the labor record is modified.  I'm pretty sure I can do it when the record is modified but I'm not sure how to run a script when a labor record is deleted.  Is there a way to run a script when a record is deleted?