Trigger only acting with new record?

mmol

Hi all,

Thanks for the great work. REI3 is a really awesome tool that helps a lot.
Currently, I ran into a problem with a trigger-function.

A made a more complex query inside a back-end function that a wanted to store as a attribute via a trigger-function. Unfortenely, this didn't work (most likely due to my limited sql-experience).

Then I simplified the function by assigning a fixed value to an attribute (see pic). Strangely, this works if I save a new records. But when an existing record is updated, nothing seems so change. What am I doing wrong? See below my minimal example.

Thanks a lot!

mmol

I was too impatient and found the solution. The trigger was coupled to the main table, while a was updating a subtable in the form. That was the reason the main_table was not updated and not triggered.

I will couple the trigger to the subtable.

thanks

gabriel

Thank you for the update - then we don´t have to look for bugs.

Welcome to the forum regardless 😉