Please excuse my ignorance.
I previous lives I used Firebird events to trigger actions in clients.
In Firebird event notifications are initiated by Post_Event ‘Event name’ in a trigger.
Clients listen for these asynchronous events and respond to them.
Does LibreOffice support Firebird events?
Mick