Trigger after update not triggered when updating by copy&paste
I have a table with code for trigger after update (for the table, not a field).
When I edit an existing record by typing in a field, the trigger gets called as expected. When I use copy & paste to copy data from one record to another, the trigger does NOT get called, although the record gets updated.
This looks like a bug to me. If intended behavior, what is the motivation, and how can I make Ninox call the trigger for any update, including update by copy&paste?
8 replies
-
Hi Works as expected for me. Don't forget you have to move the focus away from the field for the trigger to take effect.
Can you share your trigger?
-
I tried it again using a table Trigger after update (because I didn't read your original post thoroughly), though (imho) it seems like better served with a field level trigger. And the only time it didn't work was if I created a new record in the table view and then pasted the data. Otherwise, with a record that is already there, if in a table view I double click in a cell and paste then clicked the enter key the reference field is properly updated.
I used your code, just slightly modified for my test DB:
let m := this.meta; let s := (select Table2 where meta = m); Table2 := first(s)
Content aside
- 2 mths agoLast active
- 8Replies
- 91Views
-
4
Following